Release 3.12.0

Potentially Disruptive Change:
------------------------------
The SQLITE_DEFAULT_PAGE_SIZE is increased from 1024 to 4096. The SQLITE_DEFAULT_CACHE_SIZE is changed from 2000 to -2000 so the same amount of cache memory is used by default. See the application note on the version 3.12.0 page size change for further information.

Performance enhancements:
-------------------------
Enhancements to the Lemon parser generator so that it creates a smaller and faster SQL parser.
Only create master journal files if two or more attached databases are all modified, do not have PRAGMA synchronous set to OFF, and do not have the journal_mode set to OFF, MEMORY, or WAL.
Only create statement journal files when their size exceeds a threshold. Otherwise the journal is held in memory and no I/O occurs. The threshold can be configured at compile-time using SQLITE_STMTJRNL_SPILL or at start-time using sqlite3_config(SQLITE_CONFIG_STMTJRNL_SPILL).
The query planner is able to optimize IN operators on virtual tables even if the xBestIndex method does not set the sqlite3_index_constraint_usage.omit flag of the virtual table column to the left of the IN operator.
The query planner now does a better job of optimizing virtual table accesses in a 3-way or higher join where constraints on the virtual table are split across two or more other tables of the join.
More efficient handling of application-defined SQL functions, especially in cases where the application defines hundreds or thousands of custom functions.
The query planner considers the LIMIT clause when estimating the cost of ORDER BY.
The configure script (on unix) automatically detects pread() and pwrite() and sets compile-time options to use those OS interfaces if they are available.
Reduce the amount of memory needed to hold the schema.
Other miscellaneous micro-optimizations for improved performance and reduced memory usage.

New Features:
-------------
Added the SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to sqlite3_db_config() which allows the two-argument version of the fts3_tokenizer() SQL function to be enabled or disabled at run-time.
Added the sqlite3rbu_bp_progress() interface to the RBU extension.
The PRAGMA defer_foreign_keys=ON statement now also disables RESTRICT actions on foreign key.
Added the sqlite3_system_errno() interface.
Added the SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS compile-time options. The SQLITE_DEFAULT_SYNCHRONOUS compile-time option replaces the SQLITE_EXTRA_DURABLE option, which is no longer supported.
Enhanced the ".stats" command in the command-line shell to show more information about I/O performance obtained from /proc, when available.

Bug fixes:
----------
Make sure the sqlite3_set_auxdata() values from multiple triggers within a single statement do not interfere with one another.
Fix the code generator for expressions of the form "x IN (SELECT...)" where the SELECT statement on the RHS is a correlated subquery.
Fix a harmless TSAN warning associated with the sqlite3_db_readonly() interface.

7 files changed, 29 insertions, 60 deletions

diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index fdc72ed6776..f31f1ce3f33 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.52 2016/03/06 09:57:51 adam Exp $
+@comment $NetBSD: PLIST,v 1.53 2016/04/08 07:54:27 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -163,6 +163,7 @@ share/doc/sqlite3/c3ref/stmt_status.html
 share/doc/sqlite3/c3ref/strglob.html
 share/doc/sqlite3/c3ref/stricmp.html
 share/doc/sqlite3/c3ref/strlike.html
+share/doc/sqlite3/c3ref/system_errno.html
 share/doc/sqlite3/c3ref/table_column_metadata.html
 share/doc/sqlite3/c3ref/temp_directory.html
 share/doc/sqlite3/c3ref/test_control.html
@@ -520,6 +521,7 @@ share/doc/sqlite3/onefile.html
 share/doc/sqlite3/opcode.html
 share/doc/sqlite3/optoverview.html
 share/doc/sqlite3/partialindex.html
+share/doc/sqlite3/pgszchng2016.html
 share/doc/sqlite3/pragma.html
 share/doc/sqlite3/pressrelease-20071212.html
 share/doc/sqlite3/privatebranch.html
@@ -542,6 +544,7 @@ share/doc/sqlite3/releaselog/3_10_1.html
 share/doc/sqlite3/releaselog/3_10_2.html
 share/doc/sqlite3/releaselog/3_11_0.html
 share/doc/sqlite3/releaselog/3_11_1.html
+share/doc/sqlite3/releaselog/3_12_0.html
 share/doc/sqlite3/releaselog/3_1_0.html
 share/doc/sqlite3/releaselog/3_1_1.html
 share/doc/sqlite3/releaselog/3_1_2.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 2d0d8000d35..7022488b268 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.53 2016/03/06 09:57:51 adam Exp $
+$NetBSD: distinfo,v 1.54 2016/04/08 07:54:27 adam Exp $
 
