[sqlite] Create VIEW passing despite invalid column name specified

[Tomasz Kot]

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