D 2019-11-07T21:58:13.303
J foundin 3.30.0
J icomment In\sthe\sfollowing\stest\scase,\sunexpectedly,\sfour\srows\sare\sfetched,\salso\scontaining\stwo\srows\swith\sduplicate\sv0.c0=1\svalues:\r\n\r\n<pre>\r\nCREATE\sTABLE\st0(c0);\r\nCREATE\sVIRTUAL\sTABLE\svt0\sUSING\sfts5(c0);\r\nINSERT\sINTO\st0(c0)\sVALUES\s(1),\s(0);\r\nINSERT\sINTO\svt0(c0)\sVALUES\s(0),\s(0);\r\nCREATE\sVIEW\sv0\sAS\sSELECT\sDISTINCT\st0.c0\sFROM\svt0,\st0\sORDER\sBY\svt0.rowid;\r\nSELECT\s*\sFROM\sv0;\s--\sunexpected:\s4\srows\sare\sfetched\r\n</pre>\r\n\r\nThe\sDISTINCT\sseems\sto\swork\scorrectly\swhen\sused\stogether\swith\sa\sCOUNT:\r\n\r\n<pre>\r\nSELECT\sCOUNT(*)\sFROM\sv0\sWHERE\sv0.c0;\s--\s1\r\n</pre>
J login mrigger
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title DISTINCT\smalfunctions\sfor\sVIEW\swith\svirtual\stable
J type Code_Defect
K 7e59041f9c4e5102b483592c781be2d2497791fd
U mrigger
Z 2401e079d9e235bf3b3e717b34485365