SQLite Release 3.7.11 On 2012-03-20

SQLite Release 3.7.11 On 2012-03-20#

1. Enhance the INSERT syntax to allow multiple rows to be inserted via the VALUES clause.
2. Enhance the CREATE VIRTUAL TABLE command to support the IF NOT EXISTS clause.
3. Added the sqlite3_stricmp() interface as a counterpart to sqlite3_strnicmp().
4. Added the sqlite3_db_readonly() interface.
5. Added the SQLITE_FCNTL_PRAGMA file control, giving VFS implementations the ability to add new PRAGMA statements or to override built-in PRAGMAs.
6. 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.
7. Added support for the FTS4 languageid option.
8. 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.
9. Pending statements no longer block ROLLBACK. Instead, the pending statement will return SQLITE_ABORT upon next access after the ROLLBACK.
10. Improvements to the handling of CSV inputs in the command-line shell
11. 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.
12. SQLITE_SOURCE_ID: "2012-03-20 11:35:50 00bb9c9ce4f465e6ac321ced2a9d0062dc364669"
13. 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.