Artifact
8c39a3c9eea9052401592867ebd59dce6f6dbfe8:
Ticket change
[8c39a3c9]
- New ticket
[db4d9679] LIMIT does not work with nested views containing UNION ALL.
by
drh
2013-01-28 19:34:30.
D 2013-01-28T19:34:30.270
J foundin 3.7.15.2
J icomment The\sLIMIT\son\sthe\sfinal\sSELECT\sin\sthe\sfollowing\scode\sdoes\snot\swork:\r\n\r\n<verbatim>\r\nCREATE\sTABLE\st1(x);\r\nINSERT\sINTO\st1\sVALUES(5);\r\nCREATE\sVIEW\sv1\sAS\sSELECT\sx*2\sFROM\st1;\r\nCREATE\sVIEW\sv2\sAS\sSELECT\s*\sFROM\sv1\sUNION\sALL\sSELECT\s*\sFROM\sv1;\r\nCREATE\sVIEW\sv4\sAS\sSELECT\s*\sFROM\sv2\sUNION\sALL\sSELECT\s*\sFROM\sv2;\r\nSELECT\s*\sFROM\sv4\sLIMIT\s3;\r\n</verbatim>\r\n\r\nThe\sproblem\sseems\sto\shave\sbeen\sintroduced\sby\scheck-ins\s[3ef468e7046b209]\r\nor\s[a79786a961dba8]\son\s2008-07-01.\s\sThe\sproblem\sfirst\sappeared\sin\sversion\r\n3.6.1.\s\sThe\sproblem\swas\sdetected\sduring\sinternal\stesting\sand\shas\snever\r\nbeen\sseen\sin\sthe\swild.
J login drh
J mimetype text/x-fossil-wiki
J severity Important
J status Open
J title LIMIT\sdoes\snot\swork\swith\snested\sviews\scontaining\sUNION\sALL
J type Code_Defect
K db4d96798da8b9707f76509e57d745d64a92e880
U drh
Z 6c33aa6a3f5e877110a86b9582a7e6bc