/ Check-in [31942b3d]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | read-only-shadow
Files: files | file ages | folders
SHA3-256: 31942b3dd3f66eb0d9977bf1cadc2f2d7be7967cce2b55784be0b939dfef1985
User & Date: drh 2018-11-05 23:01:45
Context
2018-11-06
13:37
Add enforcement of read-only on shadow tables. This does not currently work since some virtual tables are attempting to update shadow tables using sqlite3_exec(). check-in: f79b47c9 user: drh tags: read-only-shadow
2018-11-05
23:01
Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. check-in: 31942b3d user: drh tags: read-only-shadow
19:37
Add the SQLITE_DBCONFIG_DEFENSIVE flag. check-in: 11d98414 user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to ext/expert/sqlite3expert.c.

Changes to ext/fts3/fts3.c.

Changes to ext/fts3/fts3_aux.c.

Changes to ext/fts3/fts3_term.c.

Changes to ext/fts3/fts3_tokenize_vtab.c.

Changes to ext/fts3/fts3_write.c.

Changes to ext/fts5/fts5_index.c.

Changes to ext/fts5/fts5_main.c.

Changes to ext/fts5/fts5_storage.c.

Changes to ext/fts5/fts5_test_tok.c.

Changes to ext/fts5/fts5_vocab.c.

Changes to ext/misc/amatch.c.

Changes to ext/misc/btreeinfo.c.

Changes to ext/misc/closure.c.

Changes to ext/misc/completion.c.

Changes to ext/misc/explain.c.

Changes to ext/misc/fileio.c.

Changes to ext/misc/json1.c.

Changes to ext/misc/memstat.c.

Changes to ext/misc/stmt.c.

Changes to ext/misc/templatevtab.c.

Changes to ext/misc/unionvtab.c.

Changes to ext/misc/vtablog.c.

Changes to ext/rtree/geopoly.c.

Changes to ext/rtree/rtree.c.

Changes to src/build.c.

Changes to src/dbpage.c.

Changes to src/dbstat.c.

Changes to src/pragma.c.

Changes to src/sqlite.h.in.

Changes to src/sqliteInt.h.