Hi, noticed that attempt to open a database containing a view Create vew ... with recursive ...
... with older (non-cte) versions of sqlite failed. The call to open_v2 was ok, but any access for example to PRAGMA encoding led to "malformed database schema" error. Although it came as no big surprise, probably one might expect delayed handling behavior as with virtual tables so it don't face incompatibility until referenced in a query. So probably either https://www.sqlite.org/lang_createview.html or https://sqlite.org/lang_with.html might contain a little sentence about such incompatibility. Thanks, Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users