SQLite

View Ticket
Login
2020-06-08
11:34
When an Expr object is changed and that Expr is referenced by an AggInfo, then also update the AggInfo. Also, persist all AggInfo objects until the Parse object is destroyed. This is a new fix for ticket [c8d3b9f0a750a529] that avoids the follow-on problems identified by tickets [0899cf62f597d7e7], [1f6f353b684fc708], [e5504e987e419fb0], and [f7d890858f361402]. (check-in: 6e6b3729 user: drh tags: trunk)
2020-06-06
19:36 Fixed ticket [1f6f353b]: Segfault in sqlite3VdbeExec plus 5 other changes (artifact: 94be72fc user: drh)
19:35
When determining if the subquery inserted by the window-function rewriter is an aggregate query, aggregate functions that are in parameters to another window function do not count. Fix for ticket [1f6f353b684fc708] (check-in: 8583c348 user: drh tags: early-winfunc-rewrite-dev)
17:03 New ticket [1f6f353b] Segfault in sqlite3VdbeExec. (artifact: 955543e2 user: yongheng)

Ticket Hash: 1f6f353b684fc708c167f9c025d876c417e2d083
Title: Segfault in sqlite3VdbeExec
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-06-06 19:36:24
Version Found In:
User Comments:
yongheng added on 2020-06-06 17:03:48:
Seems the root cause is not fixed.

POC:
---
CREATE TABLE a(b, c);
SELECT sum(c) OVER(), sum(coalesce(max(c), b)) OVER(ORDER BY c) FROM a;
---