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.
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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
