<verbatim>
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
</verbatim>
<hr><i>drh added on 2010-04-15 14:43:49:</i><br>
The problem was introduced by check-in [edca8913ca012fc0c17343a27f819de95147b1bd]
on [2005-10-06].
|