Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.11.5
-
None
Description
INSERT INTO t1 VALUES ( 1 , 1 ) , ( 1 , 1 * 1 + 1 , x * 1 + 1 ) , ( 1 , 1 ) , ( 1 , 1 ) , ( 1 , 1 ) , ( 1 , 1 ) , ( 1 , 1 ) , ( 1 , 1 ) , ( 1 , 1 ) ; |
CREATE TABLE v0 ( v1 BIGINT UNIQUE CHECK ( v1 >= 0 AND v2 <= -32768 ) , v2 BIGINT ) ; |
SELECT v1 FROM v0 WHERE v1 = v1 AND v2 = 63422037.000000 28184457.000000 GROUP BY v1 , v1 HAVING ( v2 = v1 AND v1 IS NOT NULL ) ; |
SELECT * FROM v0 WHERE v1 NOT IN ( 10 + 49 , 0 >= ( SELECT v2 - 38 FROM v0 WHERE v1 IS NULL GROUP BY v2 , v2 HAVING ( CASE WHEN v2 IS NULL THEN v2 LIKE 'x' OR v1 = 'x' ELSE 127 END ) = -2147483648 ) ) GROUP BY v1 , v1 HAVING 86 = v1 ORDER BY v2 ; |
SELECT v1 , ( v1 ) , ( v1 ) , ( v1 ) FROM v0 ORDER BY v1 ; |
DROP TABLE t1 , t2 ; |
Attachments
Issue Links
- duplicates
-
MDEV-29731 Crash when HAVING in a correlated subquery references columns in the outer query
- Closed