Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
12.2.1
-
None
-
Not for Release Notes
Description
Description
Complex query involving Common Table Expressions (CTE) and nested subqueries causes a segmentation fault in the optimizer.
Reproduction Steps
CREATE DATABASE IF NOT EXISTS HuangHe;
USE HuangHe;
CREATE TABLE x ( x INT );
INSERT INTO x ( x ) VALUES ( 1 );
UPDATE x SET x = 1 WHERE x = 1;
INSERT INTO x ( x ) VALUES ( 1 ), ( 1 );
WITH x ( x ) AS ( SELECT 1 EXCEPT SELECT x + 1 FROM x )
SELECT x , x FROM x GROUP BY CASE 1 WHEN 1 THEN x = ( SELECT x FROM x WHERE CASE x WHEN 1 THEN 1 ELSE x = 'x' AND CASE WHEN x > 1 THEN 1 / 1 ELSE 1 END IN ( SELECT x FROM x WHERE x = 'x' ) END != 1 IN ( x = 'x' AND x IN ( SELECT x FROM x WHERE ( ( x = 1 OR x = 1 ) ) = 'x' ) , x + 'x' ) ) WHEN 1 THEN 1 ELSE 1 / 1 END HAVING x IN ( 1 , 1 , 1 , x IN ( WITH RECURSIVE x AS ( WITH RECURSIVE x AS ( SELECT 1 ) SELECT * FROM x ) SELECT x FROM x WHERE x = 1 ^ 1 + 'x' + 1 ^ 1.000000 + 1 ^ 1.000000 + ( SELECT x FROM x AS x WHERE ( SELECT DISTINCT x WHERE x BETWEEN ( SELECT x AS x FROM x AS x GROUP BY x HAVING x ) AND 1 ) IN ( SELECT DISTINCT x FROM x WHERE x = ( x = 1 OR x > 'x' ) NOT LIKE 'x' ) AND x = 'x' GROUP BY x ) BETWEEN 1 AND 1 ) ) ORDER BY x , x ;
Attachments
Issue Links
- duplicates
-
MDEV-32717 eliminate_item_equal, sjm: SEGV at /mariadb-11.3.0/sql/sql_select.cc:18075
-
- Confirmed
-