Second crash with get_fanout_with_deps() with semijoin + materialization
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Undecided
|
Sergey Petrunia |
Bug Description
backtrace:
#4 <signal handler called>
#5 0x0824ef48 in get_fanout_
#6 0x0824f0ba in get_post_
#7 0x082464a4 in Item_in_
#8 0x083de322 in convert_
#9 0x083dd077 in convert_
#10 0x0831b540 in JOIN::optimize (this=0xae529368) at sql_select.cc:897
#11 0x08321e11 in mysql_select (thd=0xb36d6e0, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2886
#12 0x08319c67 in handle_select (thd=0xb36d6e0, lex=0xb36ede4, result=0xae513e90, setup_tables_
#13 0x082b4434 in execute_
#14 0x082ab1f1 in mysql_execute_
#15 0x082b6a63 in mysql_parse (thd=0xb36d6e0,
rawbuf=
found_
#16 0x082a8e40 in dispatch_command (command=COM_QUERY, thd=0xb36d6e0,
packet=
at sql_parse.cc:1221
#17 0x082a829b in do_command (thd=0xb36d6e0) at sql_parse.cc:916
#18 0x082a527f in handle_
#19 0x00821919 in start_thread () from /lib/libpthread
#20 0x0076acce in clone () from /lib/libc.so.6
optimizer switch:
semijoin=
Explain also crashes.
Test case:
CREATE TABLE t1 ( f2 int) ;
INSERT INTO t1 VALUES (9),(6);
CREATE TABLE t3 ( f4 int) ;
CREATE TABLE t4 ( f6 varchar(1) ) ;
SET SESSION optimizer_
SELECT *
FROM t3
WHERE ( 'h' ) IN (
SELECT f6
FROM t4
WHERE ( 5 ) IN ( SELECT f2 FROM t1 )
GROUP BY t4.f6
);
bzr version-info:
revision-id: <email address hidden>
date: 2011-09-26 23:54:00 +0300
build-date: 2011-09-27 09:49:21 +0300
revno: 3196
branch-nick: maria-5.3
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Sergey Petrunia (sergefp) |
Changed in maria: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |