/ Artifact Content
Login

Artifact 7da230dd8d0b01a6f5ba35a08fdeea3b0680e9f74f88173e5495266e69da272c:

Ticket change [7da230dd] - Ticket [787fa716] Assertion fault using window functions status still Open with 6 other changes by drh 2018-11-08 19:27:38.
D 2018-11-08T19:27:38.719
J icomment This\sappears\sto\shave\snothing\sto\sdo\swith\swindow\sfunctions.\s\sThe\suse\sof\swindow\r\nfunctions\sin\sthe\sexample\sabove\smerely\sdisables\sthe\squery\sflattener.\s\sThe\r\nproblem\scan\salso\sbe\sseen\sin\sthe\sfollowing\squery:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1\s(a);\r\nCREATE\sTABLE\st2\s(b);\r\nCREATE\sTABLE\st3\s(c);\r\nCREATE\sTABLE\st4\s(d);\r\nINSERT\sINTO\st1\s(a)\sVALUES\s(104);\r\nINSERT\sINTO\st2\s(b)\sVALUES\s(104);\r\nINSERT\sINTO\st3\s(c)\sVALUES\s(104);\r\nINSERT\sINTO\st4\s(d)\sVALUES\s(104);\r\n\r\n--\sDisable\sthe\squery-flattener\r\n.testctrl\soptimizations\s0x01\r\n\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\sd\sFROM\st4)\sAS\sinnermost\sWHERE\sinnermost.d=104\r\n\s\s)\r\n);\r\n</verbatim></blockquote>\r\n\r\nThe\squery\sabove\sfails\sin\sall\sversions\sof\sSQLite\sfrom\s3.8.11\sand\slater.\s\sThe\r\ncheck-in\sthat\scauses\sthe\sfailure\sis\s[020b8b106fc8f840f6b506e1c9c3b]\son\r\n2015-05-29
J login drh
J mimetype text/x-fossil-wiki
J priority Immediate
J resolution Open
J subsystem Unknown
K 787fa716be3a7f650cac1b1413f12f95f5e7639d
U drh
Z ed4e77126f662103b982e079d62d7a9f