Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Description
CREATE TABLE t1 (k1 varchar(10) DEFAULT 5); |
CREATE TABLE t2 (i1 int); |
|
|
ALTER TABLE t1 ALTER COLUMN k1 SET DEFAULT (SELECT 1 FROM t2 limit 1); |
|
10.2 0c20b247de0c1cc7f993e1eba6 |
#3 <signal handler called>
|
#4 0x00007f3aea115428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#5 0x00007f3aea11702a in __GI_abort () at abort.c:89
|
#6 0x00007f3aea10dbd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x558024fcdfe0 "table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2", file=file@entry=0x558024fcd078 "/git/10.2/sql/handler.cc", line=line@entry=2576, function=function@entry=0x558024fcf620 <handler::ha_rnd_next(unsigned char*)::__PRETTY_FUNCTION__> "int handler::ha_rnd_next(uchar*)") at assert.c:92
|
#7 0x00007f3aea10dc82 in __GI___assert_fail (assertion=0x558024fcdfe0 "table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2", file=0x558024fcd078 "/git/10.2/sql/handler.cc", line=2576, function=0x558024fcf620 <handler::ha_rnd_next(unsigned char*)::__PRETTY_FUNCTION__> "int handler::ha_rnd_next(uchar*)") at assert.c:101
|
#8 0x00005580246ebec5 in handler::ha_rnd_next (this=0x7f3a9408cd38, buf=0x7f3a9408c8e0 "\377") at /git/10.2/sql/handler.cc:2575
|
#9 0x00005580246ed734 in handler::read_first_row (this=0x7f3a9408cd38, buf=0x7f3a9408c8e0 "\377", primary_key=64) at /git/10.2/sql/handler.cc:2815
|
#10 0x00005580244f62fd in handler::ha_read_first_row (this=0x7f3a9408cd38, buf=0x7f3a9408c8e0 "\377", primary_key=64) at /git/10.2/sql/sql_class.h:5829
|
#11 0x00005580244de453 in join_read_system (tab=0x7f3a94015320) at /git/10.2/sql/sql_select.cc:19296
|
#12 0x00005580244de010 in join_read_const_table (thd=0x7f3a94000b00, tab=0x7f3a94015320, pos=0x7f3a940158d8) at /git/10.2/sql/sql_select.cc:19192
|
#13 0x00005580244b8a8e in make_join_statistics (join=0x7f3a94014b10, tables_list=..., keyuse_array=0x7f3a94014e00) at /git/10.2/sql/sql_select.cc:4144
|
#14 0x00005580244afeb6 in JOIN::optimize_inner (this=0x7f3a94014b10) at /git/10.2/sql/sql_select.cc:1582
|
#15 0x00005580244ae3a9 in JOIN::optimize (this=0x7f3a94014b10) at /git/10.2/sql/sql_select.cc:1115
|
#16 0x00005580247b5792 in subselect_single_select_engine::exec (this=0x7f3a94013fe8) at /git/10.2/sql/item_subselect.cc:3811
|
#17 0x00005580247aab8f in Item_subselect::exec (this=0x7f3a94013e68) at /git/10.2/sql/item_subselect.cc:722
|
#18 0x00005580247ac8a3 in Item_singlerow_subselect::val_int (this=0x7f3a94013e68) at /git/10.2/sql/item_subselect.cc:1329
|
#19 0x000055802470b6ce in Item::save_in_field (this=0x7f3a94013e68, field=0x7f3a94014a30, no_conversions=true) at /git/10.2/sql/item.cc:6394
|
#20 0x000055802458c9f0 in make_empty_rec (thd=0x7f3a94000b00, buff=0x7f3a94090626 "\001", table_options=9, create_fields=..., reclength=12, data_offset=1) at /git/10.2/sql/unireg.cc:998
|
#21 0x000055802458a125 in build_frm_image (thd=0x7f3a94000b00, table=0x7f3a94012548 "t1", create_info=0x7f3adc112cd0, create_fields=..., keys=0, key_info=0x7f3a94014a18, db_file=0x7f3a94014338) at /git/10.2/sql/unireg.cc:308
|
#22 0x0000558024536eb7 in mysql_create_frm_image (thd=0x7f3a94000b00, db=0x7f3a94012b90 "test", table_name=0x7f3a94012548 "t1", create_info=0x7f3adc112cd0, alter_info=0x7f3adc112c20, create_table_mode=-2, key_info=0x7f3adc1113d8, key_count=0x7f3adc1113a8, frm=0x7f3adc111440) at /git/10.2/sql/sql_table.cc:4658
|
#23 0x00005580245378be in create_table_impl (thd=0x7f3a94000b00, orig_db=0x7f3a94012b90 "test", orig_table_name=0x7f3a94012548 "t1", db=0x7f3a94012b90 "test", table_name=0x7f3adc112100 "#sql-2ad7_9", path=0x7f3adc11296c "./test/#sql-2ad7_9", options=..., create_info=0x7f3adc112cd0, alter_info=0x7f3adc112c20, create_table_mode=-2, is_trans=0x0, key_info=0x7f3adc1113d8, key_count=0x7f3adc1113a8, frm=0x7f3adc111440) at /git/10.2/sql/sql_table.cc:4898
|
#24 0x0000558024542fc7 in mysql_alter_table (thd=0x7f3a94000b00, new_db=0x7f3a94012b90 "test", new_name=0x0, create_info=0x7f3adc112cd0, table_list=0x7f3a94012580, alter_info=0x7f3adc112c20, order_num=0, order=0x0, ignore=false) at /git/10.2/sql/sql_table.cc:9238
|
#25 0x00005580245be7a4 in Sql_cmd_alter_table::execute (this=0x7f3a94014078, thd=0x7f3a94000b00) at /git/10.2/sql/sql_alter.cc:329
|
#26 0x0000558024475d98 in mysql_execute_command (thd=0x7f3a94000b00) at /git/10.2/sql/sql_parse.cc:6228
|
#27 0x000055802447ae9f in mysql_parse (thd=0x7f3a94000b00, rawbuf=0x7f3a94012448 "ALTER TABLE t1 ALTER COLUMN k1 SET DEFAULT (SELECT 1 FROM t2 limit 1)", length=69, parser_state=0x7f3adc114080, is_com_multi=false, is_next_command=false) at /git/10.2/sql/sql_parse.cc:8015
|
#28 0x00005580244684f0 in dispatch_command (command=COM_QUERY, thd=0x7f3a94000b00, packet=0x7f3a94095e21 "ALTER TABLE t1 ALTER COLUMN k1 SET DEFAULT (SELECT 1 FROM t2 limit 1)", packet_length=69, is_com_multi=false, is_next_command=false) at /git/10.2/sql/sql_parse.cc:1826
|
#29 0x0000558024466e40 in do_command (thd=0x7f3a94000b00) at /git/10.2/sql/sql_parse.cc:1379
|
#30 0x00005580245b947c in do_handle_one_connection (connect=0x558026b7af40) at /git/10.2/sql/sql_connect.cc:1335
|
#31 0x00005580245b91fc in handle_one_connection (arg=0x558026b7af40) at /git/10.2/sql/sql_connect.cc:1241
|
#32 0x0000558024de7066 in pfs_spawn_thread (arg=0x558026ac1630) at /git/10.2/storage/perfschema/pfs.cc:1862
|
#33 0x00007f3aead526ba in start_thread (arg=0x7f3adc115700) at pthread_create.c:333
|
#34 0x00007f3aea1e741d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Stalled
-
-
-
- Open
-
(1 relates to)
Activity
create table t1 (k1 varchar(10) default 5); |
insert into t1 values (1),(2); |
create table t2 (i1 int); |
insert into t2 values (1),(2); |
alter table t1 alter column k1 set default (select i1 from t2 where i1=2); |
|
10.2 cac14b92252b3e7b |
/10.2/sql/sql_base.cc:5661: Field* find_field_in_table_ref(THD*, TABLE_LIST*, const char*, uint, const char*, const char*, const char*, Item**, bool, bool, uint*, bool, TABLE_LIST**): Assertion `table_list->table' failed.
|
|
|
sql/handler.cc:2625(handler::ha_rnd_next(unsigned char*))[0x562e69995a26]
|
sql/records.cc:485(rr_sequential(READ_RECORD*))[0x562e69cfee42]
|
sql/sql_select.cc:19685(join_init_read_record(st_join_table*))[0x562e694d57e8]
|
sql/sql_select.cc:18755(sub_select(JOIN*, st_join_table*, bool))[0x562e694cf276]
|
sql/sql_select.cc:18302(do_select(JOIN*, Procedure*))[0x562e694cd900]
|
sql/sql_select.cc:3623(JOIN::exec_inner())[0x562e6947021e]
|
sql/sql_select.cc:3419(JOIN::exec())[0x562e6946df24]
|
sql/item_subselect.cc:3897(subselect_single_select_engine::exec())[0x562e69b71c6e]
|
sql/item_subselect.cc:722(Item_subselect::exec())[0x562e69b53960]
|
sql/item_subselect.cc:1329(Item_singlerow_subselect::val_int())[0x562e69b58bbd]
|
sql/item.cc:6412(Item::save_in_field(Field*, bool))[0x562e699e6583]
|
sql/unireg.cc:998(make_empty_rec(THD*, unsigned char*, unsigned int, List<Create_field>&, unsigned int, unsigned long))[0x562e6967dc08]
|
sql/unireg.cc:308(build_frm_image(THD*, char const*, HA_CREATE_INFO*, List<Create_field>&, unsigned int, st_key*, handler*))[0x562e6967762b]
|
sql/sql_table.cc:4658(mysql_create_frm_image(THD*, char const*, char const*, HA_CREATE_INFO*, Alter_info*, int, st_key**, unsigned int*, st_mysql_const_unsigned_lex_string*))[0x562e695b0559]
|
sql/sql_table.cc:4898(create_table_impl(THD*, char const*, char const*, char const*, char const*, char const*, DDL_options_st, HA_CREATE_INFO*, Alter_info*, int, bool*, st_key**, unsigned int*, st_mysql_const_unsigned_lex_string*))[0x562e695b17e3]
|
sql/sql_table.cc:9298(mysql_alter_table(THD*, char*, char*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool))[0x562e695cc830]
|
sql/sql_alter.cc:329(Sql_cmd_alter_table::execute(THD*))[0x562e696ee591]
|
sql/sql_parse.cc:6231(mysql_execute_command(THD*))[0x562e693d5508]
|
sql/sql_parse.cc:8018(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x562e693dfd47]
|
sql/sql_parse.cc:1831(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x562e693bb233]
|
sql/sql_parse.cc:1379(do_command(THD*))[0x562e693b8362]
|
sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x562e696e096d]
|
sql/sql_connect.cc:1243(handle_one_connection)[0x562e696e0375]
|
perfschema/pfs.cc:1864(pfs_spawn_thread)[0x562e6a8905c8]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f220ac216ba]
|
x86_64/clone.S:111(clone)[0x7f220a0b641d]
|
|
from MDEV-19569:
--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 490dcfd5d74ce45cbdd6105e |
mysqld: /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.
|
190611 13:28:47 [ERROR] mysqld got signal 6 ;
|
|
|
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**))[0x559e45c83a19]
|
sql/sql_base.cc:6257(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x559e45c85251]
|
sql/item.cc:6053(Item_field::fix_fields(THD*, Item**))[0x559e46510719]
|
sql/item.h:825(Item::fix_fields_if_needed(THD*, Item**))[0x559e45b9746b]
|
sql/item.h:828(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x559e45b97499]
|
sql/sql_base.cc:7463(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool))[0x559e45c8b77e]
|
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*))[0x559e45e51136]
|
sql/item_subselect.cc:3676(subselect_single_select_engine::prepare(THD*))[0x559e466a9396]
|
sql/item_subselect.cc:276(Item_subselect::fix_fields(THD*, Item**))[0x559e466893a1]
|
sql/item.h:825(Item::fix_fields_if_needed(THD*, Item**))[0x559e45b9746b]
|
sql/item.h:828(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x559e45b97499]
|
sql/partition_info.h:404(partition_info::vers_set_interval(THD*, Item*, interval_type, long))[0x559e4634f307]
|
sql/sql_yacc.yy:6067(MYSQLparse(THD*))[0x559e462e3a23]
|
sql/sql_parse.cc:10100(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x559e45de5f50]
|
sql/sql_parse.cc:8058(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x559e45dd9cac]
|
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x559e45db4c1e]
|
sql/sql_parse.cc:1404(do_command(THD*))[0x559e45db1d82]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x559e46108cd0]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x559e461086ad]
|
perfschema/pfs.cc:1864(pfs_spawn_thread)[0x559e47431827]
|
|
10.5.5 e1013725ce0f3f947e728491eef75d9985e8db2f (optimized build) |
10.5.5>CREATE TABLE t1 (k1 varchar(10) DEFAULT 5);
|
Query OK, 0 rows affected (0.001 sec)
|
10.5.5>CREATE TABLE t2 (i1 int);
|
Query OK, 0 rows affected (0.001 sec)
|
10.5.5>ALTER TABLE t1 ALTER COLUMN k1 SET DEFAULT (SELECT 1 FROM t2 limit 1);
|
ERROR 1901 (HY000): Function or expression 'select ...' cannot be used in the DEFAULT clause of `k1`
|
Same error on 10.4.14 dc68846ec5ffdd6f08d93dc3bda123ff9cef04fa optimized.
Unique bug ID's seen:
table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2|SIGABRT|handler::ha_rnd_next|rr_sequential|READ_RECORD::read_record|join_init_read_record # Original and third testcase, 10.5.5, debug build
|
SIGSEGV|find_field_in_table|find_field_in_table_ref|find_field_in_tables|Item_field::fix_fields # Second, third and fourth testcase, 10.5.5, optimized build
|
table_list->table|SIGABRT|find_field_in_table_ref|find_field_in_tables|Item_field::fix_fields|Item::fix_fields_if_needed # Fourth testcase, 10.5.5, debug build
|
And, for comparison with MDEV-23159 (seems unrelated);
SIGSEGV|trnman_can_read_from|_ma_row_visible_transactional_table|maria_rprev|handler::ha_index_last # MDEV-23159 testcase + 2nd testcase, optimized
|
SIGSEGV|trnman_can_read_from|_ma_row_visible_transactional_table|maria_rnext|handler::ha_index_first # MDEV-23159 testcase + 3rd testcase, optimized
|
table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2|SIGABRT|handler::ha_index_last|get_index_max_value|opt_sum_query|JOIN::optimize_inner # MDEV-23159 testcase, debug
|
table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2|SIGABRT|handler::ha_index_first|get_index_min_value|opt_sum_query|JOIN::optimize_inner # MDEV-23159 2nd testcase, debug
|
And, for comparison with MDEV-19336:
expr == default_value->expr|SIGABRT|make_empty_rec_store_default|make_empty_rec|build_frm_image|mysql_create_frm_image # MDEV-19336, 10.5.5, original testcase, only crashes dbg
|
entry->pos_in_table_list->table == entry|SIGABRT|free_tmp_table|close_thread_tables|mysql_execute_command|mysql_parse # MDEV-19336, 10.5.5, optimized, and ERROR 1901 on optimized
|
/git/10.2/sql/sql_base.cc:5661: Field* find_field_in_table_ref(THD*, TABLE_LIST*, const char*, uint, const char*, const char*, const char*, Item**, bool, bool, uint*, bool, TABLE_LIST**): Assertion `table_list->table' failed.#7 0x00007fbcc28efc82 in __GI___assert_fail (assertion=0x55720b77d68d "table_list->table", file=0x55720b77ca20 "/git/10.2/sql/sql_base.cc", line=5661, function=0x55720b77f280 <find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned int, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**)::__PRETTY_FUNCTION__> "Field* find_field_in_table_ref(THD*, TABLE_LIST*, const char*, uint, const char*, const char*, const char*, Item**, bool, bool, uint*, bool, TABLE_LIST**)") at assert.c:101#8 0x000055720ac85a34 in find_field_in_table_ref (thd=0x7fbc70000b00, table_list=0x7fbc70034498, name=0x7fbc70091e58 "i1", length=2, item_name=0x7fbc70091e58 "i1", db_name=0x0, table_name=0x0, ref=0x7fbc70091f60, check_privileges=true, allow_rowid=true, cached_field_index_ptr=0x7fbc70091f24, register_tree_change=true, actual_table=0x7fbcb46f68a8) at /git/10.2/sql/sql_base.cc:5661#9 0x000055720ac86592 in find_field_in_tables (thd=0x7fbc70000b00, item=0x7fbc70091e60, first_table=0x7fbc70034498, last_table=0x0, ref=0x7fbc70091f60, report_error=REPORT_ALL_ERRORS, check_privileges=true, register_tree_change=true) at /git/10.2/sql/sql_base.cc:5961#10 0x000055720af8cc6f in Item_field::fix_fields (this=0x7fbc70091e60, thd=0x7fbc70000b00, reference=0x7fbc70091f60) at /git/10.2/sql/item.cc:5429#11 0x000055720ac89330 in setup_fields (thd=0x7fbc70000b00, ref_pointer_array=..., fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0x7fbc70035818, pre_fix=0x7fbc70092ff8, allow_sum_func=true) at /git/10.2/sql/sql_base.cc:7160#12 0x000055720ad30edb in JOIN::prepare (this=0x7fbc700354f8, tables_init=0x7fbc70034498, wild_num=0, conds_init=0x7fbc70034cc8, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fbc70092eb8, unit_arg=0x7fbc70093338) at /git/10.2/sql/sql_select.cc:814#13 0x000055720b0391b0 in subselect_single_select_engine::prepare (this=0x7fbc70035018, thd=0x7fbc70000b00) at /git/10.2/sql/item_subselect.cc:3675#14 0x000055720b02dae8 in Item_subselect::fix_fields (this=0x7fbc70034ec0, thd_param=0x7fbc70000b00, ref=0x7fbc70035068) at /git/10.2/sql/item_subselect.cc:269#15 0x000055720adf4d7d in fix_vcol_expr (thd=0x7fbc70000b00, vcol=0x7fbc70035058) at /git/10.2/sql/table.cc:2752#16 0x000055720adf517a in fix_and_check_vcol_expr (thd=0x7fbc70000b00, table=0x7fbc70091020, vcol=0x7fbc70035058) at /git/10.2/sql/table.cc:2837#17 0x000055720adf55d9 in unpack_vcol_info_from_frm (thd=0x7fbc70000b00, mem_root=0x7fbc70091ad8, table=0x7fbc70091020, expr_str=0x7fbcb46f8da0, vcol_ptr=0x7fbc70091d18, error_reported=0x7fbcb46f9121) at /git/10.2/sql/table.cc:2956#18 0x000055720adeed9a in parse_vcol_defs (thd=0x7fbc70000b00, mem_root=0x7fbc70091ad8, table=0x7fbc70091020, error_reported=0x7fbcb46f9121) at /git/10.2/sql/table.cc:1076#19 0x000055720adf6313 in open_table_from_share (thd=0x7fbc70000b00, share=0x7fbc7008fe60, alias=0x7fbcb46fa100 "#sql-1ab6_9", db_stat=0, prgflag=8, ha_open_flags=16, outparam=0x7fbc70091020, is_create_table=true) at /git/10.2/sql/table.cc:3202#20 0x000055720aee862c in THD::open_temporary_table (this=0x7fbc70000b00, share=0x7fbc7008fe60, alias=0x7fbcb46fa100 "#sql-1ab6_9", open_in_engine=false) at /git/10.2/sql/temporary_tables.cc:1091#21 0x000055720aee660c in THD::create_and_open_tmp_table (this=0x7fbc70000b00, hton=0x55720e9e1460, frm=0x7fbcb46f9440, path=0x7fbcb46fa96c "./test/#sql-1ab6_9", db=0x7fbc70012bb0 "test", table_name=0x7fbcb46fa100 "#sql-1ab6_9", open_in_engine=false) at /git/10.2/sql/temporary_tables.cc:76#22 0x000055720adc71d0 in mysql_alter_table (thd=0x7fbc70000b00, new_db=0x7fbc70012bb0 "test", new_name=0x0, create_info=0x7fbcb46facd0, table_list=0x7fbc700125a0, alter_info=0x7fbcb46fac20, order_num=0, order=0x0, ignore=false) at /git/10.2/sql/sql_table.cc:9295#23 0x000055720ae427a4 in Sql_cmd_alter_table::execute (this=0x7fbc70014400, thd=0x7fbc70000b00) at /git/10.2/sql/sql_alter.cc:329#24 0x000055720acf9d98 in mysql_execute_command (thd=0x7fbc70000b00) at /git/10.2/sql/sql_parse.cc:6228#25 0x000055720acfee9f in mysql_parse (thd=0x7fbc70000b00, rawbuf=0x7fbc70012448 "ALTER TABLE t1 ALTER COLUMN k1 SET DEFAULT (SELECT i1 FROM t2 WHERE i1 = 4 limit 1)", length=83, parser_state=0x7fbcb46fc080, is_com_multi=false, is_next_command=false) at /git/10.2/sql/sql_parse.cc:8015#26 0x000055720acec4f0 in dispatch_command (command=COM_QUERY, thd=0x7fbc70000b00, packet=0x7fbc70095e21 "ALTER TABLE t1 ALTER COLUMN k1 SET DEFAULT (SELECT i1 FROM t2 WHERE i1 = 4 limit 1) ", packet_length=84, is_com_multi=false, is_next_command=false) at /git/10.2/sql/sql_parse.cc:1826#27 0x000055720aceae40 in do_command (thd=0x7fbc70000b00) at /git/10.2/sql/sql_parse.cc:1379#28 0x000055720ae3d47c in do_handle_one_connection (connect=0x55720eff6f40) at /git/10.2/sql/sql_connect.cc:1335#29 0x000055720ae3d1fc in handle_one_connection (arg=0x55720eff6f40) at /git/10.2/sql/sql_connect.cc:1241#30 0x000055720b66b066 in pfs_spawn_thread (arg=0x55720ef3d630) at /git/10.2/storage/perfschema/pfs.cc:1862#31 0x00007fbcc35346ba in start_thread (arg=0x7fbcb46fd700) at pthread_create.c:333#32 0x00007fbcc29c941d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109on non-debug build:
CREATE TABLE t1 ( c1 text);
ALTER TABLE t1 ALTER COLUMN c1 SET DEFAULT (with cte as (select 2) select * from cte);
10.4 ca7fbcea6c4fe13c295
Version: '10.4.5-MariaDB-log'190425 16:30:12 [ERROR] mysqld got signal 11 ;/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fbf6bf3a390]sql/sql_base.cc:5912(find_field_in_table(THD*, TABLE*, char const*, unsigned long, bool, unsigned int*))[0x55f08b9bd75c]sql/sql_base.cc:6070(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**))[0x55f08b755b70]sql/sql_base.cc:6372(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x55f08b7f226b]sql/item.cc:5675(Item_field::fix_fields(THD*, Item**))[0x55f08ba3727d]sql/item.h:961(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x55f08b850a52]sql/sql_select.cc:1198(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55f08b850f83]sql/item_subselect.cc:3705(subselect_single_select_engine::prepare(THD*))[0x55f08b857366]sql/item_subselect.cc:282(Item_subselect::fix_fields(THD*, Item**))[0x55f08b85c681]sql/table.cc:3199(fix_vcol_expr(THD*, Virtual_column_info*) [clone .constprop.314])[0x55f08b83762f]sql/table.cc:3280(fix_and_check_vcol_expr)[0x55f08b888af2]sql/table.cc:1157(parse_vcol_defs(THD*, st_mem_root*, TABLE*, bool*))[0x55f08b7abe4e]sql/table.cc:3763(open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*))[0x55f08b7b3ab9]sql/sql_table.cc:9190(create_table_for_inplace_alter)[0x55f08b7b5d56]sql/sql_alter.cc:496(Sql_cmd_alter_table::execute(THD*))[0x55f08b7b7389]sql/sql_parse.cc:6344(mysql_execute_command(THD*))[0x55f08b884754]sql/sql_parse.cc:8154(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f08b884874]sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f08be1b8b4]/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fbf6bf306ba]/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fbf6b1c141d]Query (0x7fbf1c011f60): ALTER TABLE t1 ALTER COLUMN c1 SET DEFAULT (with cte as (select 2) select * from cte)