Fourth crash in select_describe() with nested subqueries
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Timour Katchaounov |
Bug Description
backtrace:
#4 <signal handler called>
#5 0x08349b39 in select_describe (join=0x9b130c68, need_tmp_
#6 0x0831f317 in JOIN::exec (this=0x9b130c68) at sql_select.cc:2190
#7 0x0832168a in mysql_select (thd=0xa1571e8, rref_pointer_
group=
#8 0x0834ba07 in mysql_explain_union (thd=0xa1571e8, unit=0xa0715150, result=0xa0715b48) at sql_select.cc:21106
#9 0x0834b6e2 in select_describe (join=0xa072efd8, need_tmp_
message=
#10 0x08332837 in return_zero_rows (join=0xa072efd8, result=0xa0715b48, tables=..., fields=..., send_row=true, select_
info=0x88ed93c "Impossible WHERE noticed after reading const tables", having=0x0) at sql_select.cc:10214
#11 0x0831ef03 in JOIN::exec (this=0xa072efd8) at sql_select.cc:2131
#12 0x0832168a in mysql_select (thd=0xa1571e8, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2900
#13 0x0834ba07 in mysql_explain_union (thd=0xa1571e8, unit=0xa0714828, result=0xa0715b48) at sql_select.cc:21106
#14 0x0834b6e2 in select_describe (join=0xa0727d68, need_tmp_
message=
#15 0x08332837 in return_zero_rows (join=0xa0727d68, result=0xa0715b48, tables=..., fields=..., send_row=true, select_
info=0x88ed93c "Impossible WHERE noticed after reading const tables", having=0x0) at sql_select.cc:10214
#16 0x0831ef03 in JOIN::exec (this=0xa0727d68) at sql_select.cc:2131
#17 0x0832168a in mysql_select (thd=0xa1571e8, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2900
#18 0x0834ba07 in mysql_explain_union (thd=0xa1571e8, unit=0xa158948, result=0xa0715b48) at sql_select.cc:21106
#19 0x082b405b in execute_
#20 0x082aafea in mysql_execute_
#21 0x082b6808 in mysql_parse (thd=0xa1571e8,
rawbuf=
length=119, found_semicolon
#22 0x082a8c30 in dispatch_command (command=COM_QUERY, thd=0xa1571e8, packet=0xa1afed9 "", packet_length=119) at sql_parse.cc:1221
#23 0x082a808b in do_command (thd=0xa1571e8) at sql_parse.cc:916
#24 0x082a5015 in handle_
#25 0x00821919 in start_thread () from /lib/libpthread
#26 0x0076acce in clone () from /lib/libc.so.6
test case:
--source include/
CREATE TABLE t1 ( f1 int(11)) ENGINE=InnoDB;
CREATE TABLE t2 ( f1 int(11), f2 int(11), PRIMARY KEY (f1)) ;
CREATE TABLE t3 ( f3 int(11)) ENGINE=InnoDB;
EXPLAIN
SELECT MAX( f1 ) FROM t2
WHERE f2 >= (
SELECT SUM( f1 )
FROM t1
WHERE EXISTS (
)
);
bzr version-info:
revision-id: <email address hidden>
date: 2011-09-23 01:30:44 +0400
build-date: 2011-09-24 14:03:12 +0300
revno: 3192
branch-nick: maria-5.3
Related branches
Changed in maria: | |
status: | New → In Progress |
importance: | Undecided → Critical |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
Repeatable with both materialization and in_to_exists. Full optimizer_switch:
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=off, derived_ with_keys= off,firstmatch= off,loosescan= off,materializa tion=off, in_to_exists= on,semijoin= off,partial_ match_rowid_ merge=on, partial_ match_table_ scan=on, subquery_ cache=off, mrr=off, mrr_cost_ based=off, mrr_sort_ keys=off, join_cache_ incremental= on,join_ cache_hashed= on,join_ cache_bka= on,optimize_ join_buffer_ size=off, table_eliminati on=on