SQLite

View Ticket
Login
Ticket Hash: e5c6268dd807fa89500c4c0887ca8e9f62b5334f
Title: Assertion fault on DISTINCT query containing a correlated aggregate.
Status: Fixed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2015-11-24 02:10:58
Version Found In:
User Comments:
drh added on 2015-11-24 02:08:45:

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.