Artifact
6a41349726a2b0b8a624f030b7706da5830e2256:
Ticket change
[6a413497]
- Ticket
[199df416] Different answer with and without index on IN operator with type mismatch status still Open with 6 other changes
by
drh
2016-09-03 15:24:12.
D 2016-09-03T15:24:12.190
J icomment This\sis\srelated\sto\s[93fb9f89d6a69dc3d8],\sthough\sthat\sprior\sticket\sdealt\r\nwith\sjoins\sinstead\sof\sIN\soperators.\s\sConsider:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\sb1(a\sTEXT);\sINSERT\sINTO\sb1\sVALUES(1);\r\nCREATE\sTABLE\sb2(x\sBLOB);\sINSERT\sINTO\sb2\sVALUES(1);\r\nSELECT\scount(*)\sFROM\sb1\sWHERE\sa\sIN\s(SELECT\sx\sFROM\sb2);\r\nSELECT\scount(*)\sFROM\sb1,\sb2\sWHERE\sa=x;\r\nCREATE\sUNIQUE\sINDEX\sb1a\sON\sb1(a);\r\nSELECT\scount(*)\sFROM\sb1\sWHERE\sa\sIN\s(SELECT\sx\sFROM\sb2);\r\nSELECT\scount(*)\sFROM\sb1,\sb2\sWHERE\sa=x;\r\n</verbatim></blockquote>\r\n\r\nThe\scode\sabove\sused\sto\sreturn\s"0\s0\s1\s1"\sprior\sto\scheck-in\s[e72186f2d6]\r\nwhich\swas\sthe\sfix\sfor\sticket\s[93fb9f89d6a69dc3d8].\s\sAfter\sthat\scheck-in\r\n(circa\s2009-08-13)\sthe\sanswer\sreturned\swas\s"0\s0\s1\s0".\s\sThe\scorrect\sanswer\r\nshould\sbe\s"0\s0\s0\s0".
J login drh
J mimetype text/x-fossil-wiki
J priority Immediate
J resolution Open
J subsystem Unknown
K 199df4168c7bb752a5a752cb46d5d364278f0d53
U drh
Z 2ec24cc539651a69b3683a2d7fc80a3a