Small. Fast. Reliable.
Choose any three.

About Documentation Download License Support Purchase |

## 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.