id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
7476	sqlite-autoconf-3110000 (3.11.0)	Fernando de Oliveira	ken@…	"[https://www.sqlite.org/2016/sqlite-autoconf-3110000.tar.gz]

[https://www.sqlite.org/2016/sqlite-doc-3110000.zip]

[https://www.sqlite.org/download.html]

sqlite-autoconf-3110000.tar.gz (sha1: e2d300e4b24af5ecd67a1396488893fa44864e36)

sqlite-doc-3110000.zip         (sha1: 9b58a0a48508103352144afee2e47469e74427ba)

[http://permalink.gmane.org/gmane.comp.db.sqlite.announce/56]

{{{
 D. Richard Hipp | 15 Feb 21:25 2016
Version 3.11.0

SQLite version 3.11.0 is now available

This is a regularly schedule maintenance release.  There are a few
obscure bug fixes, some new features, and various performance
improvements.  See the change log for details.


--
D. Richard Hipp
drh <at> sqlite.org

}}}

[https://www.sqlite.org/changes.html]

or

[https://www.sqlite.org/releaselog/3_11_0.html]

{{{
SQLite Release 3.11.0 On 2016-02-15

    General improvements:

  • Enhanced WAL mode so that it works efficiently with transactions
    that are larger than the cache_size.
  • Added the FTS5 detail option.
  • Added the ""EXTRA"" option to PRAGMA synchronous that does a sync of
    the containing directory when a rollback journal is unlinked in
    DELETE mode, for better durability. The SQLITE_EXTRA_DURABLE
    compile-time option enables PRAGMA synchronous=EXTRA by default.
  • Enhanced the query planner so that it is able to use a covering
    index as part of the OR optimization.
  • Avoid recomputing NOT NULL and CHECK constraints on unchanged
    columns in UPDATE statement.
  • Many micro-optimizations, resulting in a library that is faster than
    the previous release.

    Enhancements to the command-line shell:

  • By default, the shell is now in ""auto-explain"" mode. The output of
    EXPLAIN commands is automatically formatted.
  • Added the "".vfslist"" dot-command.
  • The SQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option is now turned
    on by default in the standard builds.

    Enhancements to the TCL Interface:

  • If a database connection is opened with the ""-uri 1"" option, then
    URI filenames are honored by the ""backup"" and ""restore"" commands.
  • Added the ""-sourceid"" option to the ""sqlite3"" command.

    Makefile improvements:

  • Improved pthreads detection in configure scripts.
  • Add the ability to do MSVC Windows builds from the amalgamation
    tarball.

    Bug fixes

  • Fix an issue with incorrect sharing of VDBE temporary registers
    between co-routines that could cause incorrect query results in
    obscure cases. Ticket d06a25c84454a.
  • Fix a problem in the sqlite3_result_subtype() interface that could
    cause problems for the json1 extension under obscure circumstances.
    Fix for ticket f45ac567eaa9f9.
  • Escape control characters in JSON strings. Fix for ticket
    ad2559db380abf8.
  • Reenable the xCurrentTime and xGetLastError methods in the built-in
    unix VFSes as long as SQLITE_OMIT_DEPRECATED is not defined.

    Backwards Compatibility:

  • Because of continuing security concerns, the two-argument version of
    of the seldom-used and little-known fts3_tokenizer() function is
    disabled unless SQLite is compiled with the
    SQLITE_ENABLE_FTS3_TOKENIZER.   
 
...
}}}"	enhancement	closed	normal	7.9	BOOK	SVN	medium	fixed