Hello,
Beneath sql shall throw an error on CREATE VIEW statement (as invalid
column is specified), but it passes (SQLite 3.23.1).
CREATE TABLE "testTable" ( "name" text not null );
INSERT INTO testTable values ('Tom');
SELECT * FROM testTable;
CREATE VIEW testView AS SELECT nameWrong FROM testTable;
SELECT * FROM testView;
SELECT * FROM sqlite_master;
Regards,
Tom
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
