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\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\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