mORMot Open Source

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,220

Website

Updated SQLite3 engine to version 3.7.5

The SQLite3 engine has been updated to the latest version 3.7.5.

SQLite Release 3.7.5 On 2011 February 01 (3.7.5)

Changes associated with this release include the following:

- Added the sqlite3_vsnprintf() interface.
- Added the SQLITE_DBSTATUS_LOOKASIDE_HIT, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE, and SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL options for the sqlite3_db_status() interface.
- Added the SQLITE_OMIT_AUTORESET compile-time option.
- Added the SQLITE_DEFAULT_FOREIGN_KEYS compile-time option.
- Updates to sqlite3_stmt_readonly() so that its result is well-defined for all prepared statements and so that it works with VACUUM.
- Added the "-heap" option to the command-line shell
- Fix a bug involving frequent changes in and out of WAL mode and VACUUM that could (in theory) cause database corruption.
- Enhance the sqlite3_trace() mechanism so that nested SQL statements such as might be generated by virtual tables are shown but are shown in comments and without parameter expansion. This greatly improves tracing output when using the FTS3/4 and/or RTREE virtual tables.
- Change the xFileControl() methods on all built-in VFSes to return SQLITE_NOTFOUND instead of SQLITE_ERROR for an unrecognized operation code.
- The SQLite core invokes the SQLITE_FCNTL_SYNC_OMITTED file control to the VFS in place of a call to xSync if the database has PRAGMA synchronous set to OFF.

For our framework, there is no direct enhancements.

I could add sqlite3_stmt_readonly() function if you need it (but the framework is parsing the SQL source for a SELECT/VACUUM read-only commands).

All regression tests passed with this new engine.

See http://synopse.info/fossil/info/e9cafa3892