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
14:44 Fixed ticket [0899cf62]: Segfault in sqlite3VdbeExec plus 5 other changes (artifact: b4bdfece user: drh)
14:44
When rewriting the parse-tree for window functions, ensure that the inserted subqueries have an accurate SF_Aggregate bit set. This change also coincidentally fixes ticket [0899cf62f597d7e7], even thought that was not the issue we were working on at the time. (check-in: 2cddb24e user: drh tags: early-winfunc-rewrite-dev)
2020-06-05
23:21 New ticket [0899cf62] Segfault in sqlite3VdbeExec. (artifact: caa07d55 user: yongheng)

Ticket Hash: 0899cf62f597d7e7f5a573727be0fd927ce82f26
Title: Segfault in sqlite3VdbeExec
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-06-06 14:44:48
Version Found In:
User Comments:
yongheng added on 2020-06-05 23:21:55:
Seems a newly introduced problem.

POC:
---
CREATE TABLE v0 ( v1 INTEGER PRIMARY KEY ) ; 
INSERT INTO v0 VALUES ( 10 ) ; 
SELECT DISTINCT v1 , lead ( v1 ) OVER( ) FROM v0 GROUP BY v1 ORDER BY 1 , 2 , 1 ;