SQLite

View Ticket
Login
Ticket Hash: 256741a16be70df9c8d71f83f630592ee3879162
Title: null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...)
Status: Fixed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-08-15 14:36:11
Version Found In:
User Comments:
dan added on 2019-08-15 13:51:16: (text/x-fossil-wiki)
The following script:

<verbatim>
  CREATE TABLE t0(c0);
  INSERT INTO t0(c0) VALUES (0);
  SELECT * FROM t0 WHERE EXISTS (SELECT MIN(c0)  OVER (), CUME_DIST()
  OVER () FROM t0) BETWEEN 1 AND 1;
</verbatim>

causes a null pointer dereference.

This bug was discovered and reported by Manuel Rigger (user mrigger).

dan added on 2019-08-15 14:09:12: (text/x-fossil-wiki)
This bug appears in no released versions. Introduced in [7ef7b23cb].