On 29 Mar 2019, at 1:55pm, Dan Kennedy <danielk1...@gmail.com> wrote:
> The error doesn't occur unless you actually query the view though, correct? My theory on SQLite was that the VIEW definition was only syntax-checked and not compiled in any way. So you could do CREATE VIEW v as select * from t ORDER BY a; CREATE TABLE t (a INTEGER UNIQUE); ... use view v a few times ... DROP TABLE t; CREATE TABLE t (a TEXT, b REAL); ... use view v a few more times ... changing what the view meant, whether a temporary index was needed, and how many columns would be returned, without having to recreate the view. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
