SQLite

Ticket Change Details
Login
Overview

Artifact ID: ef08d208efffd5eca35ee3d747f3a2cf6c6638d293f05576a1a482ffc9770c15
Ticket: 256741a16be70df9c8d71f83f630592ee3879162
null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...)
User & Date: dan 2019-08-15 13:51:16
Changes

  1. icomment:
    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).
    
  2. login: "dan"
  3. mimetype: "text/x-fossil-wiki"
  4. severity changed to: "Critical"
  5. status changed to: "Open"
  6. title changed to:
    null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...)
    
  7. type changed to: "Code_Defect"