Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Description
INSTALL SONAME 'ha_connect'; |
CREATE TABLE t1 (c INT NOT NULL, KEY idx(c)) ENGINE=CONNECT; |
INSERT INTO t1 VALUES (1), (2); |
SET alter_algorithm=COPY; |
DROP INDEX idx ON t1; |
|
# Cleanup
|
DROP TABLE t1; |
UNINSTALL SONAME 'ha_connect'; |
10.8 e4b83f0f |
#3 <signal handler called>
|
#4 0x00007f7a83562717 in ha_connect::create (this=0x61d00023beb8, name=0x7f7a83ee8a7f "./test/#sql-alter-27789b-4", table_arg=0x7f7a83ee54a0, create_info=0x7f7a83ee92d0) at /data/src/10.8/storage/connect/ha_connect.cc:6955
|
#5 0x0000561d3a2030d3 in handler::ha_create (this=0x61d00023beb8, name=0x7f7a83ee8a7f "./test/#sql-alter-27789b-4", form=0x7f7a83ee54a0, info_arg=0x7f7a83ee92d0) at /data/src/10.8/sql/handler.cc:5496
|
#6 0x0000561d3a207822 in ha_create_table (thd=0x62b00007e218, path=0x7f7a83ee8a7f "./test/#sql-alter-27789b-4", db=0x6290000e6a88 "test", table_name=0x6290000e62f8 "t1", create_info=0x7f7a83ee92d0, frm=0x7f7a83ee6190, skip_frm_file=false) at /data/src/10.8/sql/handler.cc:5964
|
#7 0x0000561d39c1d3d7 in mysql_alter_table (thd=0x62b00007e218, new_db=0x6290000e6390, new_name=0x6290000e63a0, create_info=0x7f7a83ee92d0, table_list=0x6290000e6378, recreate_info=0x7f7a83ee9080, alter_info=0x7f7a83ee91a0, order_num=0, order=0x0, ignore=false, if_exists=false) at /data/src/10.8/sql/sql_table.cc:10868
|
#8 0x0000561d3992d6dd in mysql_execute_command (thd=0x62b00007e218, is_called_from_prepared_stmt=false) at /data/src/10.8/sql/sql_parse.cc:4213
|
#9 0x0000561d399484af in mysql_parse (thd=0x62b00007e218, rawbuf=0x6290000e6238 "DROP INDEX idx ON t1", length=20, parser_state=0x7f7a83ee9a30) at /data/src/10.8/sql/sql_parse.cc:8019
|
#10 0x0000561d3991e64a in dispatch_command (command=COM_QUERY, thd=0x62b00007e218, packet=0x629000262219 "DROP INDEX idx ON t1", packet_length=20, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1894
|
#11 0x0000561d3991b3a3 in do_command (thd=0x62b00007e218, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1407
|
#12 0x0000561d39dbc7b2 in do_handle_one_connection (connect=0x608000002e38, put_in_cache=true) at /data/src/10.8/sql/sql_connect.cc:1416
|
#13 0x0000561d39dbc173 in handle_one_connection (arg=0x608000002db8) at /data/src/10.8/sql/sql_connect.cc:1318
|
#14 0x0000561d3a99b276 in pfs_spawn_thread (arg=0x617000005b98) at /data/src/10.8/storage/perfschema/pfs.cc:2201
|
#15 0x00007f7a8b6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#16 0x00007f7a8b72866c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
The failure started happening after this commit in 10.8:
commit 4c6e8fc572e5a1dbe100f20d471be65aecbb5225
|
Author: Sergei Golubchik
|
Date: Mon Jan 24 18:38:12 2022 +0100
|
|
MDEV-27591 Connect tables (FIX/DOS) don't work with DESC keys - wrong results
|
Attachments
Issue Links
- is caused by
-
MDEV-27591 Connect tables (FIX/DOS) don't work with DESC keys - wrong results
- Closed