Received: by mail.netbsd.org (Postfix, from userid 605) id 0ED3E84DBC; Mon, 11 Feb 2019 10:45:23 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id 8926D84DB2 for ; Mon, 11 Feb 2019 10:45:22 +0000 (UTC) X-Virus-Scanned: amavisd-new at netbsd.org Received: from mail.netbsd.org ([IPv6:::1]) by localhost (mail.netbsd.org [IPv6:::1]) (amavisd-new, port 10025) with ESMTP id 4txdf-KKV49a for ; Mon, 11 Feb 2019 10:45:21 +0000 (UTC) Received: from cvs.NetBSD.org (ivanova.netbsd.org [199.233.217.197]) by mail.netbsd.org (Postfix) with ESMTP id 7B5B084CD4 for ; Mon, 11 Feb 2019 10:45:21 +0000 (UTC) Received: by cvs.NetBSD.org (Postfix, from userid 500) id 73384FB16; Mon, 11 Feb 2019 10:45:21 +0000 (UTC) Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_1549881921282410" MIME-Version: 1.0 Date: Mon, 11 Feb 2019 10:45:21 +0000 From: "Adam Ciarcinski" Subject: CVS commit: pkgsrc To: pkgsrc-changes@NetBSD.org Reply-To: adam@netbsd.org X-Mailer: log_accum Message-Id: <20190211104521.73384FB16@cvs.NetBSD.org> Sender: pkgsrc-changes-owner@NetBSD.org List-Id: pkgsrc-changes.NetBSD.org Precedence: bulk List-Unsubscribe: This is a multi-part message in MIME format. --_----------=_1549881921282410 Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="US-ASCII" Module Name: pkgsrc Committed By: adam Date: Mon Feb 11 10:45:21 UTC 2019 Modified Files: pkgsrc/databases/sqlite3: Makefile Makefile.common distinfo pkgsrc/databases/sqlite3-docs: PLIST distinfo pkgsrc/databases/sqlite3-tcl: Makefile distinfo pkgsrc/devel/lemon: distinfo Log Message: sqlite3: updated to 3.27.1 SQLite Release 3.27.1: Fix a bug in the query optimizer: an adverse interaction between the OR optimization and the optimization that tries to use values read directly from an expression index instead of recomputing the expression. Hashes: Changes carried forward from version 3.27.0: Added the VACUUM INTO command Issue an SQLITE_WARNING message on the error log if a double-quoted string literal is used. The sqlite3_normalized_sql() interface works on any prepared statement created using sqlite3_prepare_v2() or sqlite3_prepare_v3(). It is no longer necessary to use sqlite3_prepare_v3() with SQLITE_PREPARE_NORMALIZE in order to use sqlite3_normalized_sql(). Added the remove_diacritics=2 option to FTS3 and FTS5. Added the SQLITE_PREPARE_NO_VTAB option to sqlite3_prepare_v3(). Use that option to prevent circular references to shadow tables from causing resource leaks. Enhancements to the sqlite3_deserialize() interface: Add the SQLITE_FCNTL_SIZE_LIMIT file-control for setting an upper bound on the size of the in-memory database created by sqlite3_deserialize. The default upper bound is 1GiB, or whatever alternative value is specified by sqlite3_config(SQLITE_CONFIG_MEMDB_MAXSIZE) and/or SQLITE_MEMDB_DEFAULT_MAXSIZE. Honor the SQLITE_DESERIALIZE_READONLY flag, which was previously described in the documentation, but was previously a no-op. Enhance the "deserialize" command of the TCL Interface to give it new "--maxsize N" and "--readonly BOOLEAN" options. Enhancements to the CLI, mostly to support testing and debugging of the SQLite library itself: Add support for ".open --hexdb". The "dbtotxt" utility program used to generate the text for the "hexdb" is added to the source tree. Add support for the "--maxsize N" option on ".open --deserialize". Add the "--memtrace" command-line option, to show all memory allocations and deallocations. Add the ".eqp trace" option on builds with SQLITE_DEBUG, to enable bytecode program listing with indentation and PRAGMA vdbe_trace all in one step. Add the ".progress" command for accessing the sqlite3_progress_handler() interface. Add the "--async" option to the ".backup" command. Add options "--expanded", "--normalized", "--plain", "--profile", "--row", "--stmt", and "--close" to the ".trace" command. Increased robustness against malicious SQL that is run against a maliciously corrupted database. Bug fixes: Do not use a partial index to do a table scan on an IN operator. Fix the query flattener so that it works on queries that contain subqueries that use window functions. Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. Fix a parser bug that prevented the use of parentheses around table-valued functions. Fix a problem with the OR optimization on indexes on expressions. Fix a problem with the LEFT JOIN strength reduction optimization in which the optimization was being applied inappropriately due to an IS NOT NULL operator. Fix the REPLACE command so that it is no longer able to sneak a NULL value into a NOT NULL column even if the NOT NULL column has a default value of NULL. Fix a problem with the use of window functions used within correlated subqueries. Fix the ALTER TABLE RENAME COLUMN command so that it works for tables that have redundant UNIQUE constraints. Fix a bug that caused zeroblob values to be truncated when inserted into a table that uses an expression index. To generate a diff of this commit: cvs rdiff -u -r1.128 -r1.129 pkgsrc/databases/sqlite3/Makefile cvs rdiff -u -r1.59 -r1.60 pkgsrc/databases/sqlite3/Makefile.common cvs rdiff -u -r1.148 -r1.149 pkgsrc/databases/sqlite3/distinfo cvs rdiff -u -r1.82 -r1.83 pkgsrc/databases/sqlite3-docs/PLIST cvs rdiff -u -r1.83 -r1.84 pkgsrc/databases/sqlite3-docs/distinfo cvs rdiff -u -r1.96 -r1.97 pkgsrc/databases/sqlite3-tcl/Makefile cvs rdiff -u -r1.95 -r1.96 pkgsrc/databases/sqlite3-tcl/distinfo cvs rdiff -u -r1.24 -r1.25 pkgsrc/devel/lemon/distinfo Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files. --_----------=_1549881921282410 Content-Disposition: inline Content-Length: 7585 Content-Transfer-Encoding: binary Content-Type: text/x-diff; charset=us-ascii Modified files: Index: pkgsrc/databases/sqlite3/Makefile diff -u pkgsrc/databases/sqlite3/Makefile:1.128 pkgsrc/databases/sqlite3/Makefile:1.129 --- pkgsrc/databases/sqlite3/Makefile:1.128 Sun Dec 9 18:51:59 2018 +++ pkgsrc/databases/sqlite3/Makefile Mon Feb 11 10:45:20 2019 @@ -1,6 +1,5 @@ -# $NetBSD: Makefile,v 1.128 2018/12/09 18:51:59 adam Exp $ +# $NetBSD: Makefile,v 1.129 2019/02/11 10:45:20 adam Exp $ -PKGREVISION= 1 .include "Makefile.common" DISTNAME= sqlite-autoconf-${SQLITE3_DISTVERSION} Index: pkgsrc/databases/sqlite3/Makefile.common diff -u pkgsrc/databases/sqlite3/Makefile.common:1.59 pkgsrc/databases/sqlite3/Makefile.common:1.60 --- pkgsrc/databases/sqlite3/Makefile.common:1.59 Tue Dec 4 12:03:52 2018 +++ pkgsrc/databases/sqlite3/Makefile.common Mon Feb 11 10:45:20 2019 @@ -1,15 +1,15 @@ -# $NetBSD: Makefile.common,v 1.59 2018/12/04 12:03:52 adam Exp $ +# $NetBSD: Makefile.common,v 1.60 2019/02/11 10:45:20 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= 3260000 -SQLITE3_VERSION= 3.26.0 +SQLITE3_DISTVERSION= 3270100 +SQLITE3_VERSION= 3.27.1 -MASTER_SITES= http://www.sqlite.org/2018/ -MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2018/ +MASTER_SITES= http://www.sqlite.org/2019/ +MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2019/ HOMEPAGE?= http://www.sqlite.org/ LICENSE= public-domain Index: pkgsrc/databases/sqlite3/distinfo diff -u pkgsrc/databases/sqlite3/distinfo:1.148 pkgsrc/databases/sqlite3/distinfo:1.149 --- pkgsrc/databases/sqlite3/distinfo:1.148 Tue Dec 4 12:03:52 2018 +++ pkgsrc/databases/sqlite3/distinfo Mon Feb 11 10:45:20 2019 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.148 2018/12/04 12:03:52 adam Exp $ +$NetBSD: distinfo,v 1.149 2019/02/11 10:45:20 adam Exp $ -SHA1 (sqlite-autoconf-3260000.tar.gz) = 9af2df1a6da5db6e2ecf3f463625f16740e036e9 -RMD160 (sqlite-autoconf-3260000.tar.gz) = 26f67390992c1abd703e78bc3876ab5a7d5363aa -SHA512 (sqlite-autoconf-3260000.tar.gz) = 8c3306b3814a0e9bc69b741f62bdb6efc9f1e07163ca3e3a1581994465de163a7924223522e812d6b3663c1525c7012a6f6d73ad333556eba9f97ce9326fbdb8 -Size (sqlite-autoconf-3260000.tar.gz) = 2779667 bytes +SHA1 (sqlite-autoconf-3270100.tar.gz) = 6cdb46a153b0e88f8a5fd80e29b3966885f39ea4 +RMD160 (sqlite-autoconf-3270100.tar.gz) = 59be346b5c342a72eb55cfb4c1b962963d8bad04 +SHA512 (sqlite-autoconf-3270100.tar.gz) = 1dca61b82ce1dbae2fe9c568ff97e0671900bab46b354bd0aadc1946cbc46b3ea84bd1504ae922f795d1ce10791bf7861a2873f045887646609e26b74919e8e4 +Size (sqlite-autoconf-3270100.tar.gz) = 2797765 bytes Index: pkgsrc/databases/sqlite3-docs/PLIST diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.82 pkgsrc/databases/sqlite3-docs/PLIST:1.83 --- pkgsrc/databases/sqlite3-docs/PLIST:1.82 Tue Dec 4 12:03:53 2018 +++ pkgsrc/databases/sqlite3-docs/PLIST Mon Feb 11 10:45:20 2019 @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.82 2018/12/04 12:03:53 adam Exp $ +@comment $NetBSD: PLIST,v 1.83 2019/02/11 10:45:20 adam Exp $ share/doc/sqlite3/34to35.html share/doc/sqlite3/35to36.html share/doc/sqlite3/about.html @@ -651,6 +651,8 @@ share/doc/sqlite3/releaselog/3_25_1.html share/doc/sqlite3/releaselog/3_25_2.html share/doc/sqlite3/releaselog/3_25_3.html share/doc/sqlite3/releaselog/3_26_0.html +share/doc/sqlite3/releaselog/3_27_0.html +share/doc/sqlite3/releaselog/3_27_1.html share/doc/sqlite3/releaselog/3_2_0.html share/doc/sqlite3/releaselog/3_2_1.html share/doc/sqlite3/releaselog/3_2_2.html Index: pkgsrc/databases/sqlite3-docs/distinfo diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.83 pkgsrc/databases/sqlite3-docs/distinfo:1.84 --- pkgsrc/databases/sqlite3-docs/distinfo:1.83 Tue Dec 4 12:03:53 2018 +++ pkgsrc/databases/sqlite3-docs/distinfo Mon Feb 11 10:45:20 2019 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.83 2018/12/04 12:03:53 adam Exp $ +$NetBSD: distinfo,v 1.84 2019/02/11 10:45:20 adam Exp $ -SHA1 (sqlite-doc-3260000.zip) = 13c48e0396d15f3f4978214e144445031a23d509 -RMD160 (sqlite-doc-3260000.zip) = bf30e093e6957ef9122979789a38956f825f0103 -SHA512 (sqlite-doc-3260000.zip) = e59f74369adb3ffe3afc235e4369101b8ba077f9cac34d524e2425278c3a30f63340613e5baa0fc3c693265525377b6830a1c6b5e97fb06702b89eb604b1eade -Size (sqlite-doc-3260000.zip) = 9321276 bytes +SHA1 (sqlite-doc-3270100.zip) = 6e22acfb6c3f7dd19ad94e251cbfdb62a2061143 +RMD160 (sqlite-doc-3270100.zip) = 216f513763a14566389bfaafbca8074d7f8c9aae +SHA512 (sqlite-doc-3270100.zip) = a56cfe57702ab1ab342c24536bcd3c01c3c57fb9e863fc775f07275d236fc0617f7eb832ca5173bf5c4c5c4b7a0b4b80e2d19b91e7724b838bf141cf0852cc1f +Size (sqlite-doc-3270100.zip) = 9361284 bytes Index: pkgsrc/databases/sqlite3-tcl/Makefile diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.96 pkgsrc/databases/sqlite3-tcl/Makefile:1.97 --- pkgsrc/databases/sqlite3-tcl/Makefile:1.96 Sun Dec 9 18:52:21 2018 +++ pkgsrc/databases/sqlite3-tcl/Makefile Mon Feb 11 10:45:21 2019 @@ -1,6 +1,5 @@ -# $NetBSD: Makefile,v 1.96 2018/12/09 18:52:21 adam Exp $ +# $NetBSD: Makefile,v 1.97 2019/02/11 10:45:21 adam Exp $ -PKGREVISION= 1 .include "../../databases/sqlite3/Makefile.common" DISTNAME= sqlite-autoconf-${SQLITE3_DISTVERSION} Index: pkgsrc/databases/sqlite3-tcl/distinfo diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.95 pkgsrc/databases/sqlite3-tcl/distinfo:1.96 --- pkgsrc/databases/sqlite3-tcl/distinfo:1.95 Tue Dec 4 12:03:53 2018 +++ pkgsrc/databases/sqlite3-tcl/distinfo Mon Feb 11 10:45:21 2019 @@ -1,7 +1,7 @@ -$NetBSD: distinfo,v 1.95 2018/12/04 12:03:53 adam Exp $ +$NetBSD: distinfo,v 1.96 2019/02/11 10:45:21 adam Exp $ -SHA1 (sqlite-autoconf-3260000.tar.gz) = 9af2df1a6da5db6e2ecf3f463625f16740e036e9 -RMD160 (sqlite-autoconf-3260000.tar.gz) = 26f67390992c1abd703e78bc3876ab5a7d5363aa -SHA512 (sqlite-autoconf-3260000.tar.gz) = 8c3306b3814a0e9bc69b741f62bdb6efc9f1e07163ca3e3a1581994465de163a7924223522e812d6b3663c1525c7012a6f6d73ad333556eba9f97ce9326fbdb8 -Size (sqlite-autoconf-3260000.tar.gz) = 2779667 bytes +SHA1 (sqlite-autoconf-3270100.tar.gz) = 6cdb46a153b0e88f8a5fd80e29b3966885f39ea4 +RMD160 (sqlite-autoconf-3270100.tar.gz) = 59be346b5c342a72eb55cfb4c1b962963d8bad04 +SHA512 (sqlite-autoconf-3270100.tar.gz) = 1dca61b82ce1dbae2fe9c568ff97e0671900bab46b354bd0aadc1946cbc46b3ea84bd1504ae922f795d1ce10791bf7861a2873f045887646609e26b74919e8e4 +Size (sqlite-autoconf-3270100.tar.gz) = 2797765 bytes SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 Index: pkgsrc/devel/lemon/distinfo diff -u pkgsrc/devel/lemon/distinfo:1.24 pkgsrc/devel/lemon/distinfo:1.25 --- pkgsrc/devel/lemon/distinfo:1.24 Tue Dec 4 12:03:53 2018 +++ pkgsrc/devel/lemon/distinfo Mon Feb 11 10:45:21 2019 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.24 2018/12/04 12:03:53 adam Exp $ +$NetBSD: distinfo,v 1.25 2019/02/11 10:45:21 adam Exp $ -SHA1 (sqlite-src-3260000.zip) = a05429d6a8337d60ddc7c6381b49941059a55f68 -RMD160 (sqlite-src-3260000.zip) = 5d249f0a318a90a2511711d42541aa094851ed83 -SHA512 (sqlite-src-3260000.zip) = 02faacd831781f25a12ffc8858d648f481d8bbdb68814b18c4c96e3a661233d0e25d675b95feeb35eee4b5ea88e5e0a1fc5fbaecbe434d3f7246d80e81bff6a3 -Size (sqlite-src-3260000.zip) = 11939787 bytes +SHA1 (sqlite-src-3270100.zip) = 491d12da3c189313bb5d4d9779572c74fed43f0d +RMD160 (sqlite-src-3270100.zip) = ea9627dd74e0ff317c5c90e69e6b38e8bc769c76 +SHA512 (sqlite-src-3270100.zip) = 5ae0d3ee747df85e5dcd7cb64057ec64843079cfcf163558aa793194ec8ba0ad5570d9c8cb152b6510357ec074da6dba7cfd2f64466f06565c54cd175d9f8945 +Size (sqlite-src-3270100.zip) = 12247922 bytes --_----------=_1549881921282410--