Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Repeatable with maria-5.3, maria-5.3-subqueries-wl90. Reproducible even after 609045. Reproducible with all relevant swiches set to OFF.
assertion:
mysqld: sql_base.cc:1387: bool close_thread_table(THD*, TABLE**): Assertion `table->key_read == 0' failed.
#6 0x00000033b58296e6 in __assert_fail () from /lib64/libc.so.6
#7 0x000000000070012c in close_thread_table (thd=0xcc6f098, table_ptr=0xcc6f150) at sql_base.cc:1387
#8 0x0000000000700873 in close_open_tables (thd=0xcc6f098) at sql_base.cc:1204
#9 0x0000000000700d29 in close_thread_tables (thd=0xcc6f098) at sql_base.cc:1362
#10 0x00000000006ae270 in dispatch_command (command=COM_QUERY, thd=0xcc6f098, packet=0xcceb8c9 "", packet_length=152) at sql_parse.cc:1590
#11 0x00000000006ae635 in do_command (thd=0xcc6f098) at sql_parse.cc:904
#12 0x00000000006990eb in handle_one_connection (arg=0xcc6f098) at sql_connect.cc:1178
#13 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0
#14 0x00000033b58d40cd in clone () from /lib64/libc.so.6
optimizer switch in effect:
index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=off,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=off,mrr_sort_keys=on,outer_join_with_cache=off,semijoin_with_cache=off,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on
test case:
CREATE TABLE t1 ( f1 int, f2 int , KEY (f1)) ;
INSERT IGNORE INTO t1 VALUES (1,0),(5,0);
EXPLAIN
SELECT *
FROM t1 AS alias2 JOIN t1 AS alias3 ON alias3.f2
WHERE alias3.f2 =
(
SELECT f2
FROM t1
WHERE EXISTS
(
SELECT DISTINCT f1
FROM t1 )
) ;