| 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 4.85 years |
Created: |
2020-06-13 18:52:27 4.85 years |
| 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 ) ; --- | ||||