|
Found another test case with slightly different stack
CREATE TABLE t1 (a CHAR(1),b INT DEFAULT (a NOT IN ('','')));
|
ALTER TABLE t1 DROP COLUMN a,ADD COLUMN a BIGINT FIRST;
|
|
10.8.1 307b2991d61ff6734d858bdb211a88d1c8607a36 (Debug)
|
mysqld: /test/10.8_dbg/sql/item_cmpfunc.cc:367: bool convert_const_to_int(THD*, Item_field*, Item**): Assertion `!result' failed.
|
|
10.8.1 307b2991d61ff6734d858bdb211a88d1c8607a36 (Debug)
|
Core was generated by `/test/GAL_MD070222-mariadb-10.8.1-linux-x86_64-dbg/bin/mysqld --no-defaults --c'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
[Current thread is 1 (Thread 0x1518080aa700 (LWP 1232284))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x0000562d6f9955ed in my_write_core (sig=sig@entry=6) at /test/10.8_dbg/mysys/stacktrace.c:424
|
#2 0x0000562d6f17bce3 in handle_fatal_signal (sig=6) at /test/10.8_dbg/sql/signal_handler.cc:345
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x0000151809e7a859 in __GI_abort () at abort.c:79
|
#6 0x0000151809e7a729 in __assert_fail_base (fmt=0x15180a010588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x562d6fcf3358 "!result", file=0x562d6fcf15a8 "/test/10.8_dbg/sql/item_cmpfunc.cc", line=367, function=<optimized out>) at assert.c:92
|
#7 0x0000151809e8bf36 in __GI___assert_fail (assertion=assertion@entry=0x562d6fcf3358 "!result", file=file@entry=0x562d6fcf15a8 "/test/10.8_dbg/sql/item_cmpfunc.cc", line=line@entry=367, function=function@entry=0x562d6fcf1d48 "bool convert_const_to_int(THD*, Item_field*, Item**)") at assert.c:101
|
#8 0x0000562d6f1ccc6b in convert_const_to_int (thd=thd@entry=0x1517bc000db8, field_item=field_item@entry=0x1517bc043188, item=item@entry=0x1517bc0445c0) at /test/10.8_dbg/sql/item_cmpfunc.cc:367
|
#9 0x0000562d6f1dd8a0 in Item_func_in::value_list_convert_const_to_int (this=this@entry=0x1517bc0444a0, thd=thd@entry=0x1517bc000db8) at /test/10.8_dbg/sql/item_cmpfunc.cc:4485
|
#10 0x0000562d6f091451 in Type_handler_real_result::Item_func_in_fix_comparator_compatible_types (this=<optimized out>, thd=0x1517bc000db8, func=0x1517bc0444a0) at /test/10.8_dbg/sql/item_cmpfunc.h:2477
|
#11 0x0000562d6f1e3477 in Item_func_in::fix_length_and_dec (this=0x1517bc0444a0) at /test/10.8_dbg/sql/sql_type.h:7452
|
#12 0x0000562d6f20ced0 in Item_func::fix_fields (this=0x1517bc0444a0, thd=0x1517bc000db8, ref=<optimized out>) at /test/10.8_dbg/sql/item_func.cc:359
|
#13 0x0000562d6f1dd319 in Item_func_in::fix_fields (this=<optimized out>, thd=<optimized out>, ref=<optimized out>) at /test/10.8_dbg/sql/item_cmpfunc.cc:4328
|
#14 0x0000562d6ef9a5dc in fix_vcol_expr (thd=thd@entry=0x1517bc000db8, vcol=vcol@entry=0x1517bc044600) at /test/10.8_dbg/sql/table.cc:3596
|
#15 0x0000562d6ef9b522 in fix_and_check_vcol_expr (thd=thd@entry=0x1517bc000db8, table=table@entry=0x1518080a60b0, vcol=0x1517bc044600) at /test/10.8_dbg/sql/table.cc:3681
|
#16 0x0000562d6ef9bb34 in unpack_vcol_info_from_frm (thd=thd@entry=0x1517bc000db8, mem_root=mem_root@entry=0x1518080a6348, table=table@entry=0x1518080a60b0, expr_str=expr_str@entry=0x1518080a5810, vcol_ptr=0x1517bc0430c0, error_reported=error_reported@entry=0x1518080a5bc7) at /test/10.8_dbg/sql/table.cc:3807
|
#17 0x0000562d6ef9e9f9 in parse_vcol_defs (thd=thd@entry=0x1517bc000db8, mem_root=mem_root@entry=0x1518080a6348, table=table@entry=0x1518080a60b0, error_reported=error_reported@entry=0x1518080a5bc7, mode=VCOL_INIT_DEPENDENCY_FAILURE_IS_ERROR) at /test/10.8_dbg/sql/table.cc:1244
|
#18 0x0000562d6efa7a0c in open_table_from_share (thd=thd@entry=0x1517bc000db8, share=share@entry=0x1518080a7000, alias=alias@entry=0x1518080a7740, db_stat=db_stat@entry=0, prgflag=prgflag@entry=8, ha_open_flags=<optimized out>, outparam=<optimized out>, is_create_table=<optimized out>, partitions_to_open=<optimized out>) at /test/10.8_dbg/sql/table.cc:4187
|
#19 0x0000562d6ef670a0 in create_table_for_inplace_alter (table=0x1518080a60b0, share=0x1518080a7000, frm=0x1518080a5ee0, alter_ctx=@0x1518080a76e0: {implicit_default_value_error_field = 0x0, error_if_not_empty = false, tables_opened = 1, db = {str = 0x1517bc0145d0 "test", length = 4}, table_name = {str = 0x1517bc013eb8 "t0", length = 2}, storage_engine_name = {str = 0x1518080a7800 "InnoDB", length = 6}, alias = {str = 0x1517bc013eb8 "t0", length = 2}, new_db = {str = 0x1517bc0145d0 "test", length = 4}, new_name = {str = 0x1517bc013eb8 "t0", length = 2}, new_alias = {str = 0x1517bc013eb8 "t0", length = 2}, tmp_name = {str = 0x1518080a7c5c "#sql-alter-12cbe8-4", length = 19}, tmp_storage_engine_name = {str = 0x1518080a78c0 "InnoDB", length = 6}, tmp_id = {str = 0x1518080a67f0 "\207IaɈ\242\021\354\205)", length = 16}, id = {str = 0x1518080a77f0 "\207F\261\"\210\242\021\354\205)", length = 16}, tmp_buff = '\000' <repeats 64 times>, "\001", '\000' <repeats 14 times>, id_buff = "\207F\261\"\210\242\021\354\205)\000\032J\026\001@", storage_engine_buff = "InnoDB", '\000' <repeats 98 times>, "ȼ\001\274\027\025\000\000\250\327\001\274\027\025\000\000\000\000\000\000\000\000\000\000 \000\000\000\000\000\000\000\370\003\000\000\000\000\000\000\006\000\000\000\000\000\000\000\264n\373n-V", '\000' <repeats 26 times>, "@\275\001\274\027\025\000", tmp_storage_engine_buff = "InnoDB\000\000\002", '\000' <repeats 15 times>, "(\275\001\274\027\025\000\000P\275\001\274\027\025", '\000' <repeats 153 times>, storage_engine_partitioned = false, tmp_storage_engine_name_partitioned = false, fk_error_if_delete_row = false, fk_error_id = 0x0, fk_error_table = 0x0, modified_primary_key = false, tmp_table = false, new_filename = "./test/t0.frm", '\000' <repeats 177 times>, "\340\274\001\274\027\025\000\000\020", '\000' <repeats 15 times>..., new_alias_buff = "\274\027\025", '\000' <repeats 58 times>, "\301\211\001\000\000\000\000\000\006\000\000\000\000\000\000\000\006", '\000' <repeats 19 times>, "\001\000\000\000\003", '\000' <repeats 23 times>, "\001\000\000\000\003\000\000\000\001\000\000\000\002\000\000\000\002", '\000' <repeats 11 times>, "\002", '\000' <repeats 15 times>, "\002\000\000\000\001", '\000' <repeats 11 times>, "\b\000\000\000\000\000\000", tmp_name_buff = "#sql-alter-12cbe8-4\000\b\000\000\000\b\000\000\000\001\000\000\000\000\000\000\000@", '\000' <repeats 23 times>, "\004\000\000\000\v\000\000\000\001\000\000\000\001\001\000\001\000\000\000\000\001", '\000' <repeats 11 times>, "\003", '\000' <repeats 79 times>, "\325\230\316o-V\000\000\340\f\000\274\027\025\000\000\240}\n\b\030", path = "./test/t0\000\000.;\231o-V\000\000@}\n\b\030\025\000\000\356<\231o-V\000\000`}\n\b\030\025\000\000h\021\233o-V\000\000p}\n\b\030\025\000\000\000\233\347\032\026ۊ\r\220}\n\b\030\025\000\000hҶo-V\000\000\300\213\n\b\030\025\000\000.;\231o-V\000\000\220}\n\b\030\025\000\000\356<\231o-V\000\000\260}\n\b\030\025\000\000\000\233\347\032\026ۊ\rö\266o-V\000\000\270\r\000\274\027\025\000\000\000\000\000\000\000\000\000\000\bP\001\274\027\025\000\000@?\001\274\027\025\000\000 \211\n\b\030\025\000\000\340\205\n\b\030\025\000\000\334\r\366n-V\000\000\000\000\000\000\000\000\000\000\037"..., new_path = "./test/t0\000Ё\n\b\030\025\000\000\a\000\000\200", '\000' <repeats 12 times>, "`\177\n\b\030\025\000\000u\v\233o-V\000\000\200DDp-V\000\000\340\f\000\274\027\025\000\000\260\201\n\b\030\025\000\000\065\060\233o-V\000\000\340\f\000\274\027\025\000\000\060\202\n\b\030\025\000\000\v\000\000\200", '\000' <repeats 12 times>, "\260\177\n\b\030\025\000\000u\v\233o-V\000\000 \200\n\b\030\025\000\000\340\f\000\274\027\025\000\000\000\202\n\b\030\025\000\000\065\060\233o-V\000\000\340\f\000\274\027\025\000\000\200\202\n\b\030\025\000\000\340\f\000\274\027\025\000\000\240\202\n\b\030\025\000\000\006\000\000\200\000\000\000\000\000"..., tmp_path = "./test/#sql-alter-12cbe8-4\000\233o-V\000\000\220\203\n\b\030\025\000\000\340\f\000\274\027\025\000\000\240\203\n\b\030\025\000\000\065\060\233o-V\000\000\001F\001\274\027\025", '\000' <repeats 11 times>, "F\001\274\027\025\000\000\000\233\347\032\026ۊ\r\b\000\000\200\004\002\000\000\231\206\n\b\030\025\000\000\220\206\n\b\030\025\000\000\220\210\n\b\030\025\000\000\000\000\000\000\000\000\000\000\370E\001\274\027\025\000\000\060\206\n\b\030\025\000\000=\277\364n-V\000\000\n\000\000\200\000\000\000\000/\266\321o-V\000\000\340\f\000\274\027\025\000\000\200\202\n\b\030\025\000\000\340\f\000\274\027\025\000\000"...}, thd=0x1517bc000db8) at /test/10.8_dbg/sql/sql_table.cc:9531
|
#20 mysql_alter_table (thd=thd@entry=0x1517bc000db8, new_db=new_db@entry=0x1517bc005a60, new_name=new_name@entry=0x1517bc005e78, create_info=create_info@entry=0x1518080a84e0, table_list=<optimized out>, table_list@entry=0x1517bc013ef0, alter_info=alter_info@entry=0x1518080a83f0, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.8_dbg/sql/sql_table.cc:10609
|
#21 0x0000562d6eff84c7 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x1517bc000db8) at /test/10.8_dbg/sql/structs.h:568
|
#22 0x0000562d6ee7b64f in mysql_execute_command (thd=thd@entry=0x1517bc000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.8_dbg/sql/sql_parse.cc:5988
|
#23 0x0000562d6ee6208f in mysql_parse (thd=thd@entry=0x1517bc000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1518080a9400) at /test/10.8_dbg/sql/sql_parse.cc:8027
|
#24 0x0000562d6ee70df9 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1517bc000db8, packet=packet@entry=0x1517bc00b889 "ALTER TABLE t0 DROP COLUMN a,ADD COLUMN a BIGINT FIRST", packet_length=packet_length@entry=54, blocking=blocking@entry=true) at /test/10.8_dbg/sql/sql_class.h:1362
|
#25 0x0000562d6ee7424b in do_command (thd=0x1517bc000db8, blocking=blocking@entry=true) at /test/10.8_dbg/sql/sql_parse.cc:1402
|
#26 0x0000562d6eff0309 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x562d734d25f8, put_in_cache=put_in_cache@entry=true) at /test/10.8_dbg/sql/sql_connect.cc:1418
|
#27 0x0000562d6eff0911 in handle_one_connection (arg=arg@entry=0x562d734d25f8) at /test/10.8_dbg/sql/sql_connect.cc:1312
|
#28 0x0000562d6f4795dd in pfs_spawn_thread (arg=0x562d733c54a8) at /test/10.8_dbg/storage/perfschema/pfs.cc:2201
|
#29 0x000015180a389609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#30 0x0000151809f77293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
|