Details
Description
The following query crash mariadb server:
CREATE TEMPORARY TABLE v0 ( v1 CHAR UNIQUE ) ; |
SELECT 59 FROM v0 GROUP BY v1 , v1 HAVING ( ( SELECT 45 FROM v0 WHERE v1 IS NULL AND v1 IN ( v1 NOT LIKE v1 , 'x' ) ) AND v1 < 52 OR v1 > -128 AND NOT v1 ) ; |
Server version: 10.11.2-MariaDB Source distribution
This should be easily reproducible. Please let me know if more details are needed.
Attachments
Issue Links
- duplicates
-
MDEV-19520 Extend condition normalization to include 'NOT a'
- Closed