Artifact
0d3537a720242f7e5bd4240fd2b4dec681a287ce2849602fcf9f7b9f5d98db3a:
Ticket change
[0d3537a7]
- Ticket
[787fa716] Assertion fault due to IN operator status still Open with 3 other changes
by
drh
2018-11-08 22:03:39.
D 2018-11-08T22:03:39.358
J icomment Here\sis\sa\svariant\sof\sthe\ssecond\stest\scase\sthat\sdoes\snot\srequire\sthe\smanual\r\ndisabling\sof\sthe\squery\sflattener:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1\s(a);\sINSERT\sINTO\st1\s(a)\sVALUES\s(104);\r\nCREATE\sTABLE\st2\s(b);\sINSERT\sINTO\st2\s(b)\sVALUES\s(104);\r\nCREATE\sTABLE\st3\s(c);\sINSERT\sINTO\st3\s(c)\sVALUES\s(104);\r\nCREATE\sTABLE\st4\s(d);\sINSERT\sINTO\st4\s(d)\sVALUES\s(104);\r\nSELECT\s*\r\nFROM\st1\sCROSS\sJOIN\st2\sON\s(t1.a\s=\st2.b)\sWHERE\st2.b\sIN\s(\r\n\s\sSELECT\st3.c\r\n\s\sFROM\st3\r\n\s\sWHERE\st3.c\sIN\s(\r\n\s\s\s\sSELECT\sd\sFROM\s(SELECT\sDISTINCT\sd\sFROM\st4)\sAS\sx\sWHERE\sx.d=104\r\n\s\s)\r\n);\r\n</verbatim></blockquote>
J login drh
J mimetype text/x-fossil-wiki
K 787fa716be3a7f650cac1b1413f12f95f5e7639d
U drh
Z d24a1b0392861b7c076cb1c705f012a5