Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
12.0.2
-
None
-
Not for Release Notes
Description
Complex query with `IN` subquery and `HAVING` clause causes a crash in the optimizer.
CREATE DATABASE IF NOT EXISTS HuangHe;
|
USE HuangHe;
|
SET optimizer_switch= 'condition_pushdown_for_subquery=on' ; |
CREATE TABLE main_tab (f1 INT );
|
INSERT INTO main_tab VALUES (1),(2); |
CREATE TABLE sec_tab (f2 INT );
|
INSERT INTO main_tab VALUES (3),(4); |
SELECT * FROM main_tab, sec_tab WHERE f2 IN ( SELECT f1 FROM main_tab HAVING f1 = 5 ) AND f1 = 6 AND ( 0 OR f1 = f2 ); |
DROP TABLE main_tab, sec_tab;
|
mariadbd(_ZN10Item_equal14add_key_fieldsEP4JOINPP9KEY_FIELDPjyPP14SARGABLE_PARAM+0x9c)[0x64a09c21520c] |
mariadbd(_ZN4JOIN14optimize_innerEv+0x1311)[0x64a09c2272a1] |
mariadbd(_ZN4JOIN8optimizeEv+0x10a)[0x64a09c2278ba] |