Overview
| Artifact ID: | 8c39a3c9eea9052401592867ebd59dce6f6dbfe8 |
|---|---|
| Ticket: | db4d96798da8b9707f76509e57d745d64a92e880
LIMIT does not work with nested views containing UNION ALL |
| Date: | 2013-01-28 19:34:30 |
| User: | drh |
Changes
- Change foundin to "3.7.15.2"
- Change icomment to:
The LIMIT on the final SELECT in the following code does not work:
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;
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"