Artifact
b556e7c9998dd37c6efa6c9663998d510316cb52:
Ticket change
[b556e7c999]
- New ticket
[98825a79ce] Incorrect result from a DISTINCT + GROUP BY + ORDER BY query.
by
drh
2014-04-03 15:17:34.
D 2014-04-03T15:17:34.655
J foundin 3.8.4.2
J icomment The\sfollowing\squery\sanswers\s'wrong'\seven\sthough\sthe\scorrect\sanswer\sis\s'right':\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(x);\r\nINSERT\sINTO\st1\sVALUES('right'),('wrong');\r\nSELECT\sDISTINCT\sx\r\n\sFROM\s(SELECT\sx\sFROM\st1\sGROUP\sBY\sx)\r\n\sWHERE\sx='right'\r\n\sORDER\sBY\sx;\r\n</verbatim></blockquote>\r\n\r\nBisecting\sshows\sthat\sthis\sproblem\swas\sintroduced\sby\scheck-in\r\n[1e64dd782a126f48d78c4]\son\s2014-02-08\sand\sfirst\sappeared\sin\r\nSQLite\sversion\s3.8.4.
J login drh
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title Incorrect\sresult\sfrom\sa\sDISTINCT\s+\sGROUP\sBY\s+\sORDER\sBY\squery
J type Code_Defect
K 98825a79ce145686392d8074032ae54863aa21a3
U drh
Z 9d7356845b69e18e6af8fec115db2eb9