Crash in add_found_match_trig_cond() with multiple views + multiple outer joins
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Igor Babaev |
Bug Description
backtrace:
#4 <signal handler called>
#5 0x0832b633 in add_found_
#6 0x0832d1da in make_join_select (join=0xae539310, select=0xae538368, cond=0xae537de8) at sql_select.cc:8312
#7 0x0831a77f in JOIN::optimize (this=0xae539310) at sql_select.cc:1246
#8 0x0831fb4d in mysql_select (thd=0xa7276a8, rref_pointer_
group=0x0, having=0x0, proc_param=0x0, select_
#9 0x08317a67 in handle_select (thd=0xa7276a8, lex=0xa728db0, result=0xae536c10, setup_tables_
#10 0x082b2e4e in execute_
#11 0x082a9c52 in mysql_execute_
#12 0x082b548a in mysql_parse (thd=0xa7276a8,
rawbuf=
#13 0x082a78cf in dispatch_command (command=COM_QUERY, thd=0xa7276a8,
packet=
#14 0x082a6d55 in do_command (thd=0xa7276a8) at sql_parse.cc:906
#15 0x082a3dbc in handle_
#16 0x00821919 in start_thread () from /lib/libpthread
#17 0x0076acce in clone () from /lib/libc.so.6
test case:
CREATE TABLE t1 ( b int, a int ) ;
CREATE TABLE t2 ( a int ) ;
INSERT INTO t2 VALUES (5),(6);
CREATE TABLE t3 ( a int , c int) ;
INSERT INTO t3 VALUES (22,1),(23,-1);
CREATE TABLE t4 ( a int ) ;
CREATE TABLE t5 ( d int) ;
INSERT INTO t5 VALUES (0);
CREATE OR REPLACE VIEW v2 AS SELECT * FROM t2;
CREATE OR REPLACE VIEW v3 AS SELECT * FROM t3;
SELECT STRAIGHT_JOIN *
FROM (
t1 AS alias1
RIGHT JOIN (
v2 AS alias3
ON alias4.a )
ON alias3.a != 0)
ON alias1.a != 0)
JOIN t5 ON alias4.c != 0;
Optimizer switch: index_merge=
bzr version-info:
revision-id: <email address hidden>
date: 2011-08-09 18:34:26 +0300
build-date: 2011-08-11 14:30:00 +0300
revno: 3148
repeatable with maria-5.3 not repeatable with maria-5.2, mysql-5.5, maria-5.3 before WL#106
branch-nick: maria-5.3
Changed in maria: | |
milestone: | none → 5.3 |
Changed in maria: | |
status: | New → Confirmed |
tags: | added: igorb-seattle |
Changed in maria: | |
importance: | Undecided → Critical |
status: | Confirmed → In Progress |
assignee: | nobody → Igor Babaev (igorb-seattle) |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |