Second crash in select_describe() and materialization
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Low
|
Timour Katchaounov |
Bug Description
Even if bug 611690 is no longer repeatable, the following crash happens in both maria-5.3 and maria-5.3-mwl89
backtrace:
#3 0x08285887 in handle_segfault (sig=11) at mysqld.cc:2778
#4 <signal handler called>
#5 0x08331179 in select_describe (join=0xae5691a8, need_tmp_
#6 0x083089de in JOIN::exec (this=0xae5691a8) at sql_select.cc:1966
#7 0x0830ab99 in mysql_select (thd=0xa30bbf8, rref_pointer_
group=
#8 0x08332fd9 in mysql_explain_union (thd=0xa30bbf8, unit=0xae5327d0, result=0xae5331c0) at sql_select.cc:19659
#9 0x08332bfe in select_describe (join=0xae562340, need_tmp_
#10 0x083089de in JOIN::exec (this=0xae562340) at sql_select.cc:1966
#11 0x0830ab99 in mysql_select (thd=0xa30bbf8, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2652
#12 0x08332fd9 in mysql_explain_union (thd=0xa30bbf8, unit=0xae531ff0, result=0xae5331c0) at sql_select.cc:19659
#13 0x08332bfe in select_describe (join=0xae55d4c0, need_tmp_
message=
#14 0x0831a213 in return_zero_rows (join=0xae55d4c0, result=0xae5331c0, tables=0xae531b90, fields=..., send_row=false, select_
info=0x88afd14 "Impossible WHERE noticed after reading const tables", having=0x0) at sql_select.cc:8993
#15 0x083086c1 in JOIN::exec (this=0xae55d4c0) at sql_select.cc:1928
#16 0x0830ab99 in mysql_select (thd=0xa30bbf8, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2652
#17 0x08332fd9 in mysql_explain_union (thd=0xa30bbf8, unit=0xa30d2f4, result=0xae5331c0) at sql_select.cc:19659
#18 0x082a0dd6 in execute_
#19 0x08297f63 in mysql_execute_
#20 0x082a34ec in mysql_parse (thd=0xa30bbf8,
rawbuf=
#21 0x08295bfb in dispatch_command (command=COM_QUERY, thd=0xa30bbf8, packet=0xa325d31 "", packet_length=134) at sql_parse.cc:1210
#22 0x082950a8 in do_command (thd=0xa30bbf8) at sql_parse.cc:903
#23 0x08292186 in handle_
#24 0x00821919 in start_thread () from /lib/libpthread
#25 0x0076acce in clone () from /lib/libc.so.6
test case:
SET SESSION optimizer_switch = 'materializatio
CREATE TABLE t2 (f11 varchar(1)) ;
INSERT INTO t2 VALUES ('f'),('d');
CREATE TABLE t1 ( f1 int(11), f3 int(11), f10 varchar(1), KEY (f3)) ;
INSERT INTO t1 VALUES ('28','
EXPLAIN SELECT *
FROM t1 AS alias1
WHERE alias1.f3 = (
SELECT t1.f3 FROM t1
WHERE ( t1.f10 ) IN ( SELECT f11 FROM t2 GROUP BY f11 )
);
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Timour Katchaounov (timour) |
summary: |
- Second crash in select_describe() + Second crash in select_describe() and materialization |
Changed in maria: | |
status: | Confirmed → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
Importance set to "Low" because this is a 5.3 bug, and will be fixed after merging 5.3-mwl89 into 5.3-main.