SQLite

View Ticket
Login
Ticket Hash: b706351ce2ecf59a24ecc660cad3f8356d4c65b9
Title: Segfault in sqlite3Select
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-06-11 16:04:22
Version Found In: trunk
User Comments:
yongheng added on 2020-06-10 21:19:55:
Tested on trunk.

POC:
---
CREATE TABLE a(b);
SELECT SUM(0) OVER(ORDER BY(SELECT max(b) OVER(
    PARTITION BY SUM((SELECT b FROM a UNION SELECT b ORDER BY b)))
                                INTERSECT SELECT b FROM a ORDER BY b)) FROM a;
---

drh added on 2020-06-11 01:12:43: (text/x-fossil-wiki)
Bisected to check-in [c29a9e484e1dd245] from yesterday and the bug-fix for
ticket [7c6d876f84e6e7e2].