|
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-07
| ||
| 00:51 | Extra steps to ensure that queries that involve both window functions and aggregate functions are processed correctly by sqlite3WindowRewrite(). Fix for ticket [e5504e987e419fb0]. (Leaf check-in: 765bbcce user: drh tags: branch-3.32-early-winfunc-rewrite) | |
| 00:43 | • Fixed ticket [e5504e98]: Segfault in sqlite3VdbeCursorMoveto plus 5 other changes (artifact: 42cf529a user: drh) | |
| 00:43 | Extra steps to ensure that queries that involve both window functions and aggregate functions are processed correctly by sqlite3WindowRewrite(). Fix for ticket [e5504e987e419fb0]. (check-in: a6c2147c user: drh tags: early-winfunc-rewrite-dev) | |
|
2020-06-06
| ||
| 23:21 | • New ticket [e5504e98] Segfault in sqlite3VdbeCursorMoveto. (artifact: bc502e93 user: yongheng) | |
| Ticket Hash: | e5504e987e419fb0ddd5a27ff66a79f36d1af453 | |||
| Title: | Segfault in sqlite3VdbeCursorMoveto | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Minor | Priority: | Low | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2020-06-07 00:43:52 | |||
| Version Found In: | ||||
| User Comments: | ||||
yongheng added on 2020-06-06 23:21:36:
POC: --- CREATE TABLE v0 ( v1 INTEGER PRIMARY KEY ) ; INSERT INTO v0 VALUES ( 4294967295 ) ; SELECT NTILE ( ( SELECT 10.100000 * SUM ( CASE WHEN v1 LIKE 'abc' THEN v1 * ( 127 - v1 ) ELSE 9223372036854775807 END ) WHERE v1 = v1 ) ) OVER( ORDER BY v1 ) - 1 AS nt , min ( v1 ) OVER( PARTITION BY v1 ORDER BY v1 ) FROM v0 WHERE v1 = 2 AND v1 IN ( SELECT v1 FROM v0 ) ; --- | ||||