SQLite

View Ticket
Login
2020-06-11
16:04 Fixed ticket [b706351c]: Segfault in sqlite3Select plus 3 other changes (artifact: 01314052 user: drh)
15:53
Avoid rewriting compound SELECT statements that use a different collation sequence for ORDER BY and record processing a second time if they contain window functions. Fix for [b706351c]. (check-in: 32a88bdd user: dan tags: trunk)
15:47
Avoid rewriting compound SELECT statements that use a different collation sequence for ORDER BY and record processing a second time if they contain window functions. Fix for [b706351c]. (Closed-Leaf check-in: 50b4a1c7 user: dan tags: mistake)
01:12 Ticket [b706351c] Segfault in sqlite3Select status still Open with 6 other changes (artifact: b07b31dd user: drh)
2020-06-10
21:19 New ticket [b706351c]. (artifact: 5b0601ce user: yongheng)

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:

Bisected to check-in [c29a9e484e1dd245] from yesterday and the bug-fix for ticket [7c6d876f84e6e7e2].