/ View Ticket
Login
Ticket Hash: 4feb3159c6bc3f7e33959c233f91c347c584bebb
Title: Crash due to misuse of window functions.
Status: Fixed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-02-22 21:35:59
Version Found In: 3.27.1
User Comments:
drh added on 2019-02-22 18:44:24: (text/x-fossil-wiki)
The following SQL statement causes a crash due to attempt to free memory
that was not obtained from malloc():

<blockquote><verbatim>
SELECT +sum(0)OVER() ORDER BY +sum(0)OVER();
</verbatim></blockquote>

This problem has existed in all prior versions of SQLite that support
window functions, beginning with version 3.25.0 (2018-09-15).