SQLite

Ticket Change Details
Login
Overview

Artifact ID: 0d68ffc024082b9a81f995ca77a1d8b7275c0b8c
Ticket: e5c6268dd807fa89500c4c0887ca8e9f62b5334f
Assertion fault on DISTINCT query containing a correlated aggregate.
User & Date: drh 2015-11-24 02:08:45
Changes

  1. icomment:
    The following SQL causes an ALWAYS() macro to fail:
    
    <blockquote><verbatim>
    SELECT (SELECT 'mmm' UNION SELECT DISTINCT max(name) ORDER BY 1) 
      FROM sqlite_master;
    </verbatim></blockquote>
    
    This problem appears to have been introduced by check-in [7ab0b258eabfcfb7]
    on 2015-09-05 for release 3.9.0.  The problem was discovered by 
    Kostya Serebryany using libFuzzer.
    
  2. login: "drh"
  3. mimetype: "text/x-fossil-wiki"
  4. severity changed to: "Critical"
  5. status changed to: "Open"
  6. title changed to:
    Assertion fault on DISTINCT query containing a correlated aggregate.
    
  7. type changed to: "Code_Defect"