Crash in create_ref_for_key and derived_with_keys ( 64 bit )
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Igor Babaev |
Bug Description
The following query:
SELECT *
FROM t2
WHERE t2.f10 IN (
SELECT v4.f10
FROM t5
JOIN ( v4 JOIN t6 AS t6 ON ( t6.f10 = v4.f11 ) )
ON ( t6.f10 = v4.f10 )
WHERE v4.f10 = t2.f11
);
crashes as follows on 64-bit platforms:
#3 <signal handler called>
#4 0x0000000000750cd1 in create_ref_for_key (join=0x7f17900
at sql_select.cc:7309
#5 0x0000000000750414 in get_best_
#6 0x0000000000747371 in make_join_
at sql_select.cc:3548
#7 0x000000000073e67e in JOIN::optimize (this=0x7f17900
#8 0x00000000005a2a3a in st_select_
#9 0x0000000000827a5d in JOIN::optimize_
#10 0x000000000073fd89 in JOIN::optimize (this=0x7f17900
#11 0x0000000000744d6f in mysql_select (thd=0x2f7a1b8, rref_pointer_
og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2886
#12 0x000000000073bcbb in handle_select (thd=0x2f7a1b8, lex=0x2f7c5b8, result=
#13 0x00000000006c7fa3 in execute_
#14 0x00000000006bed02 in mysql_execute_
#15 0x00000000006caad3 in mysql_parse (thd=0x2f7a1b8,
rawbuf=
#16 0x00000000006bc53f in dispatch_command (command=COM_QUERY, thd=0x2f7a1b8,
packet=
#17 0x00000000006bb8bf in do_command (thd=0x2f7a1b8) at sql_parse.cc:916
#18 0x00000000006b879b in handle_
#19 0x00000035a7207761 in start_thread () from /lib64/
#20 0x00000035a6ee098d in clone () from /lib64/libc.so.6
EXPLAIN also crashes.
minimal switch: derived_
full switch: index_merge=
bzr version-info
revision-id: <email address hidden>
date: 2011-10-13 13:44:50 +0200
build-date: 2011-10-14 12:40:46 +0300
revno: 3233
branch-nick: maria-5.3
test case:
CREATE TABLE t2 ( f1 int NOT NULL , f3 int, f10 varchar(1) , f11 varchar(1) );
INSERT INTO t2 VALUES (19,1,NULL,
CREATE TABLE t4 ( f3 int, f10 varchar(1) , f11 varchar(1) );
INSERT INTO t4 VALUES (1,NULL,
CREATE TABLE t5 ( f11 varchar(1) ) ;
CREATE TABLE t6 ( f1 int NOT NULL , f3 int, f10 varchar(1) );
CREATE ALGORITHM=TEMPTABLE VIEW v4 AS SELECT * FROM t4;
SET SESSION optimizer_
SELECT *
FROM t2
WHERE t2.f10 IN (
SELECT v4.f10
FROM t5
JOIN ( v4 JOIN t6 AS t6 ON ( t6.f10 = v4.f11 ) )
ON ( t6.f10 = v4.f10 )
WHERE v4.f10 = t2.f11
);
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Igor Babaev (igorb-seattle) |
Changed in maria: | |
importance: | Undecided → Critical |
status: | New → Confirmed |
summary: |
- Crash with create_ref_for_key and derived_with_keys ( 64 bit ) + Crash in create_ref_for_key and derived_with_keys ( 64 bit ) |
Changed in maria: | |
status: | Confirmed → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |