--source include/have_innodb.inc
|
CREATE TABLE t3 ( col1 INT, col_int INTEGER, col_text TEXT ) ENGINE = InnoDB;
|
ALTER TABLE t3 ADD PRIMARY KEY ( col_text(9), col_int ) ;
|
ALTER TABLE t3 ADD INDEX ( col_int, col1 ) ;
|
ALTER TABLE t3 ADD COLUMN col_int_g_copy INTEGER GENERATED ALWAYS AS (col_int) ;
|
ALTER TABLE t3 CHANGE COLUMN IF EXISTS col1 otto INT ;
|
# The last statement leads to crash.
|
DROP TABLE t3;
|
|
Version: '10.6.0-MariaDB-debug-log' socket: '/home/mleich/Server_bin/10.6_debug/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
|
2021-02-02 12:58:25 4 [ERROR] InnoDB: No matching column for `col1` in index `col_int` of table `test`.`t3`
|
210202 12:58:25 [ERROR] mysqld got signal 11 ;
|
Query (0x7f4e54012dc0): ALTER TABLE t3 CHANGE COLUMN IF EXISTS col1 otto INT
|
|
Connection ID (thread ID): 4
|
Status: NOT_KILLED
|
|
#0 __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
#1 0x0000556d35791e13 in my_write_core (sig=11) at /home/mleich/Server/10.6/mysys/stacktrace.c:424
|
#2 0x0000556d34e83b08 in handle_fatal_signal (sig=11) at /home/mleich/Server/10.6/sql/signal_handler.cc:330
|
#3 <signal handler called>
|
#4 0x0000556d3533ea7c in dict_stats_try_drop_table (thd=0x7f4e54000cf8, name=..., table_name=...) at /home/mleich/Server/10.6/storage/innobase/handler/handler0alter.cc:10096
|
#5 0x0000556d3533ebf7 in innobase_reload_table (thd=0x7f4e54000cf8, table=0x0, table_name=..., ctx=...) at /home/mleich/Server/10.6/storage/innobase/handler/handler0alter.cc:10133
|
#6 0x0000556d353417fc in ha_innobase::commit_inplace_alter_table (this=0x7f4e541c87d0, altered_table=0x7f4e7d62d960, ha_alter_info=0x7f4e7d62d8c0, commit=true) at /home/mleich/Server/10.6/storage/innobase/handler/handler0alter.cc:11263
|
#7 0x0000556d34e94a3e in handler::ha_commit_inplace_alter_table (this=0x7f4e541c87d0, altered_table=0x7f4e7d62d960, ha_alter_info=0x7f4e7d62d8c0, commit=true) at /home/mleich/Server/10.6/sql/handler.cc:4855
|
#8 0x0000556d34c27462 in mysql_inplace_alter_table (thd=0x7f4e54000cf8, table_list=0x7f4e54012ed0, table=0x7f4e5419c2a8, altered_table=0x7f4e7d62d960, ha_alter_info=0x7f4e7d62d8c0, target_mdl_request=0x7f4e7d62dd30, alter_ctx=0x7f4e7d62e880) at /home/mleich/Server/10.6/sql/sql_table.cc:8138
|
#9 0x0000556d34c2ebd8 in mysql_alter_table (thd=0x7f4e54000cf8, new_db=0x7f4e54005768, new_name=0x7f4e54005b68, create_info=0x7f4e7d62f490, table_list=0x7f4e54012ed0, alter_info=0x7f4e7d62f3c0, order_num=0, order=0x0, ignore=false, if_exists=false) at /home/mleich/Server/10.6/sql/sql_table.cc:10683
|
#10 0x0000556d34cd4d71 in Sql_cmd_alter_table::execute (this=0x7f4e540136c0, thd=0x7f4e54000cf8) at /home/mleich/Server/10.6/sql/sql_alter.cc:539
|
#11 0x0000556d34b3034d in mysql_execute_command (thd=0x7f4e54000cf8) at /home/mleich/Server/10.6/sql/sql_parse.cc:5880
|
#12 0x0000556d34b365e1 in mysql_parse (thd=0x7f4e54000cf8, rawbuf=0x7f4e54012dc0 "ALTER TABLE t3 CHANGE COLUMN IF EXISTS col1 otto INT", length=52, parser_state=0x7f4e7d630520) at /home/mleich/Server/10.6/sql/sql_parse.cc:7906
|
#13 0x0000556d34b22af5 in dispatch_command (command=COM_QUERY, thd=0x7f4e54000cf8, packet=0x7f4e540087b9 "ALTER TABLE t3 CHANGE COLUMN IF EXISTS col1 otto INT ", packet_length=53) at /home/mleich/Server/10.6/sql/sql_parse.cc:1833
|
#14 0x0000556d34b2143d in do_command (thd=0x7f4e54000cf8) at /home/mleich/Server/10.6/sql/sql_parse.cc:1365
|
#15 0x0000556d34cca462 in do_handle_one_connection (connect=0x556d37f62df8, put_in_cache=true) at /home/mleich/Server/10.6/sql/sql_connect.cc:1410
|
#16 0x0000556d34cca1d0 in handle_one_connection (arg=0x556d37f50f08) at /home/mleich/Server/10.6/sql/sql_connect.cc:1312
|
#17 0x0000556d3520e213 in pfs_spawn_thread (arg=0x556d37ebab18) at /home/mleich/Server/10.6/storage/perfschema/pfs.cc:2201
|
#18 0x00007f4e88f8d7fc in start_thread (arg=0x7f4e7d631700) at pthread_create.c:465
|
#19 0x00007f4e881c3b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
|
10.6 8a495d7f90f64566d083d9ccd04cd95023a40931 2021-01-30T10:50:14+03:00
|
origin/10.5 7c052cdf0bc53f8ee3387186993710bd9754b65d 2021-01-17T13:21:55+01:00
|
origin/10.4 542d769ea1a22a7a6a87c9fe76ff911a162ade44 2021-01-28T07:39:34+02:00
|
origin/10.3 df1eefb2ad138846269d40372678af805589700a 2021-01-07T17:53:04+01:00
|
no replay on some 10.2 development tree mid of January
|
Bug
Critical