|
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 ) ; --- | ||||