On Thu, Jun 23, 2016 at 9:54 AM, Mark Brand <[email protected]> wrote:
> > Hi, > > Just wondering about the apparent variation among sqlite3 versions and/or > configurations with respect to the "no such table" error. In some cases > it's enforced at view creation and in others at execution. > > https://www.sqlite.org/releaselog/3_9_0.html Version 3.9.0 is backwards compatible with 3.8.11, but not forwards compatible. In other words, if it works in 3.8.11 it will also work in 3.9.0 and later. But some things work in 3.9.0 and later which are not recognized by 3.8.11 and before. > Mark > > > SQLite version 3.8.7.1 2014-10-29 13:59:56 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> create view v as select a from t; > Error: no such table: main.t > sqlite> > > > SQLite version 3.13.0 2016-05-18 10:57:30 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> create view v as select * from t; > sqlite> select * from v; > Error: no such table: main.t > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
