The LIMIT on the final SELECT in the following code does not work:
<verbatim>
CREATE TABLE t1(x);
INSERT INTO t1 VALUES(5);
CREATE VIEW v1 AS SELECT x*2 FROM t1;
CREATE VIEW v2 AS SELECT * FROM v1 UNION ALL SELECT * FROM v1;
CREATE VIEW v4 AS SELECT * FROM v2 UNION ALL SELECT * FROM v2;
SELECT * FROM v4 LIMIT 3;
</verbatim>
The problem seems to have been introduced by check-ins [3ef468e7046b209]
or [a79786a961dba8] on 2008-07-01. The problem first appeared in version
3.6.1. The problem was detected during internal testing and has never
been seen in the wild.

Change login to "drh"

Change mimetype to "text/x-fossil-wiki"

Change severity to "Important"

Change status to "Open"

Change title to:

LIMIT does not work with nested views containing UNION ALL

Change type to "Code_Defect"

This page was generated in about
0.004s by
Fossil version 1.32 [ec44ff010f] 2015-03-31 00:15:02