Changes 3.9.0:

Policy Changes:
* The version numbering conventions for SQLite are revised to use the emerging standard of semantic versioning.

New Features And Enhancements:
* Added the json1 extension module in the source tree, and in the amalgamation. Enable support using the SQLITE_ENABLE_JSON1 compile-time option.
* Added Full Text Search version 5 (FTS5) to the amalgamation, enabled using SQLITE_ENABLE_FTS5. FTS5 will be considered "experimental" (subject to incompatible changes) for at least one more release cycle.
* The CREATE VIEW statement now accepts an optional list of column names following the view name.
* Added support for indexes on expressions.
* Added support for table-valued functions in the FROM clause of a SELECT statement.
* Added support for eponymous virtual tables.
* A VIEW may now reference undefined tables and functions when initially created. Missing tables and functions are reported when the VIEW is used in a query.
* Added the sqlite3_value_subtype() and sqlite3_result_subtype() interfaced (used by the json1 extension).
* The query planner is now able to use partial indexes that contain AND-connected terms in the WHERE clause.
* The sqlite3_analyzer.exe utility is updated to report the depth of each btree and to show the average fanout for indexes and WITHOUT ROWID tables.
* Enhanced the dbstat virtual table so that it can be used as a table-valued function where the argument is the schema to be analyzed.

Other changes:
* The sqlite3_memory_alarm() interface, which has been deprecated and undocumented for 8 years, is changed into a no-op.

Important fixes:
* Fixed a critical bug in the SQLite Encryption Extension that could cause the database to become unreadable and unrecoverable if a VACUUM command changed the size of the encryption nonce.
* Added a memory barrier in the implementation of sqlite3_initialize() to help ensure that it is thread-safe.
* Fix the OR optimization so that it always ignores subplans that do not use an index.
* Do not apply the WHERE-clause pushdown optimization on terms that originate in the ON or USING clause of a LEFT JOIN.

1 files changed, 12 insertions, 1 deletions

diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 9c21abfc18f..a13be9e27c2 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.44 2015/07/30 12:37:04 adam Exp $
+@comment $NetBSD: PLIST,v 1.45 2015/10/15 17:31:32 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -46,6 +46,7 @@ share/doc/sqlite3/c3ref/c_deterministic.html
 share/doc/sqlite3/c3ref/c_fail.html
 share/doc/sqlite3/c3ref/c_fcntl_busyhandler.html
 share/doc/sqlite3/c3ref/c_index_constraint_eq.html
+share/doc/sqlite3/c3ref/c_index_scan_unique.html
 share/doc/sqlite3/c3ref/c_iocap_atomic.html
 share/doc/sqlite3/c3ref/c_limit_attached.html
 share/doc/sqlite3/c3ref/c_lock_exclusive.html
@@ -139,6 +140,7 @@ share/doc/sqlite3/c3ref/release_memory.html
 share/doc/sqlite3/c3ref/reset.html
 share/doc/sqlite3/c3ref/reset_auto_extension.html
 share/doc/sqlite3/c3ref/result_blob.html
+share/doc/sqlite3/c3ref/result_subtype.html
 share/doc/sqlite3/c3ref/set_authorizer.html
 share/doc/sqlite3/c3ref/sleep.html
 share/doc/sqlite3/c3ref/soft_heap_limit.html
@@ -167,6 +169,7 @@ share/doc/sqlite3/c3ref/user_data.html
 share/doc/sqlite3/c3ref/value.html
 share/doc/sqlite3/c3ref/value_blob.html
 share/doc/sqlite3/c3ref/value_dup.html
+share/doc/sqlite3/c3ref/value_subtype.html
 share/doc/sqlite3/c3ref/vfs.html
 share/doc/sqlite3/c3ref/vfs_find.html
 share/doc/sqlite3/c3ref/vtab.html
@@ -181,6 +184,7 @@ share/doc/sqlite3/c_interface.html
 share/doc/sqlite3/capi3.html
 share/doc/sqlite3/capi3ref.html
 share/doc/sqlite3/changes.html
+share/doc/sqlite3/chronology.html
 share/doc/sqlite3/cintro.html
 share/doc/sqlite3/cli.html
 share/doc/sqlite3/compile.html
@@ -207,6 +211,7 @@ share/doc/sqlite3/docs.html
 share/doc/sqlite3/download.html
 share/doc/sqlite3/eqp.html
 share/doc/sqlite3/errlog.html
+share/doc/sqlite3/expridx.html
 share/doc/sqlite3/famous.html
 share/doc/sqlite3/faq.html
 share/doc/sqlite3/favicon.ico
@@ -310,6 +315,7 @@ share/doc/sqlite3/images/foreignlogos/bentley.jpg
 share/doc/sqlite3/images/foreignlogos/bloomberg.gif
 share/doc/sqlite3/images/foreignlogos/bosch_logo1.gif
 share/doc/sqlite3/images/foreignlogos/dropbox.gif
+share/doc/sqlite3/images/foreignlogos/expensify.png
 share/doc/sqlite3/images/foreignlogos/firefox.gif
 share/doc/sqlite3/images/foreignlogos/flame.gif
 share/doc/sqlite3/images/foreignlogos/ge.gif
@@ -319,6 +325,7 @@ share/doc/sqlite3/images/foreignlogos/mcaffee.gif
 share/doc/sqlite3/images/foreignlogos/microsoft.gif
 share/doc/sqlite3/images/foreignlogos/monotone.gif
 share/doc/sqlite3/images/foreignlogos/mozilla.gif
+share/doc/sqlite3/images/foreignlogos/nds.png
 share/doc/sqlite3/images/foreignlogos/nokia.gif
 share/doc/sqlite3/images/foreignlogos/oracle.gif
 share/doc/sqlite3/images/foreignlogos/philips.gif
@@ -453,6 +460,7 @@ share/doc/sqlite3/index.html
 share/doc/sqlite3/inmemorydb.html
 share/doc/sqlite3/intern-v-extern-blob.html
 share/doc/sqlite3/isolation.html
+share/doc/sqlite3/json1.html
 share/doc/sqlite3/keyword_index.html
 share/doc/sqlite3/lang.html
 share/doc/sqlite3/lang_aggfunc.html
@@ -655,6 +663,7 @@ share/doc/sqlite3/releaselog/3_8_8_1.html
 share/doc/sqlite3/releaselog/3_8_8_2.html
 share/doc/sqlite3/releaselog/3_8_8_3.html
 share/doc/sqlite3/releaselog/3_8_9.html
+share/doc/sqlite3/releaselog/3_9_0.html
 share/doc/sqlite3/releaselog/current.html
 share/doc/sqlite3/requirements.html
 share/doc/sqlite3/rescode.html
@@ -743,10 +752,12 @@ share/doc/sqlite3/th3.html
 share/doc/sqlite3/threadsafe.html
 share/doc/sqlite3/toc.db
 share/doc/sqlite3/transactional.html
+share/doc/sqlite3/undoredo.html
 share/doc/sqlite3/unlock_notify.html
 share/doc/sqlite3/uri.html
 share/doc/sqlite3/vdbe.html
 share/doc/sqlite3/version3.html
+share/doc/sqlite3/versionnumbers.html
 share/doc/sqlite3/vfs.html
 share/doc/sqlite3/vtab.html
 share/doc/sqlite3/wal.html