SQLite

View Ticket
Login
2020-06-08
11:38 Closed ticket [f7d89085]: Segfault in moveToRoot plus 6 other changes (artifact: 41c2d826 user: drh)
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-07
03:01 New ticket [f7d89085] Segfault in moveToRoot. (artifact: 88abc01a user: yongheng)

Ticket Hash: f7d890858f36140217633aeb361aa63845ee50f8
Title: Segfault in moveToRoot
Status: Closed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Overcome_By_Events
Last Modified: 2020-06-08 11:38:56
Version Found In:
User Comments:
yongheng added on 2020-06-07 03:01:48:
POC:
---
CREATE TABLE v0 ( v1 INTEGER PRIMARY KEY ) ; INSERT INTO v0 VALUES ( 99 ) ; SELECT EXISTS ( SELECT count ( * ) OVER( ) FROM v0 ORDER BY sum ( v1 ) OVER( ) ) ;
---

drh added on 2020-06-08 11:38:56:

The changes that caused this problem are no longer on trunk.