Third crash in select_describe() in maria-5.3-mwl89
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Medium
|
Timour Katchaounov |
Bug Description
Not repeatable in maria-5.3. Happens regardless of in_to_exists or materialization switch.
backtrace:
#5 0x08338787 in select_describe (join=0xae63add0, need_tmp_
#6 0x0830f836 in JOIN::exec (this=0xae63add0) at sql_select.cc:2049
#7 0x08311b44 in mysql_select (thd=0x9c59da0, rref_pointer_
group=0x0, having=0x0, proc_param=0x0, select_
#8 0x0833a64f in mysql_explain_union (thd=0x9c59da0, unit=0xae613d20, result=0xae614618) at sql_select.cc:19926
#9 0x0833a352 in select_describe (join=0xae635b48, need_tmp_
#10 0x0830f836 in JOIN::exec (this=0xae635b48) at sql_select.cc:2049
#11 0x08311b44 in mysql_select (thd=0x9c59da0, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2749
#12 0x0833a64f in mysql_explain_union (thd=0x9c59da0, unit=0xae613510, result=0xae614618) at sql_select.cc:19926
#13 0x0833a352 in select_describe (join=0xae62d888, need_tmp_
message=
#14 0x083214a7 in return_zero_rows (join=0xae62d888, result=0xae614618, tables=0xae6130b0, fields=..., send_row=false, select_
info=0x88c3560 "Impossible WHERE noticed after reading const tables", having=0x0) at sql_select.cc:9130
#15 0x0830f45a in JOIN::exec (this=0xae62d888) at sql_select.cc:1990
#16 0x08311b44 in mysql_select (thd=0x9c59da0, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2749
#17 0x0833a64f in mysql_explain_union (thd=0x9c59da0, unit=0x9c5b4a0, result=0xae614618) at sql_select.cc:19926
#18 0x082a70f6 in execute_
#19 0x0829e0be in mysql_execute_
#20 0x082a9817 in mysql_parse (thd=0x9c59da0,
rawbuf=
found_
#21 0x0829bd47 in dispatch_command (command=COM_QUERY, thd=0x9c59da0, packet=0x9cb49b1 "", packet_length=112) at sql_parse.cc:1215
#22 0x0829b1a5 in do_command (thd=0x9c59da0) at sql_parse.cc:904
#23 0x08298258 in handle_
#24 0x00821919 in start_thread () from /lib/libpthread
#25 0x0076acce in clone () from /lib/libc.so.6
test case:
CREATE TABLE t1 ( f11 int) ;
INSERT INTO t1 VALUES (1),(1);
CREATE TABLE t2 ( f1 int NOT NULL) ;
INSERT INTO t2 VALUES (20);
CREATE TABLE t3 (f3 int) ;
INSERT INTO t3 VALUES (2),(2);
EXPLAIN SELECT * FROM t2
WHERE t2.f1 = (
SELECT MAX( f3 ) FROM t3
WHERE EXISTS (
)
);
bzr version-info:
revision-id: <email address hidden>
date: 2011-05-05 15:24:28 +0300
build-date: 2011-05-06 13:14:23 +0300
revno: 2982
branch-nick: maria-5.3-mwl89
Related branches
Changed in maria: | |
milestone: | none → 5.3 |
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 |
This bug is very similar to https:/ /bugs.launchpad .net/maria/ +bug/714999,
possibly another instance of a more general problem.