SQLite

View Ticket
Login
2020-06-13
21:43 Fixed ticket [e367f319]: Assertion `pExpr->pAggInfo==pAggInfo' failed. plus 5 other changes (artifact: c3117e46 user: drh)
21:24
Avoid deleting expression nodes in the flattener code, as they may be referenced by AggInfo objects further up the stack. Ticket [e367f31901ea8700] (check-in: cc1fffde user: dan tags: trunk)
18:52 New ticket [e367f319] Assertion `pExpr->pAggInfo==pAggInfo' failed.. (artifact: 838e3099 user: yongheng)

Ticket Hash: e367f31901ea8700e0c1cdddb68947e9dd290644
Title: Assertion `pExpr->pAggInfo==pAggInfo' failed.
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-06-13 21:43:15
Version Found In: trunk
User Comments:
yongheng added on 2020-06-13 18:52:27:
POC:
---
CREATE TABLE v0 ( v1 ) ;
CREATE INDEX v2 ON v0 ( v1 , v1 ) ;
ALTER TABLE zipfile RENAME TO x ; DROP TRIGGER IF EXISTS x ;
WITH v2 AS ( SELECT v1 FROM v0 WHERE 0 ) SELECT ( SELECT v1 FROM v2 UNION ALL SELECT rank () OVER( PARTITION BY ( SELECT max ( ( SELECT count () FROM v0 JOIN v2 AS b ON v2 . v1 = v0 . v1 ) ) FROM v2 GROUP BY v1 HAVING v1 < 'MED PKG' ) ORDER BY ( SELECT v1 FROM v2 NATURAL JOIN v2 WHERE v1 = v1 AND v1 > 3 GROUP BY v1 ) ) FROM v2 ORDER BY v1 ASC , v1 ASC LIMIT 2 ) FROM v2 WHERE v1 IN ( 10 , NULL ) ;
---