Assertion `!eliminated_tables || !(((*table)->table && ((*table)->table->map & eliminated_tables)) || ((*table)->nested_join && !((*table)->nested_join->used_tables & ~eliminated_tables)))' fails on EXPLAIN EXTENDED with LEFT JOIN and table_elimination=on
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Undecided
|
Sergey Petrunia |
Bug Description
mysqld: /home/elenst/
#8 0xb75c6014 in __assert_fail () from /lib/libc.so.6
#9 0x082b92e6 in print_join (thd=0x965e768, eliminated_
tables=
at /home/elenst/
#10 0x082b9df7 in st_select_
str=0xad2357f8, query_type=
at /home/elenst/
#11 0x08474de8 in subselect_
str=0xad2357f8, query_type=
at /home/elenst/
#12 0x0846e046 in Item_subselect:
query_
at /home/elenst/
#13 0x084725b8 in Item_in_
query_
at /home/elenst/
#14 0x084394df in Item_func:
query_
#15 0x08439455 in Item_func::print (this=0x9725598, str=0xad2357f8,
query_
#16 0x082b9e9d in st_select_
str=0xad2357f8, query_type=
at /home/elenst/
#17 0x082515d0 in st_select_
query_
#18 0x08262541 in execute_
at /home/elenst/
#19 0x0825b5f4 in mysql_execute_
at /home/elenst/
#20 0x08264c28 in mysql_parse (thd=0x965e768,
rawbuf=
at /home/elenst/
#21 0x082590be in dispatch_command (command=COM_QUERY, thd=0x965e768,
packet=
at /home/elenst/
#22 0x08258583 in do_command (thd=0x965e768)
at /home/elenst/
#23 0x083411b6 in do_handle_
at /home/elenst/
#24 0x08340d04 in handle_
at /home/elenst/
#25 0x08562169 in pfs_spawn_thread (arg=0x9750620)
at /home/elenst/
#26 0xb78a5b25 in start_thread () from /lib/libpthread
bzr version-info
revision-id: <email address hidden>
date: 2012-01-20 22:32:31 +0100
build-date: 2012-01-22 05:48:07 +0400
revno: 3228
branch-nick: maria-5.5
Could not reproduce on MariaDB-5.3 or MySQL-5.5.20.
Minimal optimizer_switch: in_to_exists=
Full optimizer_switch: index_merge=
Test case:
SET optimizer_
CREATE TABLE t1 ( a INT );
INSERT INTO t1 VALUES (1);
CREATE TABLE t2
( b INT, UNIQUE INDEX(b) );
INSERT INTO t2 VALUES (1),(2);
EXPLAIN EXTENDED
SELECT * FROM t2
WHERE b IN (
SELECT SUM(a) FROM t1 LEFT JOIN t2 ON b=a
);
summary: |
- Assertion `!eliminated_tables || !(((*table)->table && + Assertion `!eliminated_tables || !(((*table)->table && ((*table)->table->map & eliminated_tables)) || ((*table)->nested_join && - !((*table)->nested_join->used_tables & ~eliminated_tables)))' failed at - sql_select.cc:21470: void print_join on EXPLAIN EXTENDED with LEFT JOIN - and table_elimination=on + !((*table)->nested_join->used_tables & ~eliminated_tables)))' fails on + EXPLAIN EXTENDED with LEFT JOIN and table_elimination=on |
description: | updated |
Changed in maria: | |
status: | New → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Also filed as JIRA issue MDEV-112