SQLite

View Ticket
Login
2020-05-25
15:19
Defensive code that tries to prevent a recurrence of problems like the one described in ticket [7a5279a25c57adf1] (check-in: 572105de user: drh tags: trunk)
2020-05-24
03:39 Fixed ticket [7a5279a2]: Segfault in sqlite3ExprCodeTarget plus 5 other changes (artifact: b803c5fe user: drh)
03:38
When rewriting a query for window functions, if the rewrite changes the depth of TK_AGG_FUNCTION nodes, be sure to adjust the Expr.op2 field appropriately. Fix for ticket [7a5279a25c57adf1] (check-in: ad7bb70a user: drh tags: trunk)
2020-05-23
17:53 New ticket [7a5279a2] Segfault in sqlite3ExprCodeTarget. (artifact: 420e884f user: yongheng)

Ticket Hash: 7a5279a25c57adf100d5480b237802cc971d9586
Title: Segfault in sqlite3ExprCodeTarget
Status: Fixed Type: Code_Defect
Severity: Important Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-05-24 03:39:26
Version Found In:
User Comments:
yongheng added on 2020-05-23 17:53:27:
Affect latest release version

POC:
---
CREATE TABLE a(c UNIQUE);
SELECT a.c FROM a JOIN a b ON 3 = a.c NATURAL JOIN a WHERE a.c IN((SELECT(SELECT coalesce(lead(2) OVER(), SUM(c))) FROM a d WHERE a.c));
---