|
2020-04-03
| ||
| 13:39 | Do not suppress errors when resolving references in an ORDER BY clause belonging to a compound SELECT within a view or trigger within ALTER TABLE. Fix for ticket [a10a14e9b4ba2]. Also, in the event of a semantic error in an aggregate query, early-out the resetAccumulator() function to prevent problems due to incomplete or incorrect initialization of the AggInfo object. Fix for ticket [af4556bb5c285c08]. (check-in: b6467491 user: drh tags: branch-3.31) | |
| 13:19 | • Fixed ticket [af4556bb]: Segfault while trying to prepare a malformed window-function query plus 5 other changes (artifact: 2a937ba0 user: drh) | |
| 13:19 | In the event of a semantic error in an aggregate query, early-out the resetAccumulator() function to prevent problems due to incomplete or incorrect initialization of the AggInfo object. Fix for ticket [af4556bb5c285c08]. (check-in: 4a302b42 user: drh tags: trunk) | |
| 11:45 | • New ticket [af4556bb] Segfault while trying to prepare a malformed window-function query. (artifact: f36b87cd user: drh) | |
| Ticket Hash: | af4556bb5c285c0800b837ab60802c707ec635c1 | |||
| Title: | Segfault while trying to prepare a malformed window-function query | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Low | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2020-04-03 13:19:17 | |||
| Version Found In: | 3.31.1 | |||
| User Comments: | ||||
|
drh added on 2020-04-03 11:45:52:
Henry Liu of Shenzhen Ankki Technologies Co.Ltd. sends in the following SQL snippet that causes a segfault while preparing. <blockquuote>
CREATE TABLE a(b, c);
SELECT c FROM a GROUP BY c
HAVING(SELECT(sum(b) OVER(ORDER BY b),
sum(b) OVER(PARTITION BY min(DISTINCT c), c ORDER BY b)));
This query has caused problems ever since support for window functions was added on 2018-06-30 (version 3.25.0). The problem expressed as an assertion fault up until check-in [712e47714863a8ed] (2019-08-10) at which point it began to segfault. | ||||