CVS commit: pkgsrc/databases

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Mar 30 15:55:12 UTC 2017

Modified Files:
        pkgsrc/databases/sqlite3: Makefile.version distinfo
        pkgsrc/databases/sqlite3-docs: distinfo
        pkgsrc/databases/sqlite3-tcl: distinfo

Log Message:
Release 3.18.0:

Added the PRAGMA optimize command
The SQLite version identifier returned by the sqlite_source_id() SQL function and the sqlite3_sourceid() C API and found in the SQLITE_SOURCE_ID macro is now a 64-digit SHA3-256 hash instead of a 
40-digit SHA1 hash.
Added the json_patch() SQL function to the JSON1 extension.
Enhance the LIKE optimization so that it works for arbitrary expressions on the left-hand side as long as the LIKE pattern on the right-hand side does not begin with a digit or minus sign.
Added the sqlite3_set_last_insert_rowid() interface and use the new interface in the FTS3, FTS4, and FTS5 extensions to ensure that the sqlite3_last_insert_rowid() interface always returns reasonable 
values.
Enhance PRAGMA integrity_check and PRAGMA quick_check so that they verify CHECK constraints.
Enhance the query plans for joins to detect empty tables early and halt without doing unnecessary work.
Enhance the sqlite3_mprintf() family of interfaces and the printf SQL function to put comma separators at the thousands marks for integers, if the "," format modifier is used in between the "%" and 
the "d" (example: "%,d").
Added the -DSQLITE_MAX_MEMORY=N compile-time option.
Added the .sha3sum dot-command and the .selftest dot-command to the command-line shell
Begin enforcing SQLITE_LIMIT_VDBE_OP. This can be used, for example, to prevent excessively large prepared statements in systems that accept SQL queries from untrusted users.
Various performance improvements.

Bug Fixes:
----------
Ensure that indexed expressions with collating sequences are handled correctly. Fix for ticket eb703ba7b50c1a5.
Fix a bug in the 'start of ...' modifiers for the date and time functions. Ticket 6097cb92745327a1
Fix a potential segfault in complex recursive triggers, resulting from a bug in the OP_Once opcode introduced as part of a performance optimization in version 3.15.0. Ticket 06796225f59c057c
In the RBU extension, add extra sync operations to avoid the possibility of corruption following a power failure.
The sqlite3_trace_v2() output for nested SQL statements should always begin with a "--" comment marker.


To generate a diff of this commit:
cvs rdiff -u -r1.30 -r1.31 pkgsrc/databases/sqlite3/Makefile.version
cvs rdiff -u -r1.132 -r1.133 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.67 -r1.68 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.80 -r1.81 pkgsrc/databases/sqlite3-tcl/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/sqlite3/Makefile.version
diff -u pkgsrc/databases/sqlite3/Makefile.version:1.30 pkgsrc/databases/sqlite3/Makefile.version:1.31
--- pkgsrc/databases/sqlite3/Makefile.version:1.30      Mon Feb 13 17:44:01 2017
+++ pkgsrc/databases/sqlite3/Makefile.version   Thu Mar 30 15:55:12 2017
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.version,v 1.30 2017/02/13 17:44:01 adam Exp $
+# $NetBSD: Makefile.version,v 1.31 2017/03/30 15:55:12 adam Exp $
 #
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 # used by devel/lemon/Makefile
 
-SQLITE3_DISTVERSION=   3170000
-SQLITE3_VERSION=       3.17.0
+SQLITE3_DISTVERSION=   3180000
+SQLITE3_VERSION=       3.18.0
 
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2017/
 MASTER_SITES+= http://www.sqlite.org/2017/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.132 pkgsrc/databases/sqlite3/distinfo:1.133
--- pkgsrc/databases/sqlite3/distinfo:1.132     Mon Feb 13 17:44:01 2017
+++ pkgsrc/databases/sqlite3/distinfo   Thu Mar 30 15:55:12 2017
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.132 2017/02/13 17:44:01 adam Exp $
+$NetBSD: distinfo,v 1.133 2017/03/30 15:55:12 adam Exp $
 
