|
Thanks Juan!
Reproducible on 10.2-10.4, on debug and non-debug versions.
--source include/have_sequence.inc
|
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (
|
id int NOT NULL PRIMARY KEY,
|
a varchar(40),
|
b varchar(100),
|
c int,
|
va char(40) GENERATED ALWAYS AS (ucase(a)) VIRTUAL,
|
vb char(100) GENERATED ALWAYS AS (ucase(b)) VIRTUAL,
|
KEY (c,va,vb)
|
) engine=innodb;
|
|
insert into t1 (id,a,c) select seq,seq,seq from seq_1_to_10000;
|
|
alter table t1 drop column va;
|
|
#cleanup
|
drop table t1;
|
|
10.2 361e8284f3b8fadc8d9
|
#3 <signal handler called>
|
#4 0x000055bda24e8e44 in TABLE::update_virtual_field (this=0x7ff7a4049340, vf=0x0) at /10.2/sql/table.cc:7714
|
#5 0x000055bda29b84ea in innobase_get_computed_value (row=0x7ff7a40e1310, col=0x7ff7a400c1e0, index=0x7ff7a4185338, local_heap=0x7ff7f4412778, heap=0x0, ifield=0x7ff7a40575c8, thd=0x7ff7a4000b00, mysql_table=0x7ff7a4049340, mysql_rec=0x7ff7a4057c68 "\237", '\217' <repeats 45 times>, old_table=0x7ff7a40311e8, parent_update=0x0, foreign=0x0) at /10.2/storage/innobase/handler/ha_innodb.cc:21913
|
#6 0x000055bda2ac5582 in row_merge_buf_add (buf=0x7ff7a4054a78, fts_index=0x0, old_table=0x7ff7a40311e8, new_table=0x7ff7a40311e8, psort_info=0x0, row=0x7ff7a40e1310, ext=0x0, doc_id=0x7ff7f4412780, conv_heap=0x0, err=0x7ff7f441275c, v_heap=0x7ff7f4412778, my_table=0x7ff7a4049340, trx=0x7ff7f5f18140) at /10.2/storage/innobase/row/row0merge.cc:605
|
#7 0x000055bda2acb52d in row_merge_read_clustered_index (trx=0x7ff7f5f18140, table=0x7ff7a4049340, old_table=0x7ff7a40311e8, new_table=0x7ff7a40311e8, online=true, index=0x7ff7a40545a0, fts_sort_idx=0x0, psort_info=0x0, files=0x7ff7a411f030, key_numbers=0x7ff7a40545a8, n_index=1, add_cols=0x0, add_v=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=..., block=0x7ff7f40ce000 "\002\002\200", skip_pk_sort=false, tmpfd=0x7ff7f4413288, stage=0x7ff7a412d090, pct_cost=50, crypt_block=0x0, eval_table=0x7ff7a4187d60) at /10.2/storage/innobase/row/row0merge.cc:2566
|
#8 0x000055bda2ad0fb7 in row_merge_build_indexes (trx=0x7ff7f5f18140, old_table=0x7ff7a40311e8, new_table=0x7ff7a40311e8, online=true, indexes=0x7ff7a40545a0, key_numbers=0x7ff7a40545a8, n_indexes=1, table=0x7ff7a4049340, add_cols=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=false, stage=0x7ff7a412d090, add_v=0x0, eval_table=0x7ff7a4187d60) at /10.2/storage/innobase/row/row0merge.cc:4684
|
#9 0x000055bda29d9585 in ha_innobase::inplace_alter_table (this=0x7ff7a4183448, altered_table=0x7ff7a4049340, ha_alter_info=0x7ff7f4413ac0) at /10.2/storage/innobase/handler/handler0alter.cc:6253
|
#10 0x000055bda24b24bd in handler::ha_inplace_alter_table (this=0x7ff7a4183448, altered_table=0x7ff7a4049340, ha_alter_info=0x7ff7f4413ac0) at /10.2/sql/handler.h:3796
|
#11 0x000055bda24a7d9b in mysql_inplace_alter_table (thd=0x7ff7a4000b00, table_list=0x7ff7a4012550, table=0x7ff7a4187d60, altered_table=0x7ff7a4049340, ha_alter_info=0x7ff7f4413ac0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7ff7f4413b50, alter_ctx=0x7ff7f4414100) at /10.2/sql/sql_table.cc:7401
|
#12 0x000055bda24ad93a in mysql_alter_table (thd=0x7ff7a4000b00, new_db=0x7ff7a4012b68 "test", new_name=0x0, create_info=0x7ff7f4414d10, table_list=0x7ff7a4012550, alter_info=0x7ff7f4414c60, order_num=0, order=0x0, ignore=false) at /10.2/sql/sql_table.cc:9532
|
#13 0x000055bda252a62f in Sql_cmd_alter_table::execute (this=0x7ff7a4012b98, thd=0x7ff7a4000b00) at /10.2/sql/sql_alter.cc:339
|
#14 0x000055bda23dcfe9 in mysql_execute_command (thd=0x7ff7a4000b00) at /10.2/sql/sql_parse.cc:5972
|
#15 0x000055bda23e20b5 in mysql_parse (thd=0x7ff7a4000b00, rawbuf=0x7ff7a4012468 "alter table t1 drop column va", length=29, parser_state=0x7ff7f4416080, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:7759
|
#16 0x000055bda23d0378 in dispatch_command (command=COM_QUERY, thd=0x7ff7a4000b00, packet=0x7ff7a4096131 "alter table t1 drop column va", packet_length=29, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:1831
|
#17 0x000055bda23cec8c in do_command (thd=0x7ff7a4000b00) at /10.2/sql/sql_parse.cc:1385
|
#18 0x000055bda25251fb in do_handle_one_connection (connect=0x55bda5204560) at /10.2/sql/sql_connect.cc:1336
|
#19 0x000055bda2524f66 in handle_one_connection (arg=0x55bda5204560) at /10.2/sql/sql_connect.cc:1241
|
#20 0x000055bda2d532c4 in pfs_spawn_thread (arg=0x55bda520f350) at /10.2/storage/perfschema/pfs.cc:1862
|
#21 0x00007ff7fd9e06ba in start_thread (arg=0x7ff7f4417700) at pthread_create.c:333
|
#22 0x00007ff7fce7541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|