SQLite

View Ticket
Login
2020-06-11
01:12 Ticket [b706351c] Segfault in sqlite3Select status still Open with 6 other changes (artifact: b07b31dd user: drh)
2020-06-10
11:18
Ensure that aggregate functions that (a) are part of SELECT statements with no FROM clause and (b) have one or more scalar sub-selects as arguments are assigned to the correct aggregate context. Fix for ticket [7c6d876f84e6e7e2] (check-in: dafd2466 user: dan tags: branch-3.32)
2020-06-09
23:50 Fixed ticket [7c6d876f]: Use after free in resetAccumulator. plus 5 other changes (artifact: 0f214f19 user: drh)
23:50
Ensure that aggregate functions that (a) are part of SELECT statements with no FROM clause and (b) have one or more scalar sub-selects as arguments are assigned to the correct aggregate context. Fix for ticket [7c6d876f84e6e7e2] (check-in: c29a9e48 user: drh tags: trunk)
13:17
Persist AggInfo expressions before deleting them when omitting the LIMIT clause in a subquery. One possible fix for ticket [7c6d876f84e6e7e2]. (Leaf check-in: 04867cba user: drh tags: tkt-7c6d876f84e6e7e2)
2020-06-08
20:26 New ticket [7c6d876f] Use after free in resetAccumulator.. (artifact: c4f17a31 user: yongheng)

Ticket Hash: 7c6d876f84e6e7e25621132dc9c244fb19ddc8e6
Title: Use after free in resetAccumulator.
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-06-09 23:50:53
Version Found In:
User Comments:
yongheng added on 2020-06-08 20:26:10:
Seems the fix is still incorrect.

POC:
---
CREATE TABLE a(b);
WITH c AS(SELECT a)
    SELECT(SELECT(SELECT zipfile(0, b, b)
                      LIMIT(SELECT 0.100000 *
                            AVG(DISTINCT(SELECT 0 FROM a ORDER BY b, b, b))))
               FROM a GROUP BY b,
           b, b) FROM a EXCEPT SELECT b FROM a ORDER BY b,
    b, b;
---