RQG: item_subselect.cc:4635: virtual void subselect_partial_match_engine::print(String*, enum_query_type): Assertion `(0)' failed.
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Medium
|
Timour Katchaounov |
Bug Description
When executing the query below, MariaDB 5.3 asserts as follows:
mysqld: item_subselect.
The assertion seems to be introduced by the following patch:
https:/
Backtrace:
#8 0x00897de8 in __assert_fail () from /lib/libc.so.6
#9 0x08232040 in subselect_
#10 0x08228d59 in Item_subselect:
#11 0x0822c8eb in Item_in_
#12 0x081da127 in Item_func:
#13 0x081da0ad in Item_func::print (this=0x9991ef0, str=0xb6e5f33c, query_type=
#14 0x081da127 in Item_func:
#15 0x081da0ad in Item_func::print (this=0x98e24d0, str=0xb6e5f33c, query_type=
#16 0x081f0226 in Item_func_
#17 0x081fb70e in Item_cond::print (this=0x98e2550, str=0xb6e5f33c, query_type=
#18 0x0832547c in st_select_
#19 0x081a0df8 in st_select_
#20 0x08324e55 in TABLE_LIST::print (this=0x99919d8, thd=0x97841a0, eliminated_
#21 0x08324770 in print_table_array (thd=0x97841a0, eliminated_
at sql_select.cc:18509
#22 0x08324b78 in print_join (thd=0x97841a0, eliminated_
#23 0x083253da in st_select_
#24 0x081a0df8 in st_select_
#25 0x08294550 in execute_
#26 0x0828b069 in mysql_execute_
#27 0x08296857 in mysql_parse (thd=0x97841a0,
inBuf=0x98e0c18 "EXPLAIN EXTENDED\nSELECT `col_int_key`\nFROM (\nSELECT SUBQUERY1_t1 .*\nFROM CC SUBQUERY1_t1 STRAIGHT_JOIN C SUBQUERY1_t2 ON SUBQUERY1_t2 .`col_varchar_key` AND SUBQUERY1_t1 .`col_int_nokey` NOT IN "..., length=242, found_semicolon
#28 0x08288b11 in dispatch_command (command=COM_QUERY, thd=0x97841a0, packet=0x988f571 "", packet_length=245) at sql_parse.cc:1253
#29 0x08287d4f in do_command (thd=0x97841a0) at sql_parse.cc:891
#30 0x08284e96 in handle_
#31 0x00a08919 in start_thread () from /lib/libpthread
#32 0x00951e5e in clone () from /lib/libc.so.6
Related branches
Changed in maria: | |
assignee: | nobody → Timour Katchaounov (timour) |
summary: |
- item_subselect.cc:4635: virtual void + RQG: item_subselect.cc:4635: virtual void subselect_partial_match_engine::print(String*, enum_query_type): Assertion `(0)' failed. |
Changed in maria: | |
importance: | Undecided → Medium |
Changed in maria: | |
milestone: | none → 5.3 |
Changed in maria: | |
status: | New → In Progress |
Changed in maria: | |
status: | In Progress → Fix Released |
Automatic test case:
--disable_warnings
DROP TABLE /*! IF EXISTS */ CC;
DROP TABLE /*! IF EXISTS */ C;
--enable_warnings
CREATE TABLE `CC` ( key`,`col_ int_key` )
`col_int_nokey` int(11) DEFAULT NULL,
`col_int_key` int(11) DEFAULT NULL,
`col_varchar_key` varchar(1) DEFAULT NULL,
KEY `col_int_key` (`col_int_key`),
KEY `col_varchar_key` (`col_varchar_
);
INSERT INTO `CC` VALUES (7,8,'v'); key`,`col_ int_key` )
INSERT INTO `CC` VALUES (1,9,'r');
INSERT INTO `CC` VALUES (5,9,'a');
INSERT INTO `CC` VALUES (3,186,'m');
INSERT INTO `CC` VALUES (6,NULL,'y');
INSERT INTO `CC` VALUES (92,2,'j');
INSERT INTO `CC` VALUES (7,3,'d');
INSERT INTO `CC` VALUES (NULL,0,'z');
INSERT INTO `CC` VALUES (3,133,'e');
INSERT INTO `CC` VALUES (5,1,'h');
INSERT INTO `CC` VALUES (1,8,'b');
INSERT INTO `CC` VALUES (2,5,'s');
INSERT INTO `CC` VALUES (NULL,5,'e');
INSERT INTO `CC` VALUES (1,8,'j');
INSERT INTO `CC` VALUES (0,6,'e');
INSERT INTO `CC` VALUES (210,51,'f');
INSERT INTO `CC` VALUES (8,4,'v');
INSERT INTO `CC` VALUES (7,7,'x');
INSERT INTO `CC` VALUES (5,6,'m');
INSERT INTO `CC` VALUES (NULL,4,'c');
CREATE TABLE `C` (
`col_int_nokey` int(11) DEFAULT NULL,
`col_int_key` int(11) DEFAULT NULL,
`col_varchar_key` varchar(1) DEFAULT NULL,
KEY `col_int_key` (`col_int_key`),
KEY `col_varchar_key` (`col_varchar_
);
INSERT INTO `C` VALUES (NULL,2,'w');
INSERT INTO `C` VALUES (7,9,'m');
INSERT INTO `C` VALUES (9,3,'m');
INSERT INTO `C` VALUES (7,9,'k');
INSERT INTO `C` VALUES (4,NULL,'r');
INSERT INTO `C` VALUES (2,9,'t');
INSERT INTO `C` VALUES (6,3,'j');
INSERT INTO `C` VALUES (8,8,'u');
INSERT INTO `C` VALUES (NULL,8,'h');
INSERT INTO `C` VALUES (5,53,'o');
INSERT INTO `C` VALUES (NULL,0,NULL);
INSERT INTO `C` VALUES (6,5,'k');
INSERT INTO `C` VALUES (188,166,'e');
INSERT INTO `C` VALUES (2,3,'n');
INSERT INTO `C` VALUES (1,0,'t');
INSERT INTO `C` VALUES (1,1,'c');
INSERT INTO `C` VALUES (0,9,'m');
INSERT INTO `C` VALUES (9,5,'y');
INSERT INTO `C` VALUES (NULL,6,'f');
INSERT INTO `C` VALUES (4,2,'d');
EXPLAIN EXTENDED
SELECT `col_int_key`
FROM (
SELECT SUBQUERY1_t1 .*
FROM CC SUBQUERY1_t1 STRAIGHT_JOIN C SUBQUERY1_t2 ON SUBQUERY1_t2 .`col_varchar_key` AND SUBQUERY1_t1 .`col_int_nokey` NOT IN (
SELECT `col_int_key`
FROM C ) ) table1 ;
DROP TABLE CC;
DROP TABLE C;