Small. Fast. Reliable.
Choose any three.
SQLite Release 3.7.11 On 2012-03-20
- Enhance the INSERT syntax to allow multiple rows to be inserted
via the VALUES clause.
- Enhance the CREATE VIRTUAL TABLE command to support the
IF NOT EXISTS clause.
- Added the sqlite3_stricmp() interface as a counterpart to
sqlite3_strnicmp().
- Added the sqlite3_db_readonly() interface.
- Added the SQLITE_FCNTL_PRAGMA file control, giving VFS implementations
the ability to add new PRAGMA statements or to override built-in
PRAGMAs.
- Queries of the form: "SELECT max(x), y FROM table" returns the
value of y on the same row that contains the maximum x value.
- Added support for the FTS4 languageid option.
- Documented support for the FTS4 content option. This feature has
actually been in the code since version 3.7.9 but is only now considered
to be officially supported.
- Pending statements no longer block ROLLBACK. Instead, the pending
statement will return SQLITE_ABORT upon next access after the ROLLBACK.
- Improvements to the handling of CSV inputs in the command-line shell
- Fix a bug introduced
in version 3.7.10 that might cause a LEFT JOIN
to be incorrectly converted into an INNER JOIN if the WHERE clause
indexable terms connected by OR.
- SQLITE_SOURCE_ID:
"2012-03-20 11:35:50 00bb9c9ce4f465e6ac321ced2a9d0062dc364669"
- SHA1 for sqlite3.c: d460d7eda3a9dccd291aed2a9fda868b9b120a10
A complete list of SQLite releases
in a single page and a chronology are both also available.
A detailed history of every
check-in is available at
SQLite version control site.