D 2016-02-08T22:22:47.128
J foundin 3.10.2
J icomment The\sfollowing\sSQL\scode\sgenerates\san\sincorrect\sanswer\sof\sthree\srows\sinstead\sof\stwo:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\stx(id\sINTEGER\sPRIMARY\sKEY,\sa,\sb);\r\nINSERT\sINTO\stx(a,b)\sVALUES(33,456);\r\nINSERT\sINTO\stx(a,b)\sVALUES(33,789);\r\n\r\nSELECT\sDISTINCT\st0.id,\st0.a,\st0.b\r\n\s\sFROM\stx\sAS\st0,\stx\sAS\st1\r\n\sWHERE\st0.a=t1.a\sAND\st1.a=33\sAND\st0.b=456\r\nUNION\r\nSELECT\sDISTINCT\st0.id,\st0.a,\st0.b\r\n\s\sFROM\stx\sAS\st0,\stx\sAS\st1\r\n\sWHERE\st0.a=t1.a\sAND\st1.a=33\sAND\st0.b=789\r\n\sORDER\sBY\s1;\r\n</verbatim></blockquote>\r\n\r\nPrior\sto\sand\sincluding\scheck-in\s[93121d3097a43997]\s(version\s3.8.3,\s2013-12-17)\s\r\nthe\scorrect\sanswer\swas\sobtained.\s\sAfter\sthat,\sthe\stest\sscript\sabove\sgenerates\r\nan\sassertion\sfault.\s\sAt\scheck-in\s[c0fa0c0e2de50d7e]\s(version\s3.8.4,\s2014-03-03)\r\nthe\sassertion\sfaults\sgo\saway,\sbut\sthe\sincorrect\sanswer\sis\sreturned.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title Incorrect\sresult\sfrom\sa\sUNION\swith\san\sORDER\sBY
J type Code_Defect
K d06a25c84454a372be4e4c970c3c4d4363197219
U drh
Z 5bd666cf5cf148844844dea3054d8188