On 3/28/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > With Debian-packaged sqlite3-3.2.8-1: > > $ sqlite3 > SQLite version 3.2.8 > Enter ".help" for instructions > sqlite> create table t (a); > sqlite> select * from (select count(a) as b from t) where b > 1; > sqlite> select count(a) as b from t where b > 1; > Segmentation fault > $ >
Works ok here: C:\Temp\sqliteImport>sqlite3 SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table t (a); sqlite> select * from (select count(a) as b from t) where b > 1; sqlite> select count(a) as b from t where b > 1; 0 sqlite>
