On Wed, May 1, 2013 at 9:27 AM, Klaas V <[email protected]> wrote:
> Eelco wrote: > Using version 3.7.16.2 > select * from ((select * from x)) y; > Segmentation fault > > > On OSX we get 'Bus error'. Thanks for the report. This bug has already been fixed. See http://www.sqlite.org/src/info/28c6e830f2 for the ticket and http://www.sqlite.org/src/info/1c79569226 for the patch. > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
