Hi, I have noticed a change between 3.30 and 3.31.1 and searched for more info on "unsafe use of virtual table" on sqlite.org but could not find anything relevant.
In 3.30: SQLite version 3.30.0 2019-10-04 15:03:17 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create view somestats as select name, pgoffset from dbstat; sqlite> select * from somestats; sqlite_master|0 But in 3.31.1: SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create view somestats as select name, pgoffset from dbstat; sqlite> select * from somestats; Error: unsafe use of virtual table "dbstat" Could someone point me to where I can find more info on unsafe use of virtual tables? Thanks Tom _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users