Crash in eliminate_item_equal with materialization=on in maria-5.3
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Sergey Petrunia |
Bug Description
Repeatable with maria-5.3, maria-5.3-mwl89. Not repeatable with maria-5.2. Seems to require materialization=on. Explain also crashes.
backtrace:
#4 <signal handler called>
#5 0x08321404 in eliminate_
#6 0x0832193f in substitute_
#7 0x0830adf4 in JOIN::optimize (this=0xae62db38) at sql_select.cc:1066
#8 0x083100a1 in mysql_select (thd=0x9382e48, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2687
#9 0x08308983 in handle_select (thd=0x9382e48, lex=0x93844ec, result=0xae614300, setup_tables_
#10 0x082a5cc8 in execute_
#11 0x0829cb12 in mysql_execute_
#12 0x082a826b in mysql_parse (thd=0x9382e48,
rawbuf=
found_
#13 0x0829a79b in dispatch_command (command=COM_QUERY, thd=0x9382e48,
packet=
at sql_parse.cc:1215
#14 0x08299bf9 in do_command (thd=0x9382e48) at sql_parse.cc:904
#15 0x08296cac in handle_
#16 0x00821919 in start_thread () from /lib/libpthread
#17 0x0076acce in clone () from /lib/libc.so.6
test case:
SET SESSION optimizer_switch = 'materializatio
CREATE TABLE t1 ( f1 int );
INSERT INTO t1 VALUES (19), (20);
CREATE TABLE t3 ( f10 varchar(32) );
INSERT INTO t3 VALUES ('a'),('b');
CREATE TABLE t4 ( f10 varchar(32) );
INSERT INTO t4 VALUES ('c'),('d');
SELECT *
FROM t1
WHERE
( 't' ) IN (
SELECT t3.f10
FROM t3
JOIN t4
ON t4.f10 = t3.f10
);
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Timour Katchaounov (timour) |
summary: |
- Crash in eliminate_item_equal with materialization=on + Crash in eliminate_item_equal with materialization=on in maria-5.3 |
Changed in maria: | |
status: | Confirmed → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
There is no crash neither with non-flattened materialization, nor with IN-TO-EXISTS.
The crash is in semijoin materialization, thus reassigning to SergeyP.