Assertion `outer_join->table_count > 0' failed in JOIN::choose_subquery_plan() with materialization=on,semijoin=off in maria-5.3
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Timour Katchaounov |
Bug Description
assertion:
mysqld: opt_subselect.
backtrace:
#6 0x00000033b58296e6 in __assert_fail () from /lib64/libc.so.6
#7 0x00000000007ffb72 in JOIN::choose_
#8 0x0000000000747d1c in make_join_
#9 0x000000000074a0e6 in JOIN::optimize (this=0x77a2eb0) at sql_select.cc:1100
#10 0x000000000057a27a in st_select_
#11 0x0000000000800aea in JOIN::optimize_
#12 0x000000000074c0f5 in JOIN::optimize (this=0x7756fb0) at sql_select.cc:1606
#13 0x000000000074dc05 in mysql_select (thd=0x76d5ed8, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2871
#14 0x0000000000754084 in handle_select (thd=0x76d5ed8, lex=0x76d8280, result=0x771e4e8, setup_tables_
#15 0x00000000006a1554 in execute_
#16 0x00000000006a3207 in mysql_execute_
#17 0x00000000006abf9f in mysql_parse (thd=0x76d5ed8, rawbuf=0x771c990 "SELECT *\nFROM t1, t2\nWHERE\n( t1.f1 ) IN ( SELECT f1 FROM t3 ) LIMIT 0",
length=69, found_semicolon
#18 0x00000000006ace37 in dispatch_command (command=COM_QUERY, thd=0x76d5ed8,
packet=
#19 0x00000000006ae449 in do_command (thd=0x76d5ed8) at sql_parse.cc:904
#20 0x0000000000698efb in handle_
#21 0x00000033b600673d in start_thread () from /lib64/
#22 0x00000033b58d40cd in clone () from /lib64/libc.so.6
Explain:
crashes
minimal optimizer_switch: materialization
total optimizer_switch: index_merge=
bzr version-info:
revision-id: <email address hidden>
date: 2011-06-21 18:17:28 -0700
build-date: 2011-06-22 16:06:38 +0300
revno: 3054
branch-nick: maria-5.3
test case:
SET SESSION optimizer_
CREATE TABLE t1 ( f1 int);
CREATE TABLE t2 ( f1 int);
CREATE TABLE t3 ( f1 int);
SELECT * FROM t1, t2
WHERE ( t1.f1 ) IN ( SELECT f1 FROM t3 )
LIMIT 0;
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Timour Katchaounov (timour) |
Changed in maria: | |
importance: | Undecided → Critical |
Changed in maria: | |
status: | New → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |