Artifact
0d68ffc024082b9a81f995ca77a1d8b7275c0b8c:
Ticket change
[0d68ffc0]
- New ticket
[e5c6268d] Assertion fault on DISTINCT query containing a correlated aggregate..
by
drh
2015-11-24 02:08:45.
D 2015-11-24T02:08:45.812
J icomment The\sfollowing\sSQL\scauses\san\sALWAYS()\smacro\sto\sfail:\r\n\r\n<blockquote><verbatim>\r\nSELECT\s(SELECT\s'mmm'\sUNION\sSELECT\sDISTINCT\smax(name)\sORDER\sBY\s1)\s\r\n\s\sFROM\ssqlite_master;\r\n</verbatim></blockquote>\r\n\r\nThis\sproblem\sappears\sto\shave\sbeen\sintroduced\sby\scheck-in\s[7ab0b258eabfcfb7]\r\non\s2015-09-05\sfor\srelease\s3.9.0.\s\sThe\sproblem\swas\sdiscovered\sby\s\r\nKostya\sSerebryany\susing\slibFuzzer.
J login drh
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title Assertion\sfault\son\sDISTINCT\squery\scontaining\sa\scorrelated\saggregate.
J type Code_Defect
K e5c6268dd807fa89500c4c0887ca8e9f62b5334f
U drh
Z ee6144f5c9e090482def20b420ef9368