Server crashes in ha_maria::scan_time with derived_with_keys=on, GROUP_CONCAT in a view or FROM subquery, MyISAM or Aria
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Igor Babaev |
Bug Description
#4 <signal handler called>
#5 0x08596e47 in ha_maria::scan_time (this=0x9473f50) at ha_maria.cc:916
#6 0x084053b6 in SQL_SELECT:
ordered_
#7 0x083595c4 in get_quick_
#8 0x0835b1f6 in make_join_
#9 0x08353469 in JOIN::optimize (this=0x9475b28) at sql_select.cc:1150
#10 0x083592e4 in mysql_select (thd=0x93f04c8, rref_pointer_
group=0x0, having=0x0, proc_param=0x0, select_
#11 0x08350fe7 in handle_select (thd=0x93f04c8, lex=0x93f1bec, result=0x9460978, setup_tables_
#12 0x082ec085 in execute_
#13 0x082e3461 in mysql_execute_
#14 0x082ee6c0 in mysql_parse (thd=0x93f04c8, rawbuf=0x945ec00 "SELECT a FROM t1, v \nWHERE a = b", length=32, found_semicolon
#15 0x082e10a1 in dispatch_command (command=COM_QUERY, thd=0x93f04c8, packet=0x9449311 "SELECT a FROM t1, v \nWHERE a = b", packet_length=32) at sql_parse.cc:1228
#16 0x082e054b in do_command (thd=0x93f04c8) at sql_parse.cc:923
#17 0x082dd4d1 in handle_
#18 0xb767ab25 in start_thread () from /lib/libpthread
bzr version-info
revision-id: <email address hidden>
date: 2012-03-12 18:21:14 +0400
build-date: 2012-03-13 06:07:23 +0400
revno: 3457
(Note: according to log, revno 3457 contains a bugfix for https:/
Also reproducible on MariaDB 5.5 revno 3319.
EXPLAIN also crashes.
Minimal optimizer_switch: derived_
Full optimizer_switch (default): index_merge=
Test case:
SET optimizer_switch = 'derived_
CREATE TABLE t1 ( a INT ) ENGINE=MyISAM;
INSERT INTO t1 VALUES ( 132 );
CREATE TABLE t2 ( b INT, c VARCHAR(1024) ) ENGINE=MyISAM;
INSERT INTO t2 VALUES (120,'text1'
CREATE VIEW v AS
SELECT b, GROUP_CONCAT(c) AS gc
FROM t2
GROUP BY b;
SELECT a FROM t1, v
WHERE a = b;
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → Critical |
assignee: | nobody → Igor Babaev (igorb-seattle) |
Changed in maria: | |
status: | Confirmed → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
information type: | Public → Public Security |
Hi,
we got the error with mariadb 5.5.35. with_keys= off';
If we do: SET optimizer_switch = 'derived_
the error not accures.
the test scenario described here does not produce the error.
The bug seems not fixed for all cases.
Meik