-SHA1 (sqlite-doc-3110100.zip) = 79a24f86bbfc77371fb528ac396d3ad1c266ffa4
-RMD160 (sqlite-doc-3110100.zip) = 52c43905047bf1361c480ba374300e94aca2b2a4
-SHA512 (sqlite-doc-3110100.zip) = b8fe71a852ce2fa3d7da27c09e3a1e8d019a9c55eb7e5516425754148f8d8a6cc88571d006768d5fd5b2c72aa513544bfc0ce4208f376099f8f08b7fee480d06
-Size (sqlite-doc-3110100.zip) = 5386958 bytes
+SHA1 (sqlite-doc-3120000.zip) = fbca5a4db72c1f50d949f9f5df96d9f905559230
+RMD160 (sqlite-doc-3120000.zip) = cdbe7f16fad09037cd7bef4fc4e63bad8f76535d
+SHA512 (sqlite-doc-3120000.zip) = 7879d006e528d692ea5718f27d03e2dfe2a5e54aa135be983b992836102720df4dc690d84795115a25ed19a663e895a3f3f8a59d0de079c451d215e07081281e
+Size (sqlite-doc-3120000.zip) = 5402611 bytes
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 466648af0ab..d3ecaaea353 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.66 2016/03/06 09:57:51 adam Exp $
+$NetBSD: distinfo,v 1.67 2016/04/08 07:54:27 adam Exp $
 
-SHA1 (sqlite-autoconf-3110100.tar.gz) = c4b4dcd735a4daf5a2e2bb90f374484c8d4dad29
-RMD160 (sqlite-autoconf-3110100.tar.gz) = 34af4aa0dbb1635752a6093034c87a7467647fc9
-SHA512 (sqlite-autoconf-3110100.tar.gz) = c3efd2693e6a9526a2901d9879982a421e81e7e979aef65a160e71b255339344079a1943395480d5c37a1acc6243a8d45f45fa688f7e996774da38a3a99e71a1
-Size (sqlite-autoconf-3110100.tar.gz) = 2359545 bytes
+SHA1 (sqlite-autoconf-3120000.tar.gz) = e3269662b13ce5cd93b08bd33899bd1cbde3b072
+RMD160 (sqlite-autoconf-3120000.tar.gz) = 328938dcd9bf8b64712a6597a9967cebf5059765
+SHA512 (sqlite-autoconf-3120000.tar.gz) = 84a9107ca9045ddc724d7e37dfe2b1dc00a106769260c7bd429a95beedc46a906985b65e0b2bf597de23dd56d132b9ef6888a8c4e5f8a731c8a5c026b971d89e
+Size (sqlite-autoconf-3120000.tar.gz) = 2374101 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d
diff --git a/databases/sqlite3/Makefile.version b/databases/sqlite3/Makefile.version
index 5af76dcbad9..39d853fec38 100644
--- a/databases/sqlite3/Makefile.version
+++ b/databases/sqlite3/Makefile.version
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile.version,v 1.14 2016/03/06 09:57:51 adam Exp $
+# $NetBSD: Makefile.version,v 1.15 2016/04/08 07:54:27 adam Exp $
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 
-SQLITE3_DISTVERSION=	3110100
-SQLITE3_VERSION=	3.11.1
+SQLITE3_DISTVERSION=	3120000
+SQLITE3_VERSION=	3.12.0
 
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2016/ \
 		http://www.sqlite.org/2016/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index 2ededd9c221..622b050ec21 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,8 +1,7 @@
-$NetBSD: distinfo,v 1.118 2016/03/06 12:12:00 adam Exp $
+$NetBSD: distinfo,v 1.119 2016/04/08 07:54:27 adam Exp $
 
