Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
-
10.2.2-1
Description
CREATE TABLE t (i INT) ENGINE=MyISAM; |
CREATE TEMPORARY TABLE tmp LIKE t; |
ALTER TABLE tmp RENAME TO t; |
|
SELECT ( SELECT 1 FROM t a1, t a2 ) AS f1, ( SELECT 2 FROM t a3 ) AS f2 FROM DUAL; |
Stack trace from 10.2 commit b2ae32aafdd2787ad456f38833f630182ded25e8 |
mysqld: /src/10.2/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
|
160613 0:57:09 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f669b9e01d2 in __assert_fail () from /lib64/libc.so.6
|
#8 0x00005628ab8c546d in test_if_reopen (filename=0x7f669dcac800 "/bld/10.2/mysql-test/var/tmp/mysqld.1/#sql3f1e_3_1.MYI") at /src/10.2/storage/myisam/mi_open.c:66
|
#9 0x00005628ab8c5669 in mi_open (name=0x7f669219e158 "/bld/10.2/mysql-test/var/tmp/mysqld.1/#sql3f1e_3_1", mode=2, open_flags=82) at /src/10.2/storage/myisam/mi_open.c:117
|
#10 0x00005628ab899a75 in ha_myisam::open (this=0x7f6691e24088, name=0x7f669219e158 "/bld/10.2/mysql-test/var/tmp/mysqld.1/#sql3f1e_3_1", mode=2, test_if_locked=18) at /src/10.2/storage/myisam/ha_myisam.cc:754
|
#11 0x00005628ab3446d6 in handler::ha_open (this=0x7f6691e24088, table_arg=0x7f6691e3b470, name=0x7f669219e158 "/bld/10.2/mysql-test/var/tmp/mysqld.1/#sql3f1e_3_1", mode=2, test_if_locked=18) at /src/10.2/sql/handler.cc:2497
|
#12 0x00005628ab1e4fe5 in open_table_from_share (thd=0x7f669202d630, share=0x7f669219dc70, alias=0x7f6692068aa0 "t", db_stat=7, prgflag=44, ha_open_flags=18, outparam=0x7f6691e3b470, is_create_table=false) at /src/10.2/sql/table.cc:2946
|
#13 0x00005628ab2c6ecf in THD::open_temporary_table (this=0x7f669202d630, share=0x7f669219dc70, alias=0x7f6692068aa0 "t", open_in_engine=true) at /src/10.2/sql/temporary_tables.cc:1120
|
#14 0x00005628ab2c5998 in THD::open_temporary_table (this=0x7f669202d630, tl=0x7f6692068ae8) at /src/10.2/sql/temporary_tables.cc:367
|
#15 0x00005628ab2c5be5 in THD::open_temporary_tables (this=0x7f669202d630, tl=0x7f6692068490) at /src/10.2/sql/temporary_tables.cc:455
|
#16 0x00005628ab0f49cc in mysql_execute_command (thd=0x7f669202d630) at /src/10.2/sql/sql_parse.cc:3270
|
#17 0x00005628ab102708 in mysql_parse (thd=0x7f669202d630, rawbuf=0x7f66920677c8 "SELECT ( SELECT 1 FROM t a1, t a2 ) AS f1, ( SELECT 2 FROM t a3 ) AS f2 FROM DUAL", length=81, parser_state=0x7f669dcae9e0, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:7729
|
#18 0x00005628ab0f0b51 in dispatch_command (command=COM_QUERY, thd=0x7f669202d630, packet=0x7f669205b271 "SELECT ( SELECT 1 FROM t a1, t a2 ) AS f1, ( SELECT 2 FROM t a3 ) AS f2 FROM DUAL", packet_length=81, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:1792
|
#19 0x00005628ab0ef590 in do_command (thd=0x7f669202d630) at /src/10.2/sql/sql_parse.cc:1353
|
#20 0x00005628ab225d31 in do_handle_one_connection (connect=0x7f669b484310) at /src/10.2/sql/sql_connect.cc:1358
|
#21 0x00005628ab225abe in handle_one_connection (arg=0x7f669b484310) at /src/10.2/sql/sql_connect.cc:1264
|
#22 0x00005628ab93e728 in pfs_spawn_thread (arg=0x7f66969c6ff0) at /src/10.2/storage/perfschema/pfs.cc:1862
|
#23 0x00007f669d9290a4 in start_thread () from /lib64/libpthread.so.0
|
#24 0x00007f669ba9704d in clone () from /lib64/libc.so.6
|