-SHA1 (sqlite-autoconf-3170000.tar.gz) = 7bcff1c158ed9e2c0e159c1b4b6c36d4d65dff8c
-RMD160 (sqlite-autoconf-3170000.tar.gz) = c198f8c3f91894ba017b7e71a9d6e5c31a9ef12c
-SHA512 (sqlite-autoconf-3170000.tar.gz) = bebf2693ade1c99b6a178bbe663f64911bf7751932a2524506994cbbb19ab254e7febe3693a76084e55853c1ea85db9e4ece87192422583555fbe569915a2ca8
-Size (sqlite-autoconf-3170000.tar.gz) = 2515143 bytes
+SHA1 (sqlite-autoconf-3180000.tar.gz) = 74559194e1dd9b9d577cac001c0e9d370856671b
+RMD160 (sqlite-autoconf-3180000.tar.gz) = dca1a652fa28133f505daba50a021d90891f0ea2
+SHA512 (sqlite-autoconf-3180000.tar.gz) = 4c2efda1d63d1849f7a351cc57c02cc1820efe3c19f88460a131a1d6ae4f7411e4b7672a5581055e581093df29f65cebd9ff5b24125c18802523b17477dce1ef
+Size (sqlite-autoconf-3180000.tar.gz) = 2533004 bytes

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.67 pkgsrc/databases/sqlite3-docs/distinfo:1.68
--- pkgsrc/databases/sqlite3-docs/distinfo:1.67 Mon Feb 13 17:44:01 2017
+++ pkgsrc/databases/sqlite3-docs/distinfo      Thu Mar 30 15:55:12 2017
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.67 2017/02/13 17:44:01 adam Exp $
+$NetBSD: distinfo,v 1.68 2017/03/30 15:55:12 adam Exp $
 
-SHA1 (sqlite-doc-3170000.zip) = bf3b479067d6eb36c8230b668a45994c9212d6cc
-RMD160 (sqlite-doc-3170000.zip) = eb92ad2b22af2bbaa3e76c8e04f475f763057902
-SHA512 (sqlite-doc-3170000.zip) = 6a7813be301416dc59401b7732733f44efad60b458ded0f4ed8d845aab0843a1123dd20d1e6f209dd32184a87bcd7e68e213e3676c43d1d05d2df5acc2c64b74
-Size (sqlite-doc-3170000.zip) = 5533032 bytes
+SHA1 (sqlite-doc-3180000.zip) = 36fac5aa864683d186410c75d2f6e3176beddc7d
+RMD160 (sqlite-doc-3180000.zip) = c45758f9a0d9997eb370599b15e781912a6b1ff9
+SHA512 (sqlite-doc-3180000.zip) = 7b65130cb2174d823842cddc912432d206044a8b276fdc2eef437854de7d0b05b8eb5d7aec0ead5c3f88bb7788ae5f1c42ffb1e43ab00774a68f6f7fea72d517
+Size (sqlite-doc-3180000.zip) = 5552381 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.80 pkgsrc/databases/sqlite3-tcl/distinfo:1.81
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.80  Mon Feb 13 17:44:01 2017
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Thu Mar 30 15:55:12 2017
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.80 2017/02/13 17:44:01 adam Exp $
+$NetBSD: distinfo,v 1.81 2017/03/30 15:55:12 adam Exp $
 
-SHA1 (sqlite-autoconf-3170000.tar.gz) = 7bcff1c158ed9e2c0e159c1b4b6c36d4d65dff8c
-RMD160 (sqlite-autoconf-3170000.tar.gz) = c198f8c3f91894ba017b7e71a9d6e5c31a9ef12c
-SHA512 (sqlite-autoconf-3170000.tar.gz) = bebf2693ade1c99b6a178bbe663f64911bf7751932a2524506994cbbb19ab254e7febe3693a76084e55853c1ea85db9e4ece87192422583555fbe569915a2ca8
-Size (sqlite-autoconf-3170000.tar.gz) = 2515143 bytes
+SHA1 (sqlite-autoconf-3180000.tar.gz) = 74559194e1dd9b9d577cac001c0e9d370856671b
+RMD160 (sqlite-autoconf-3180000.tar.gz) = dca1a652fa28133f505daba50a021d90891f0ea2
+SHA512 (sqlite-autoconf-3180000.tar.gz) = 4c2efda1d63d1849f7a351cc57c02cc1820efe3c19f88460a131a1d6ae4f7411e4b7672a5581055e581093df29f65cebd9ff5b24125c18802523b17477dce1ef
+Size (sqlite-autoconf-3180000.tar.gz) = 2533004 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d