/ 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. Change icomment to:

    The following SQL causes an ALWAYS() macro to fail:

    SELECT (SELECT 'mmm' UNION SELECT DISTINCT max(name) ORDER BY 1) 
      FROM sqlite_master;
    

    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. Change login to "drh"
  3. Change mimetype to "text/x-fossil-wiki"
  4. Change severity to "Critical"
  5. Change status to "Open"
  6. Change title to:

    Assertion fault on DISTINCT query containing a correlated aggregate.

  7. Change type to "Code_Defect"