Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5, 10.6, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL)
Description
--source include/have_partition.inc
|
create table t1 (i int); |
create table t2 (i int); |
|
ALTER TABLE t1 PARTITION BY system_time |
INTERVAL (SELECT i FROM t2) DAY (PARTITION p1 HISTORY, PARTITION pn CURRENT) ; |
10.3 592dc59d7a5f9bd80bffdd9d |
|
/10.3/sql/sql_base.cc:5955: Field* find_field_in_table_ref(THD*, TABLE_LIST*, const char*, size_t, const char*, const char*, const char*, Item**, bool, bool, uint*, bool, TABLE_LIST**): Assertion `table_list->table' failed.
|
|
linux/raise.c:54(__GI_raise)[0x7f9e7674f428]
|
stdlib/abort.c:91(__GI_abort)[0x7f9e7675102a]
|
assert/assert.c:92(__assert_fail_base)[0x7f9e76747bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f9e76747c82]
|
sql/sql_base.cc:5956(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned long, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**))[0x564e28719709]
|
sql/sql_base.cc:6257(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x564e2871af41]
|
sql/item.cc:6053(Item_field::fix_fields(THD*, Item**))[0x564e28fa49ab]
|
sql/item.h:825(Item::fix_fields_if_needed(THD*, Item**))[0x564e2862d15b]
|
sql/item.h:828(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x564e2862d189]
|
sql/sql_base.cc:7463(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool))[0x564e2872146e]
|
sql/sql_select.cc:1102(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x564e288e6e26]
|
sql/item_subselect.cc:3676(subselect_single_select_engine::prepare(THD*))[0x564e2913d628]
|
sql/item_subselect.cc:276(Item_subselect::fix_fields(THD*, Item**))[0x564e2911d633]
|
sql/item.h:825(Item::fix_fields_if_needed(THD*, Item**))[0x564e2862d15b]
|
sql/item.h:828(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x564e2862d189]
|
sql/partition_info.h:404(partition_info::vers_set_interval(THD*, Item*, interval_type, long))[0x564e28de3599]
|
sql/sql_yacc.yy:6067(MYSQLparse(THD*))[0x564e28d77cb5]
|
sql/sql_parse.cc:10093(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x564e2887bc40]
|
sql/sql_parse.cc:8051(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x564e2886f99c]
|
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x564e2884a90e]
|
sql/sql_parse.cc:1404(do_command(THD*))[0x564e28847a72]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x564e28b9db16]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x564e28b9d4f3]
|
perfschema/pfs.cc:1864(pfs_spawn_thread)[0x564e29ec536d]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f9e7738c6ba]
|
x86_64/clone.S:111(clone)[0x7f9e7682141d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x62b000000288): ALTER TABLE t1 PARTITION BY system_time INTERVAL (SELECT i FROM t2) DAY (PARTITION p1 HISTORY, PARTITION pn CURRENT)
|
|
non-debug build fails with sig 11
201002 16:04:18 [ERROR] mysqld got signal 11 ;
|
|
Server version: 10.5.5-MariaDB
|
|
sql/sql_base.cc:5933(find_field_in_table(THD*, TABLE*, char const*, unsigned long, bool, unsigned int*))[0x5578c6e3d4ec]
|
sql/sql_base.cc:6091(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned long, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**))[0x5578c6e3d90c]
|
sql/sql_base.cc:6394(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x5578c70c8ca7]
|
sql/item.cc:5817(Item_field::fix_fields(THD*, Item**))[0x5578c6e3e099]
|
sql/item.h:986(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool))[0x5578c6ee6eea]
|
sql/sql_select.cc:1250(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x5578c715b788]
|
sql/item_subselect.cc:3775(subselect_single_select_engine::prepare(THD*))[0x5578c715aa95]
|
sql/item_subselect.cc:285(Item_subselect::fix_fields(THD*, Item**))[0x5578c6f7bd98]
|
sql/item.h:986(partition_info::vers_set_interval(THD*, Item*, interval_type, Item*, char const*))[0x5578c702a9b2]
|
sql/sql_yacc.yy:5341(MYSQLparse(THD*))[0x5578c6ea530d]
|
sql/sql_parse.cc:10352(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x5578c6ea5576]
|
sql/sql_parse.cc:7949(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5578c6ea76d2]
|
sql/sql_parse.cc:1927(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5578c6ea8b5b]
|
sql/sql_parse.cc:1353(do_command(THD*))[0x5578c6f90b92]
|
sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x5578c6f90e44]
|
sql/sql_connect.cc:1318(handle_one_connection)[0x5578c730e02d]
|
nptl/pthread_create.c:487(start_thread)[0x7f50bbc1afa3]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f50bb7f44cf]
|
|
Query (0x7f505c011c30): ALTER TABLE t1 PARTITION BY system_time INTERVAL (SELECT i FROM t2) DAY (PARTITION p1 HISTORY, PARTITION pn CURRENT)
|
Attachments
Issue Links
- blocks
-
MDEV-26634 Feature request: add STATEMENT_DIGEST_TEXT
- Closed
- relates to
-
MDEV-18136 Server crashes in Item_func_dyncol_create::prepare_arguments
- Closed
-
MDEV-25012 Server crash in find_field_in_tables, Assertion `name' failed in find_field_in_table_ref
- Confirmed
-
MDEV-28510 SIGSEGV in get_sort_by_table and SIGSEGV in subquery_types_allow_materialization
- Closed
-
MDEV-18163 Assertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2' failed in handler::ha_rnd_next(); / Assertion `table_list->table' failed in find_field_in_table_ref / ERROR 1901 (on optimized builds)
- Closed
-
MDEV-28505 Server crash in sql/sql_select.cc:19830 in sub_select(JOIN*, st_join_table*, bool)
- Closed
-
MDEV-28506 SIGSEGV's in find_field_in_table[s][_ref], Item_field::fix_fields, create_view_field and MemcmpInterceptorCommon | Assertions `(*select_ref)->fixed' or '->is_fixed' and `table_list->table' failed
- Stalled