Crash in create_tmp_table called from JOIN::init_execution in maria-5.3-mwl89
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Timour Katchaounov |
Bug Description
not reproducible in maria-5.3
backtrace:
#4 <signal handler called>
#5 0x0831e892 in create_tmp_table (thd=0x9d050e8, param=0x9d83954, fields=..., group=0x9d57298, distinct=false, save_sum_
select_
#6 0x08303ae8 in JOIN::init_
#7 0x083053fa in JOIN::exec (this=0x9d7ecc0) at sql_select.cc:1880
#8 0x08307961 in mysql_select (thd=0x9d050e8, rref_pointer_
group=
#9 0x0830004d in handle_select (thd=0x9d050e8, lex=0x9d06768, result=0x9d57330, setup_tables_
#10 0x0829d91b in execute_
#11 0x08294423 in mysql_execute_
#12 0x0829feac in mysql_parse (thd=0x9d050e8, rawbuf=0x9d566d0 "SELECT ( SELECT f1 FROM t1 ) AS field1 FROM t2 GROUP BY field1", length=62,
found_
#13 0x08291f0c in dispatch_command (command=COM_QUERY, thd=0x9d050e8, packet=0x9d1d789 "SELECT ( SELECT f1 FROM t1 ) AS field1 FROM t2 GROUP BY field1",
packet_
#14 0x08291376 in do_command (thd=0x9d050e8) at sql_parse.cc:902
#15 0x0828e454 in handle_
#16 0x00bea919 in start_thread () from /lib/libpthread
#17 0x00b2ccbe in clone () from /lib/libc.so.6
explain in maria-5.3-mwl89:
EXPLAIN SELECT ( SELECT f1 FROM t1 ) AS field1 FROM t2 GROUP BY field1;
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY t2 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort
2 SUBQUERY t1 system NULL NULL NULL NULL 0 const row not found
test case. optimizer switches are not strictly required:
SET SESSION optimizer_
CREATE TABLE t2 (f1 int) ;
INSERT IGNORE INTO t2 VALUES (1),(2);
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (f1 int) ;
SELECT ( SELECT f1 FROM t1 ) AS field1 FROM t2 GROUP BY field1;
Related branches
Changed in maria: | |
assignee: | nobody → Timour Katchaounov (timour) |
milestone: | none → 5.3 |
Changed in maria: | |
status: | Confirmed → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
This is a regression after the fix for LP BUG#680846.