Ticket Hash: | 02a8e81d4457d3627ad49b5e0adbce9d1ecdd38e | |||
Title: | LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly | |||
Status: | Fixed | Type: | Code_Defect | |
Severity: | Important | Priority: | Immediate | |
Subsystem: | Code_Generator | Resolution: | Fixed | |
Last Modified: | 2010-04-15 23:26:14 | |||
Version Found In: | 3.6.23 | |||
Description: | ||||
dan@computer2:~/work/sqliteG/bld$ ./sqlite3 SQLite version 3.6.23 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t1(a); sqlite> insert into t1 values(1); sqlite> insert into t1 values(2); sqlite> select * from (select * from t1 LIMIT 1) UNION ALL select 3; 1 sqlite> select * from (select * from t1 LIMIT 1) UNION select 3; 1 3 drh added on 2010-04-15 14:43:49: |