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 is also available. A detailed history of every check-in is available at http://www.sqlite.org/src/timeline.