SQLite

Artifact [23c14e4a]
Login

Artifact 23c14e4ae53293a5067ae105a3a78a5a49821eab6fecfdeeae39f9aa45cf0ad1:

Ticket change [23c14e4a] - Ticket [787fa716] Assertion fault when multi-use subquery implemented by co-routine status still Open with 4 other changes by drh 2018-11-09 13:39:45.
D 2018-11-09T13:39:45.951
J icomment Here\sis\sanother\stest\scase\sthat\sdoes\snot\smake\suse\sof\sthe\sIN\soperator.\r\nThe\scommon\sfactor\sis\snow\sthe\suse\sof\sco-routines\sto\simplement\sa\ssubquery\sand\r\nthen\sevaluating\sthat\ssubquery\smore\sthan\sonce.\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(a1,\sa2,\sa3);\r\nCREATE\sINDEX\st1a2\sON\st1(a2,\sa1);\r\nCREATE\sINDEX\st1a3\sON\st1(a3,\sa1);\r\nCREATE\sTABLE\st2(d);\r\nINSERT\sINTO\st1\sVALUES(1,\s1,\s1),\s(2,\s2,\s2);\r\nINSERT\sINTO\st2\sVALUES(22);\r\nSELECT\s*\sFROM\st1\sWHERE\s(a2=1\sOR\sa3=2)\sAND\sa1\s=\s(\r\n\s\sSELECT\sd\sFROM\s(SELECT\sDISTINCT\sd\sFROM\st2)\sWHERE\sd=22\r\n);\r\n</verbatim></blockquote>\r\n\r\nThis\snew\stest\scase\sdemonstrates\sthat\scheckin\s[8d663bfaaa4656c4f4ff1]\sis\r\nnot\sa\ssolution\sto\sthe\sproblem.
J login drh
J mimetype text/x-fossil-wiki
J title Assertion\sfault\swhen\smulti-use\ssubquery\simplemented\sby\sco-routine
K 787fa716be3a7f650cac1b1413f12f95f5e7639d
U drh
Z 1b7d76ed10baf547dfe6df700d3f0583