Changes 3.10.0:

General improvements:
---------------------
Added support for LIKE, GLOB, and REGEXP operators on virtual tables.
Added the colUsed field to sqlite3_index_info for use by the sqlite3_module.xBestIndex method.
Enhance the PRAGMA cache_spill statement to accept a 32-bit integer parameter which is the threshold below which cache spilling is prohibited.
On unix, if a symlink to a database file is opened, then the corresponding journal files are based on the actual filename, not the symlink name.
Added the "--transaction" option to sqldiff.
Added the sqlite3_db_cacheflush() interface.
Added the sqlite3_strlike() interface.
When using memory-mapped I/O map the database file read-only so that stray pointers and/or array overruns in the application cannot accidently modify the database file.
Added the experimental sqlite3_snapshot_get(), sqlite3_snapshot_open(), and sqlite3_snapshot_free() interfaces. These are subject to change or removal in a subsequent release.
Enhance the 'utc' modifier in the date and time functions so that it is a no-op if the date/time is known to already be in UTC. (This is not a compatibility break since the behavior has long been documented as "undefined" in that case.)
Added the json_group_array() and json_group_object() SQL functions in the json extension.
Added the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.
Many small performance optimizations.

Portability enhancements:
-------------------------
Work around a sign-exension bug in the optimizer of the HP C compiler on HP/UX. (details)

Enhancements to the command-line shell:
---------------------------------------
Added the ".changes ON|OFF" and ".vfsinfo" dot-commands.
Translate between MBCS and UTF8 when running in cmd.exe on Windows.

Enhancements to makefiles:
--------------------------
Added the --enable-editline and --enable-static-shell options to the various autoconf-generated configure scripts.
Omit all use of "awk" in the makefiles, to make building easier for MSVC users.

Important fixes:
----------------
Fix inconsistent integer to floating-point comparison operations that could result in a corrupt index if the index is created on a table column that contains both large integers and floating point values of similar magnitude. Ticket 38a97a87a6.
Fix an infinite-loop in the query planner that could occur on malformed common table expressions.
Various bug fixes in the sqldiff tool.

4 files changed, 28 insertions, 16 deletions

diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile
index 6b973221204..8ab19595e48 100644
--- a/databases/sqlite3/Makefile
+++ b/databases/sqlite3/Makefile
@@ -1,10 +1,8 @@
-# $NetBSD: Makefile,v 1.99 2015/10/15 17:31:32 adam Exp $
+# $NetBSD: Makefile,v 1.100 2016/01/08 14:43:10 adam Exp $
 
 DISTNAME=	sqlite-autoconf-${SQLITE3_DISTVERSION}
 PKGNAME=	sqlite3-${SQLITE3_VERSION}
 CATEGORIES=	databases
-MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2015/ \
-		http://www.sqlite.org/2015/
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
 HOMEPAGE=	http://www.sqlite.org/
diff --git a/databases/sqlite3/Makefile.version b/databases/sqlite3/Makefile.version
index 50adc63e8e7..2e887f75091 100644
--- a/databases/sqlite3/Makefile.version
+++ b/databases/sqlite3/Makefile.version
@@ -1,7 +1,10 @@
-# $NetBSD: Makefile.version,v 1.9 2015/11/04 06:32:25 adam Exp $
+# $NetBSD: Makefile.version,v 1.10 2016/01/08 14:43:10 adam Exp $
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 
-SQLITE3_DISTVERSION=	3090200
-SQLITE3_VERSION=	3.9.2
+SQLITE3_DISTVERSION=	3100000
+SQLITE3_VERSION=	3.10.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 c4019cf9c61..4195683a7da 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.112 2015/11/04 06:32:25 adam Exp $
+$NetBSD: distinfo,v 1.113 2016/01/08 14:43:10 adam Exp $
 
-SHA1 (sqlite-autoconf-3090200.tar.gz) = dae1ae5297fece9671ae0c434a7ecd0cda09c76a
-RMD160 (sqlite-autoconf-3090200.tar.gz) = 6dd6e0779b1cea20141ed4659311461e125b73bf
-SHA512 (sqlite-autoconf-3090200.tar.gz) = c4fdd7dee58e2e4c83091f2a98d8099c6403a66f566be46b54d465c5a58404555fdc1d08050ca60edb6366d220407cfc7409921c123915f78a04cd9930217fa7
-Size (sqlite-autoconf-3090200.tar.gz) = 2284431 bytes
-SHA1 (patch-configure) = 1b9379f8f995456e9e39416123e08c0b4aa6d9b5
+SHA1 (sqlite-autoconf-3100000.tar.gz) = 7be6e6869d0d2d9fe3df71b5c65f065dd2325f58
+RMD160 (sqlite-autoconf-3100000.tar.gz) = a260df17ef61d60701d82d5df44d9186fc34fd4f
+SHA512 (sqlite-autoconf-3100000.tar.gz) = 0d34f511f386e841b60ca6354715e7196c2c3d47e0ae13f09b9ae8d0f95118104b2bd8e13697c4c97b994269c2b2e112841ab74e82a2a64c50243d8ec8d8f46e
+Size (sqlite-autoconf-3100000.tar.gz) = 2331542 bytes
+SHA1 (patch-configure) = 6b6c19d6be2cd61e6502554dc263a1178f9d75c0
diff --git a/databases/sqlite3/patches/patch-configure b/databases/sqlite3/patches/patch-configure
index a07559fb13e..f9dfff481a8 100644
--- a/databases/sqlite3/patches/patch-configure
+++ b/databases/sqlite3/patches/patch-configure
@@ -1,8 +1,10 @@
-$NetBSD: patch-configure,v 1.1 2015/10/15 20:59:18 ryoon Exp $
+$NetBSD: patch-configure,v 1.2 2016/01/08 14:43:10 adam Exp $
 
---- configure.orig	2015-10-14 12:53:34.000000000 +0000
+Portability fixes.
+
+--- configure.orig	2016-01-06 12:03:05.000000000 +0000
 +++ configure
-@@ -12613,7 +12613,7 @@ else
+@@ -13327,7 +13327,7 @@ else
    enable_fts5=no
  fi
  
@@ -11,7 +13,7 @@ $NetBSD: patch-configure,v 1.1 2015/10/15 20:59:18 ryoon Exp $
    { $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 :
-@@ -12685,7 +12685,7 @@ else
+@@ -13399,7 +13399,7 @@ else
    enable_json1=no
  fi
  
@@ -20,3 +22,12 @@ $NetBSD: patch-configure,v 1.1 2015/10/15 20:59:18 ryoon Exp $
    JSON1_FLAGS=-DSQLITE_ENABLE_JSON1
  fi
  
+@@ -13415,7 +13415,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
+ else
+   EXTRA_SHELL_OBJ=libsqlite3.la