Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.2.43, 10.3.35
-
None
-
ubuntu 18.04
Description
poc:
CREATE TEMPORARY TABLE v1426 ( v1427 TEXT ( 1 ) NOT NULL ) ; |
INSERT INTO v1426 ( v1427 ) VALUES ( 67 ) ; |
UPDATE v1426 SET v1427 = 61 WHERE v1427 = 25 ; |
INSERT INTO v1426 ( v1427 ) VALUES ( ( WITH v1431 AS ( SELECT v1427 FROM ( SELECT v1427 FROM ( SELECT v1427 FROM v1426 WHERE v1427 = CASE v1427 * 19 = -128 WHEN 255 THEN 'x' WHEN ( v1427 IN ( 'x' , -1 , -128 , 62 , 'x' / v1427 = v1427 + CASE FALSE / v1427 = v1427 + CASE v1427 WHEN TRUE THEN -128 ELSE 0 END OR v1427 = v1427 WHEN TRUE THEN 12 ELSE 0 END OR v1427 = v1427 OR v1427 = v1427 ) ) THEN 255 ELSE -1 END / -2147483648 ) AS v1428 NATURAL JOIN v1426 AS v1429 NATURAL JOIN v1426 ) AS v1430 ) SELECT v1427 FROM v1431 WHERE ( ( v1427 , v1427 , v1427 ) < ( 87 , 89998042.000000 NOT LIKE -128 , -2147483648 ) OR v1427 = 53 ) NOT LIKE 'x' AND CASE v1427 * 37 = 0 WHEN 31 THEN FALSE WHEN -1 THEN 'x' ELSE -1 END != 93 WINDOW v1432 AS ( ORDER BY v1427 ) ) ) , ( 54 ) ; |
WITH v1433 AS ( SELECT v1427 FROM v1426 ORDER BY 74927827.000000 ) SELECT ( ( v1427 OR NOT v1427 ) BETWEEN ( ( ( NOT ( ( ( v1427 , NOT ( v1427 = ( SELECT v1427 FROM v1426 WHERE ( ( ( -1 ^ 16 * NULL , v1427 , v1427 ) < ( 3944709.000000 , 0 NOT LIKE 56 , -2147483648 ) ) + -128 , v1427 ) NOT IN ( SELECT ( 'x' = ( v1427 IN ( SELECT v1427 FROM v1426 WHERE v1427 = CASE WHEN v1427 < 'x' THEN 'x' ELSE v1427 END / -1 ) ) ) , 'x' FROM v1426 ) ) * 61 + 2147483647 ^ 66 ) IN ( -32768 , 14 ) , v1427 ) < ( 2147483647 , 92 NOT LIKE 19 , FALSE ) ) * NULL ) ) ) ) AND 47045683.000000 ) , 'x' FROM v1433 WINDOW v1434 AS ( PARTITION BY v1427 ORDER BY v1427 DESC ) ORDER BY v1427 , v1427 DESC ; |
output:
mysqld: /sql/item.cc:6192: virtual bool Item_field::fix_fields(THD*, Item**): Assertion `context' failed.
The full error log is in the attachment.
Attachments
Issue Links
- duplicates
-
MDEV-16549 Server crashes in Item_field::fix_fields on query with view and subquery, Assertion `context' failed, Assertion `field' failed
- Closed