| 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:
(text/x-fossil-wiki)
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. | ||||