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.

3 files changed, 16 insertions, 9 deletions

diff --git a/databases/sqlite3-docs/Makefile b/databases/sqlite3-docs/Makefile
index 27ef6c44544..5e10be964ce 100644
--- a/databases/sqlite3-docs/Makefile
+++ b/databases/sqlite3-docs/Makefile
@@ -1,10 +1,8 @@
-# $NetBSD: Makefile,v 1.42 2015/04/21 23:26:42 khorben Exp $
+# $NetBSD: Makefile,v 1.43 2016/01/08 14:43:10 adam Exp $
 
 DISTNAME=	sqlite-doc-${SQLITE3_DISTVERSION}
 PKGNAME=	sqlite3-docs-${SQLITE3_VERSION}
 CATEGORIES=	databases
-MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2015/ \
-		http://www.sqlite.org/2015/
 EXTRACT_SUFX=	.zip
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 6eb17ad3637..26bcea01a8f 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.47 2015/11/04 06:32:25 adam Exp $
+@comment $NetBSD: PLIST,v 1.48 2016/01/08 14:43:10 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -84,6 +84,7 @@ share/doc/sqlite3/c3ref/create_function.html
 share/doc/sqlite3/c3ref/create_module.html
 share/doc/sqlite3/c3ref/data_count.html
 share/doc/sqlite3/c3ref/data_directory.html
+share/doc/sqlite3/c3ref/db_cacheflush.html
 share/doc/sqlite3/c3ref/db_config.html
 share/doc/sqlite3/c3ref/db_filename.html
 share/doc/sqlite3/c3ref/db_handle.html
@@ -143,6 +144,10 @@ 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/snapshot.html
+share/doc/sqlite3/c3ref/snapshot_free.html
+share/doc/sqlite3/c3ref/snapshot_get.html
+share/doc/sqlite3/c3ref/snapshot_open.html
 share/doc/sqlite3/c3ref/soft_heap_limit.html
 share/doc/sqlite3/c3ref/soft_heap_limit64.html
 share/doc/sqlite3/c3ref/sql.html
@@ -157,6 +162,7 @@ share/doc/sqlite3/c3ref/stmt_scanstatus_reset.html
 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/table_column_metadata.html
 share/doc/sqlite3/c3ref/temp_directory.html
 share/doc/sqlite3/c3ref/test_control.html
@@ -316,6 +322,7 @@ 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/fb.gif
 share/doc/sqlite3/images/foreignlogos/firefox.gif
 share/doc/sqlite3/images/foreignlogos/flame.gif
 share/doc/sqlite3/images/foreignlogos/ge.gif
@@ -332,6 +339,7 @@ share/doc/sqlite3/images/foreignlogos/philips.gif
 share/doc/sqlite3/images/foreignlogos/php.gif
 share/doc/sqlite3/images/foreignlogos/python.gif
 share/doc/sqlite3/images/foreignlogos/realbasic.gif
+share/doc/sqlite3/images/foreignlogos/rpm_logo.png
 share/doc/sqlite3/images/foreignlogos/skype.gif
 share/doc/sqlite3/images/foreignlogos/sony.gif
 share/doc/sqlite3/images/foreignlogos/sunmicro.gif
@@ -529,6 +537,7 @@ share/doc/sqlite3/releaselog/3_0_5.html
 share/doc/sqlite3/releaselog/3_0_6.html
 share/doc/sqlite3/releaselog/3_0_7.html
 share/doc/sqlite3/releaselog/3_0_8.html
+share/doc/sqlite3/releaselog/3_10_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 501228a16b0..75aa78e00a9 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.48 2015/11/04 06:32:25 adam Exp $
+$NetBSD: distinfo,v 1.49 2016/01/08 14:43:10 adam Exp $
 
-SHA1 (sqlite-doc-3090200.zip) = 31a2e8a845e24968ede785ec09e057514c3538fd
-RMD160 (sqlite-doc-3090200.zip) = c88bf1d9787fb32beabe98b7a171799e9221a50c
-SHA512 (sqlite-doc-3090200.zip) = aef3b340613eed376dca491fd25b98ced30b69454b24412cb094854c53496bddfb479293634b46f1c793377981d4094c38a6b9c3e67775b471407c4d8cc21435
-Size (sqlite-doc-3090200.zip) = 5295693 bytes
+SHA1 (sqlite-doc-3100000.zip) = 8bb827722301c485ac0526e20c015f1b76f32542
+RMD160 (sqlite-doc-3100000.zip) = 10f7484e25ef801570d8d7db735d9c51c5d2bf37
+SHA512 (sqlite-doc-3100000.zip) = b04846e180d71c0bd3f76399f68df352ba663939a141fb1368f0099cfefb22e290ce1f5cf69eeb63a9136097c463ff9446670629f5b0662e5a230691c36e20c8
+Size (sqlite-doc-3100000.zip) = 5350213 bytes