Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.3
-
None
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (f VARCHAR(4096), UNIQUE(f)) ENGINE=InnoDB; |
--error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
|
ALTER TABLE t1 DROP KEY f, ADD INDEX idx1(f), ALGORITHM=INSTANT; |
ALTER TABLE t1 ADD KEY idx2(f); |
|
# Cleanup
|
DROP TABLE t1; |
10.4 3b47587f debug |
mysqld: /data/src/10.4/sql/table.cc:8981: void setup_keyinfo_hash(KEY*): Assertion `key_info->key_part->field->flags & (1<< 30)' failed.
|
190304 12:47:41 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f861625bee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055c137f2991f in setup_keyinfo_hash (key_info=0x7f85bc00a018) at /data/src/10.4/sql/table.cc:8981
|
#9 0x000055c137edf4d1 in mysql_prepare_alter_table (thd=0x7f85bc000b00, table=0x7f85bc1a12c0, create_info=0x7f860b562cd0, alter_info=0x7f860b562c10, alter_ctx=0x7f860b5620e0) at /data/src/10.4/sql/sql_table.cc:8305
|
#10 0x000055c137ee313e in mysql_alter_table (thd=0x7f85bc000b00, new_db=0x7f85bc005290, new_name=0x7f85bc005690, create_info=0x7f860b562cd0, table_list=0x7f85bc015590, alter_info=0x7f860b562c10, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9609
|
#11 0x000055c137f720ee in Sql_cmd_alter_table::execute (this=0x7f85bc015d10, thd=0x7f85bc000b00) at /data/src/10.4/sql/sql_alter.cc:499
|
#12 0x000055c137e0348e in mysql_execute_command (thd=0x7f85bc000b00) at /data/src/10.4/sql/sql_parse.cc:6346
|
#13 0x000055c137e08636 in mysql_parse (thd=0x7f85bc000b00, rawbuf=0x7f85bc0154a8 "ALTER TABLE t1 ADD KEY idx2(f)", length=30, parser_state=0x7f860b564180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8157
|
#14 0x000055c137df3d24 in dispatch_command (command=COM_QUERY, thd=0x7f85bc000b00, packet=0x7f85bc139fd1 "ALTER TABLE t1 ADD KEY idx2(f)", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1829
|
#15 0x000055c137df24f8 in do_command (thd=0x7f85bc000b00) at /data/src/10.4/sql/sql_parse.cc:1358
|
#16 0x000055c137f6c003 in do_handle_one_connection (connect=0x55c13b97fd10) at /data/src/10.4/sql/sql_connect.cc:1399
|
#17 0x000055c137f6bd74 in handle_one_connection (arg=0x55c13b97fd10) at /data/src/10.4/sql/sql_connect.cc:1302
|
#18 0x000055c138462d17 in pfs_spawn_thread (arg=0x55c13b9c5b80) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#19 0x00007f8617f32494 in start_thread (arg=0x7f860b565700) at pthread_create.c:333
|
#20 0x00007f861631893f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
10.4 3b47587f non-debug |
#2 <signal handler called>
|
#3 0x000055dd5a24077e in fields_in_hash_keyinfo (keyinfo=keyinfo@entry=0x7f2b3c0c7850) at /data/src/10.4/sql/table.cc:8971
|
#4 0x000055dd5a240799 in setup_keyinfo_hash (key_info=key_info@entry=0x7f2b3c0c7850) at /data/src/10.4/sql/table.cc:8982
|
#5 0x000055dd5a212ef4 in mysql_prepare_alter_table (thd=thd@entry=0x7f2b3c0009a8, table=table@entry=0x7f2b3c081c28, create_info=create_info@entry=0x7f2b90131220, alter_info=alter_info@entry=0x7f2b90131160, alter_ctx=alter_ctx@entry=0x7f2b90130660) at /data/src/10.4/sql/sql_table.cc:8305
|
#6 0x000055dd5a21794d in mysql_alter_table (thd=<optimized out>, new_db=<optimized out>, new_name=<optimized out>, create_info=<optimized out>, table_list=0x7f2b3c011f88, alter_info=0x7f2b90131160, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9609
|
#7 0x000055dd5a26857b in Sql_cmd_alter_table::execute (this=0x7f2b3c0c7850, thd=0x7f2b3c0009a8) at /data/src/10.4/sql/sql_alter.cc:499
|
#8 0x000055dd5a180256 in mysql_execute_command (thd=thd@entry=0x7f2b3c0009a8) at /data/src/10.4/sql/sql_parse.cc:6346
|
#9 0x000055dd5a187711 in mysql_parse (thd=thd@entry=0x7f2b3c0009a8, rawbuf=<optimized out>, length=30, parser_state=parser_state@entry=0x7f2b901341d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:8157
|
#10 0x000055dd5a189f3f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f2b3c0009a8, packet=packet@entry=0x7f2b3c009b39 "ALTER TABLE t1 ADD KEY idx2(f)", packet_length=packet_length@entry=30, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:1829
|
#11 0x000055dd5a18b397 in do_command (thd=0x7f2b3c0009a8) at /data/src/10.4/sql/sql_parse.cc:1358
|
#12 0x000055dd5a26594c in do_handle_one_connection (connect=connect@entry=0x55dd5d629718) at /data/src/10.4/sql/sql_connect.cc:1399
|
#13 0x000055dd5a265ab4 in handle_one_connection (arg=arg@entry=0x55dd5d629718) at /data/src/10.4/sql/sql_connect.cc:1302
|
#14 0x000055dd5a583154 in pfs_spawn_thread (arg=0x55dd5d629778) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#15 0x00007f2b97a93494 in start_thread (arg=0x7f2b90135700) at pthread_create.c:333
|
#16 0x00007f2b95e7993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Attachments
Issue Links
- is caused by
-
MDEV-371 Unique indexes for blobs
- Closed