Eelco wrote: Using version 3.7.16.2 select * from ((select * from x)) y; Segmentation fault
On OSX we get 'Bus error'. Not a bug, because you were syntactical not exact enough. See http://www.sqlite.org/lang_select.html You're supposed to use only one pair () not more. Before 3.7.15 or 16 the extra pair were user friendly ignored. Following example from an ancient version where you see that existence of a table makes a difference: SQLite version 3.6.12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table dual (dummy); sqlite> insert into dual values (1); sqlite> .schema CREATE TABLE dual (dummy); sqlite> select * from dual; 1 sqlite> select * from ((select * from x)) y; SQL error: no such table: x sqlite> select * from ((select * from dual)) bar; 1 sqlite> select * from (select * from dual) bar; 1 An example where newer versions ask more attention to developers. Cordiali saluti/Vriendelijke groeten/Kind regards, Klaas "Z4us" V MetaDBA _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users