-SHA1 (sqlite-autoconf-3110100.tar.gz) = c4b4dcd735a4daf5a2e2bb90f374484c8d4dad29
-RMD160 (sqlite-autoconf-3110100.tar.gz) = 34af4aa0dbb1635752a6093034c87a7467647fc9
-SHA512 (sqlite-autoconf-3110100.tar.gz) = c3efd2693e6a9526a2901d9879982a421e81e7e979aef65a160e71b255339344079a1943395480d5c37a1acc6243a8d45f45fa688f7e996774da38a3a99e71a1
-Size (sqlite-autoconf-3110100.tar.gz) = 2359545 bytes
-SHA1 (patch-Makefile.in) = 8966794bad2be8bb56af6f743569c454713abf3d
-SHA1 (patch-configure) = 6b6c19d6be2cd61e6502554dc263a1178f9d75c0
+SHA1 (sqlite-autoconf-3120000.tar.gz) = e3269662b13ce5cd93b08bd33899bd1cbde3b072
+RMD160 (sqlite-autoconf-3120000.tar.gz) = 328938dcd9bf8b64712a6597a9967cebf5059765
+SHA512 (sqlite-autoconf-3120000.tar.gz) = 84a9107ca9045ddc724d7e37dfe2b1dc00a106769260c7bd429a95beedc46a906985b65e0b2bf597de23dd56d132b9ef6888a8c4e5f8a731c8a5c026b971d89e
+Size (sqlite-autoconf-3120000.tar.gz) = 2374101 bytes
+SHA1 (patch-configure) = 833f6b824f03b3f12f51617fa2fc7b9d4a580b35
diff --git a/databases/sqlite3/patches/patch-Makefile.in b/databases/sqlite3/patches/patch-Makefile.in
deleted file mode 100644
index c2ec6b82b80..00000000000
--- a/databases/sqlite3/patches/patch-Makefile.in
+++ /dev/null
@@ -1,33 +0,0 @@
-$NetBSD: patch-Makefile.in,v 1.1 2016/03/06 12:12:00 adam Exp $
-
-Fix for dynamically linked shell tool.
-
---- Makefile.in.orig	2016-03-03 16:37:17.000000000 +0000
-+++ Makefile.in
-@@ -146,7 +146,7 @@ libsqlite3_la_LINK = $(LIBTOOL) $(AM_V_l
- 	$(LIBTOOLFLAGS) --mode=link $(CCLD) $(AM_CFLAGS) $(CFLAGS) \
- 	$(libsqlite3_la_LDFLAGS) $(LDFLAGS) -o $@
- PROGRAMS = $(bin_PROGRAMS)
--am_sqlite3_OBJECTS = sqlite3-shell.$(OBJEXT) sqlite3-sqlite3.$(OBJEXT)
-+am_sqlite3_OBJECTS = sqlite3-shell.$(OBJEXT)
- sqlite3_OBJECTS = $(am_sqlite3_OBJECTS)
- sqlite3_LINK = $(LIBTOOL) $(AM_V_lt) --tag=CC $(AM_LIBTOOLFLAGS) \
- 	$(LIBTOOLFLAGS) --mode=link $(CCLD) $(sqlite3_CFLAGS) \
-@@ -364,7 +364,7 @@ AM_CFLAGS = @THREADSAFE_FLAGS@ @DYNAMIC_
- lib_LTLIBRARIES = libsqlite3.la
- libsqlite3_la_SOURCES = sqlite3.c
- libsqlite3_la_LDFLAGS = -no-undefined -version-info 8:6:8
--sqlite3_SOURCES = shell.c sqlite3.c sqlite3.h
-+sqlite3_SOURCES = shell.c sqlite3.h
- sqlite3_LDADD = @READLINE_LIBS@
- sqlite3_DEPENDENCIES = @EXTRA_SHELL_OBJ@
- sqlite3_CFLAGS = $(AM_CFLAGS) -DSQLITE_ENABLE_EXPLAIN_COMMENTS
-@@ -502,7 +502,7 @@ clean-binPROGRAMS:
- 
- sqlite3$(EXEEXT): $(sqlite3_OBJECTS) $(sqlite3_DEPENDENCIES) $(EXTRA_sqlite3_DEPENDENCIES) 
- 	@rm -f sqlite3$(EXEEXT)
--	$(AM_V_CCLD)$(sqlite3_LINK) $(sqlite3_OBJECTS) $(sqlite3_LDADD) $(LIBS)
-+	$(AM_V_CCLD)$(sqlite3_LINK) $(sqlite3_OBJECTS) $(sqlite3_DEPENDENCIES) $(sqlite3_LDADD) $(LIBS)
- 
- mostlyclean-compile:
- 	-rm -f *.$(OBJEXT)
diff --git a/databases/sqlite3/patches/patch-configure b/databases/sqlite3/patches/patch-configure
index f9dfff481a8..c556e6940c0 100644
--- a/databases/sqlite3/patches/patch-configure
+++ b/databases/sqlite3/patches/patch-configure
@@ -1,10 +1,10 @@
-$NetBSD: patch-configure,v 1.2 2016/01/08 14:43:10 adam Exp $
+$NetBSD: patch-configure,v 1.3 2016/04/08 07:54:27 adam Exp $
 
 Portability fixes.
 
---- configure.orig	2016-01-06 12:03:05.000000000 +0000
+--- configure.orig	2016-03-29 10:47:30.000000000 +0000
 +++ configure
-@@ -13327,7 +13327,7 @@ else
+@@ -13385,7 +13385,7 @@ else
    enable_fts5=no
  fi
  
@@ -13,7 +13,7 @@ Portability fixes.
    { $as_echo "$as_me:${as_lineno-$LINENO}: checking for library containing log" >&5
  $as_echo_n "checking for library containing log... " >&6; }
  if ${ac_cv_search_log+:} false; then :
-@@ -13399,7 +13399,7 @@ else
+@@ -13457,7 +13457,7 @@ else
    enable_json1=no
  fi
  
@@ -22,12 +22,12 @@ Portability fixes.
    JSON1_FLAGS=-DSQLITE_ENABLE_JSON1
  fi
  
-@@ -13415,7 +13415,7 @@ else
+@@ -13473,7 +13473,7 @@ else
    enable_static_shell=yes
  fi
  
 -if test x"$enable_static_shell" == "xyes"; then
 +if test x"$enable_static_shell" = "xyes"; then
-   EXTRA_SHELL_OBJ=sqlite3.$OBJEXT
+   EXTRA_SHELL_OBJ=sqlite3-sqlite3.$OBJEXT
  else
    EXTRA_SHELL_OBJ=libsqlite3.la