Second crash with select_describe with nested subqueries in maria-5.3
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Timour Katchaounov |
Bug Description
Repeatable with any optimizer_switch setting.
backtrace:
#4 0x000000000074feb8 in select_describe (join=0x1f0d16e0, need_tmp_
#5 0x0000000000752b86 in JOIN::exec (this=0x1f0d16e0) at sql_select.cc:2179
#6 0x000000000074e95a in mysql_select (thd=0x1efb8068, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2889
#7 0x000000000074ecff in mysql_explain_union (thd=0x1efb8068, unit=0x1f0725d0, result=0x1f073320) at sql_select.cc:20978
#8 0x0000000000751cdb in select_describe (join=0x1f0cb4b0, need_tmp_
#9 0x0000000000752b86 in JOIN::exec (this=0x1f0cb4b0) at sql_select.cc:2179
#10 0x000000000074e95a in mysql_select (thd=0x1efb8068, rref_pointer_
og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2889
#11 0x000000000074ecff in mysql_explain_union (thd=0x1efb8068, unit=0x1f03eb90, result=0x1f073320) at sql_select.cc:20978
#12 0x0000000000751cdb in select_describe (join=0x1f0c5280, need_tmp_
message=
#13 0x0000000000751dd9 in return_zero_rows (join=0x1f0c5280, result=0x1f073320, tables=..., fields=..., send_row=false, select_
info=0xd924a0 "Impossible WHERE noticed after reading const tables", having=0x0) at sql_select.cc:10106
#14 0x0000000000752734 in JOIN::exec (this=0x1f0c5280) at sql_select.cc:2120
#15 0x000000000074e95a in mysql_select (thd=0x1efb8068, rref_pointer_
og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2889
#16 0x000000000074ecff in mysql_explain_union (thd=0x1efb8068, unit=0x1efba510, result=0x1f073320) at sql_select.cc:20978
#17 0x00000000006a18c2 in execute_
#18 0x00000000006a373a in mysql_execute_
#19 0x00000000006ac4d3 in mysql_parse (thd=0x1efb8068,
rawbuf=
length=116, found_semicolon
#20 0x00000000006ad36b in dispatch_command (command=COM_QUERY, thd=0x1efb8068, packet=0x1f034939 "", packet_length=116) at sql_parse.cc:1208
#21 0x00000000006ae979 in do_command (thd=0x1efb8068) at sql_parse.cc:906
#22 0x00000000006993ef in handle_
#23 0x00000033b600673d in start_thread () from /lib64/
#24 0x00000033b58d40cd in clone () from /lib64/libc.so.6
full optimizer switch:
index_merge=
test case:
CREATE TABLE t1 ( f4 int) ;
INSERT INTO t1 VALUES (0),(0);
CREATE TABLE t2 ( f2 int) ;
CREATE TABLE t3 ( f1 int NOT NULL );
CREATE TABLE t4 ( f2 int, f3 int) ;
INSERT INTO t4 VALUES (8,0),(3,0);
SELECT @@optimizer_switch;
EXPLAIN SELECT *
FROM t2, t3
WHERE t3.f1 = (
SELECT SUM( f2 )
FROM t4
WHERE EXISTS (
)
);
Related branches
Changed in maria: | |
milestone: | none → 5.3 |
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → Critical |
assignee: | nobody → Timour Katchaounov (timour) |
Changed in maria: | |
status: | Confirmed → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |