/ Artifact Content
Login

Artifact 530cc4a7a2f9f11aaa1b0433bf77ab416a50fd0d:

Ticket change [530cc4a7] - New ticket [10fb063b] Duplicate row output on an OR query. by drh 2014-04-10 02:09:30.
D 2014-04-10T02:09:30.698
J foundin 3.8.4.3
J icomment The\sfollowing\squery\sreturns\stwo\srows\sinstead\sof\sjust\sone:\r\n\r\n<blockquote><verbatim>\r\ncreate\stable\st(c0,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17);\r\ncreate\sindex\stc0\son\st(c0);\r\ncreate\sindex\stc1\son\st(c1);\r\ncreate\sindex\stc2\son\st(c2);\r\ncreate\sindex\stc3\son\st(c3);\r\ncreate\sindex\stc4\son\st(c4);\r\ncreate\sindex\stc5\son\st(c5);\r\ncreate\sindex\stc6\son\st(c6);\r\ncreate\sindex\stc7\son\st(c7);\r\ncreate\sindex\stc8\son\st(c8);\r\ncreate\sindex\stc9\son\st(c9);\r\ncreate\sindex\stc10\son\st(c10);\r\ncreate\sindex\stc11\son\st(c11);\r\ncreate\sindex\stc12\son\st(c12);\r\ncreate\sindex\stc13\son\st(c13);\r\ncreate\sindex\stc14\son\st(c14);\r\ncreate\sindex\stc15\son\st(c15);\r\ncreate\sindex\stc16\son\st(c16);\r\ncreate\sindex\stc17\son\st(c17);\r\n\r\ninsert\sinto\st(c0,\sc16)\sVALUES\s(1,1);\r\n\r\nselect\s*\sfrom\st\swhere\r\n\s\sc0=1\sor\s\sc1=1\sor\s\sc2=1\sor\s\sc3=1\sor\r\n\s\sc4=1\sor\s\sc5=1\sor\s\sc6=1\sor\s\sc7=1\sor\r\n\s\sc8=1\sor\s\sc9=1\sor\sc10=1\sor\sc11=1\sor\r\n\s\sc12=1\sor\sc13=1\sor\sc14=1\sor\sc15=1\sor\r\n\s\sc16=1\sor\sc17=1;\r\n</verbatim></blockquote>\r\n\r\nThis\sproblem\shas\sbeen\slatent\sin\sthe\scode\sfor\sabout\s5\syears,\ssince\scheckin\r\n[b101cf70b75c9772aaf]\sof\sversion\s3.6.14.\s\sThe\sbug\swas\sfound\sby\sPeter\sReid\r\nand\sreported\son\sthe\ssqlite-dev\smailing\slist.
J login drh
J mimetype text/x-fossil-wiki
J severity Important
J status Open
J title Duplicate\srow\soutput\son\san\sOR\squery
J type Code_Defect
K 10fb063b1179be53ea0b53bbb4459b5597541a4b
U drh
Z 876a78deaa72f4696bd8f0a9978882ab