Received: by mail.netbsd.org (Postfix, from userid 605) id 1362784DFD; Thu, 7 Jun 2018 07:36:52 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id 60B3984DB0 for ; Thu, 7 Jun 2018 07:36:51 +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 D3J14ksAREIY for ; Thu, 7 Jun 2018 07:36:49 +0000 (UTC) Received: from cvs.NetBSD.org (ivanova.netbsd.org [199.233.217.197]) by mail.netbsd.org (Postfix) with ESMTP id 9928084D7D for ; Thu, 7 Jun 2018 07:36:49 +0000 (UTC) Received: by cvs.NetBSD.org (Postfix, from userid 500) id 926D6FBEC; Thu, 7 Jun 2018 07:36:49 +0000 (UTC) Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_1528357009284490" MIME-Version: 1.0 Date: Thu, 7 Jun 2018 07:36:49 +0000 From: "Adam Ciarcinski" Subject: CVS commit: pkgsrc To: pkgsrc-changes@NetBSD.org Reply-To: adam@netbsd.org X-Mailer: log_accum Message-Id: <20180607073649.926D6FBEC@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. --_----------=_1528357009284490 Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="US-ASCII" Module Name: pkgsrc Committed By: adam Date: Thu Jun 7 07:36:49 UTC 2018 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.24.0 SQLite Release 3.24.0: Add support for PostgreSQL-style UPSERT. Add support for auxiliary columns in r-tree tables. Add C-language APIs for discovering SQL keywords used by SQLite: sqlite3_keyword_count(), sqlite3_keyword_name(), and sqlite3_keyword_check(). Add C-language APIs for dynamic strings based on the sqlite3_str object. Enhance ALTER TABLE so that it recognizes "true" and "false" as valid arguments to DEFAULT. Add the sorter-reference optimization as a compile-time option. Only available if compiled with SQLITE_ENABLE_SORTER_REFERENCES. Improve the format of the EXPLAIN QUERY PLAN raw output, so that it gives better information about the query plan and about the relationships between the various components of the plan. Added the SQLITE_DBCONFIG_RESET_DATABASE option to the sqlite3_db_config() API. CLI Enhancements: Automatically intercepts the raw EXPLAIN QUERY PLAN output and reformats it into an ASCII-art graph. Lines that begin with "#" and that are not in the middle of an SQL statement are interpreted as comments. Added the --append option to the ".backup" command. Added the ".dbconfig" command. Performance: UPDATE avoids unnecessary low-level disk writes when the contents of the database file do not actually change. For example, "UPDATE t1 SET x=25 WHERE y=?" generates no extra disk I/O if the value in column x is already 25. Similarly, when doing UPDATE on records that span multiple pages, only the subset of pages that actually change are written to disk. This is a low-level performance optimization only and does not affect the behavior of TRIGGERs or other higher level SQL structures. Queries that use ORDER BY and LIMIT now try to avoid computing rows that cannot possibly come in under the LIMIT. This can greatly improve performance of ORDER BY LIMIT queries, especially when the LIMIT is small relative to the number of unrestricted output rows. The OR optimization is allowed to proceed even if the OR expression has also been converted into an IN expression. Uses of the OR optimization are now also more clearly shown in the EXPLAIN QUERY PLAN output. The query planner is more aggressive about using automatic indexes for views and subqueries for which it is not possible to create a persistent index. Make use of the one-pass UPDATE and DELETE query plans in the R-Tree extension where appropriate. Performance improvements in the LEMON-generated parser. Bug fixes: For the right-hand table of a LEFT JOIN, compute the values of expressions directly rather than loading precomputed values out of an expression index as the expression index might not contain the correct value. Do not attempt to use terms from the WHERE clause to enable indexed lookup of the right-hand table of a LEFT JOIN. Fix a memory leak that can occur following a failure to open error in the CSV virtual table Fix a long-standing problem wherein a corrupt schema on the sqlite_sequence table used by AUTOINCREMENT can lead to a crash. Fix the json_each() function so that it returns valid results on its "fullkey" column when the input is a simple value rather than an array or object. To generate a diff of this commit: cvs rdiff -u -r1.123 -r1.124 pkgsrc/databases/sqlite3/Makefile cvs rdiff -u -r1.53 -r1.54 pkgsrc/databases/sqlite3/Makefile.common cvs rdiff -u -r1.142 -r1.143 pkgsrc/databases/sqlite3/distinfo cvs rdiff -u -r1.76 -r1.77 pkgsrc/databases/sqlite3-docs/PLIST cvs rdiff -u -r1.77 -r1.78 pkgsrc/databases/sqlite3-docs/distinfo cvs rdiff -u -r1.92 -r1.93 pkgsrc/databases/sqlite3-tcl/Makefile cvs rdiff -u -r1.89 -r1.90 pkgsrc/databases/sqlite3-tcl/distinfo cvs rdiff -u -r1.18 -r1.19 pkgsrc/devel/lemon/distinfo Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files. --_----------=_1528357009284490 Content-Disposition: inline Content-Length: 11755 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.123 pkgsrc/databases/sqlite3/Makefile:1.124 --- pkgsrc/databases/sqlite3/Makefile:1.123 Sat Apr 14 07:33:53 2018 +++ pkgsrc/databases/sqlite3/Makefile Thu Jun 7 07:36:49 2018 @@ -1,6 +1,5 @@ -# $NetBSD: Makefile,v 1.123 2018/04/14 07:33:53 adam Exp $ +# $NetBSD: Makefile,v 1.124 2018/06/07 07:36:49 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.53 pkgsrc/databases/sqlite3/Makefile.common:1.54 --- pkgsrc/databases/sqlite3/Makefile.common:1.53 Thu Apr 12 10:21:38 2018 +++ pkgsrc/databases/sqlite3/Makefile.common Thu Jun 7 07:36:49 2018 @@ -1,12 +1,12 @@ -# $NetBSD: Makefile.common,v 1.53 2018/04/12 10:21:38 adam Exp $ +# $NetBSD: Makefile.common,v 1.54 2018/06/07 07:36:49 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= 3230100 -SQLITE3_VERSION= 3.23.1 +SQLITE3_DISTVERSION= 3240000 +SQLITE3_VERSION= 3.24.0 MASTER_SITES= http://www.sqlite.org/2018/ MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2018/ Index: pkgsrc/databases/sqlite3/distinfo diff -u pkgsrc/databases/sqlite3/distinfo:1.142 pkgsrc/databases/sqlite3/distinfo:1.143 --- pkgsrc/databases/sqlite3/distinfo:1.142 Thu Apr 12 10:21:38 2018 +++ pkgsrc/databases/sqlite3/distinfo Thu Jun 7 07:36:49 2018 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.142 2018/04/12 10:21:38 adam Exp $ +$NetBSD: distinfo,v 1.143 2018/06/07 07:36:49 adam Exp $ -SHA1 (sqlite-autoconf-3230100.tar.gz) = 0edbfd75ececb95e8e6448d6ff33df82774c9646 -RMD160 (sqlite-autoconf-3230100.tar.gz) = 53070f0336914a525fa5aea282e9e5bebc703ff8 -SHA512 (sqlite-autoconf-3230100.tar.gz) = 52cae7ed0678b763d40373ae260672b906861379428529a58a017cbc82419a6b109e0b2ac7ff5532e6d941693cc4ab68e6563f424b92b3b27c8916859a6e4826 -Size (sqlite-autoconf-3230100.tar.gz) = 2675362 bytes +SHA1 (sqlite-autoconf-3240000.tar.gz) = da68915e3563b5244cbcdb6c7e20fb35559bcfc6 +RMD160 (sqlite-autoconf-3240000.tar.gz) = e1d3566adf3c61065420bc02956e37fe8b3e546e +SHA512 (sqlite-autoconf-3240000.tar.gz) = eaec866de26003ec36559aab15dd18dc0e6029453002a4eec5e176bb35a712b8b06c235436e6c1a226b67c7eb90d7a26c2b3b3d9a5e6e92a5af485236b77c878 +Size (sqlite-autoconf-3240000.tar.gz) = 2699252 bytes Index: pkgsrc/databases/sqlite3-docs/PLIST diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.76 pkgsrc/databases/sqlite3-docs/PLIST:1.77 --- pkgsrc/databases/sqlite3-docs/PLIST:1.76 Thu Apr 12 10:21:38 2018 +++ pkgsrc/databases/sqlite3-docs/PLIST Thu Jun 7 07:36:49 2018 @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.76 2018/04/12 10:21:38 adam Exp $ +@comment $NetBSD: PLIST,v 1.77 2018/06/07 07:36:49 adam Exp $ share/doc/sqlite3/34to35.html share/doc/sqlite3/35to36.html share/doc/sqlite3/about.html @@ -68,6 +68,7 @@ share/doc/sqlite3/c3ref/c_sync_dataonly. share/doc/sqlite3/c3ref/c_testctrl_always.html share/doc/sqlite3/c3ref/c_trace.html share/doc/sqlite3/c3ref/c_vtab_constraint_support.html +share/doc/sqlite3/c3ref/c_win32_data_directory_type.html share/doc/sqlite3/c3ref/cancel_auto_extension.html share/doc/sqlite3/c3ref/changes.html share/doc/sqlite3/c3ref/clear_bindings.html @@ -121,6 +122,7 @@ share/doc/sqlite3/c3ref/int64.html share/doc/sqlite3/c3ref/interrupt.html share/doc/sqlite3/c3ref/intro.html share/doc/sqlite3/c3ref/io_methods.html +share/doc/sqlite3/c3ref/keyword_check.html share/doc/sqlite3/c3ref/last_insert_rowid.html share/doc/sqlite3/c3ref/libversion.html share/doc/sqlite3/c3ref/limit.html @@ -172,6 +174,11 @@ share/doc/sqlite3/c3ref/stmt_readonly.ht share/doc/sqlite3/c3ref/stmt_scanstatus.html share/doc/sqlite3/c3ref/stmt_scanstatus_reset.html share/doc/sqlite3/c3ref/stmt_status.html +share/doc/sqlite3/c3ref/str.html +share/doc/sqlite3/c3ref/str_append.html +share/doc/sqlite3/c3ref/str_errcode.html +share/doc/sqlite3/c3ref/str_finish.html +share/doc/sqlite3/c3ref/str_new.html share/doc/sqlite3/c3ref/strglob.html share/doc/sqlite3/c3ref/stricmp.html share/doc/sqlite3/c3ref/strlike.html @@ -202,6 +209,7 @@ share/doc/sqlite3/c3ref/wal_autocheckpoi share/doc/sqlite3/c3ref/wal_checkpoint.html share/doc/sqlite3/c3ref/wal_checkpoint_v2.html share/doc/sqlite3/c3ref/wal_hook.html +share/doc/sqlite3/c3ref/win32_set_directory.html share/doc/sqlite3/c_interface.html share/doc/sqlite3/capi3.html share/doc/sqlite3/capi3ref.html @@ -302,6 +310,7 @@ share/doc/sqlite3/images/books/kreibich. share/doc/sqlite3/images/books/newman.jpg share/doc/sqlite3/images/books/nishizawa2.jpg share/doc/sqlite3/images/books/owens.jpg +share/doc/sqlite3/images/books/sanderson2018.jpg share/doc/sqlite3/images/books/symbiansql.jpg share/doc/sqlite3/images/books/vanderLans.jpg share/doc/sqlite3/images/btreemodule_balance_deeper.svg @@ -363,6 +372,8 @@ share/doc/sqlite3/images/foreignlogos/fl share/doc/sqlite3/images/foreignlogos/ge.gif share/doc/sqlite3/images/foreignlogos/google.gif share/doc/sqlite3/images/foreignlogos/intuit.gif +share/doc/sqlite3/images/foreignlogos/loc.gif +share/doc/sqlite3/images/foreignlogos/loc.jpg share/doc/sqlite3/images/foreignlogos/mcaffee.gif share/doc/sqlite3/images/foreignlogos/microsoft.gif share/doc/sqlite3/images/foreignlogos/monotone.gif @@ -397,6 +408,7 @@ share/doc/sqlite3/images/harmony.gif share/doc/sqlite3/images/index-ex1-x-b.gif share/doc/sqlite3/images/indirect1b1.gif share/doc/sqlite3/images/joe1.jpg +share/doc/sqlite3/images/loc.jpg share/doc/sqlite3/images/ne.gif share/doc/sqlite3/images/ne.png share/doc/sqlite3/images/nocopy.gif @@ -496,6 +508,7 @@ share/doc/sqlite3/images/syntax/table-or share/doc/sqlite3/images/syntax/type-name.gif share/doc/sqlite3/images/syntax/update-stmt-limited.gif share/doc/sqlite3/images/syntax/update-stmt.gif +share/doc/sqlite3/images/syntax/upsert-clause.gif share/doc/sqlite3/images/syntax/vacuum-stmt.gif share/doc/sqlite3/images/syntax/with-clause.gif share/doc/sqlite3/images/table-ex1b2.gif @@ -508,6 +521,7 @@ share/doc/sqlite3/isolation.html share/doc/sqlite3/json1.html share/doc/sqlite3/keyword_index.html share/doc/sqlite3/lang.html +share/doc/sqlite3/lang_UPSERT.html share/doc/sqlite3/lang_aggfunc.html share/doc/sqlite3/lang_altertable.html share/doc/sqlite3/lang_analyze.html @@ -545,6 +559,7 @@ share/doc/sqlite3/lemon.html share/doc/sqlite3/limits.html share/doc/sqlite3/loadext.html share/doc/sqlite3/lockingv3.html +share/doc/sqlite3/locrsf.html share/doc/sqlite3/lts.html share/doc/sqlite3/malloc.html share/doc/sqlite3/mingw.html @@ -620,6 +635,7 @@ share/doc/sqlite3/releaselog/3_21_0.html share/doc/sqlite3/releaselog/3_22_0.html share/doc/sqlite3/releaselog/3_23_0.html share/doc/sqlite3/releaselog/3_23_1.html +share/doc/sqlite3/releaselog/3_24_0.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 @@ -881,6 +897,7 @@ share/doc/sqlite3/syntax/table-or-subque share/doc/sqlite3/syntax/type-name.html share/doc/sqlite3/syntax/update-stmt-limited.html share/doc/sqlite3/syntax/update-stmt.html +share/doc/sqlite3/syntax/upsert-clause.html share/doc/sqlite3/syntax/vacuum-stmt.html share/doc/sqlite3/syntax/with-clause.html share/doc/sqlite3/syntaxdiagrams.html @@ -900,6 +917,7 @@ share/doc/sqlite3/version3.html share/doc/sqlite3/versionnumbers.html share/doc/sqlite3/vfs.html share/doc/sqlite3/vtab.html +share/doc/sqlite3/vtablist.html share/doc/sqlite3/wal.html share/doc/sqlite3/walformat.html share/doc/sqlite3/whentouse.html Index: pkgsrc/databases/sqlite3-docs/distinfo diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.77 pkgsrc/databases/sqlite3-docs/distinfo:1.78 --- pkgsrc/databases/sqlite3-docs/distinfo:1.77 Thu Apr 12 10:21:38 2018 +++ pkgsrc/databases/sqlite3-docs/distinfo Thu Jun 7 07:36:49 2018 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.77 2018/04/12 10:21:38 adam Exp $ +$NetBSD: distinfo,v 1.78 2018/06/07 07:36:49 adam Exp $ -SHA1 (sqlite-doc-3230100.zip) = a7bf3d789f2fc4e74c2eca01f9aa21124e705222 -RMD160 (sqlite-doc-3230100.zip) = 77cac27945c3e84b5eec4c51fcf23157fff465a3 -SHA512 (sqlite-doc-3230100.zip) = d3a42621480a928446c5f71d0f2ee68e245b071971da38438f9070bd5bcbe1930ea5bd20e06c68543df75badd2e4565abc94420df50b7152c9cd129587471471 -Size (sqlite-doc-3230100.zip) = 8882546 bytes +SHA1 (sqlite-doc-3240000.zip) = 9684d06b7e6ec1868b1ef075993dc29d952dac97 +RMD160 (sqlite-doc-3240000.zip) = 66f10080117b2b8cc4034db6fb6377355db68c08 +SHA512 (sqlite-doc-3240000.zip) = 31e9046cea569d7ad1b3af176e1bb18cd59474afb6849871ead6e7c9c096f046162fb313a38684a8c944fad9f689c4c3c692be1d7dc6a8ef5a6685bbc7dfdab6 +Size (sqlite-doc-3240000.zip) = 9030826 bytes Index: pkgsrc/databases/sqlite3-tcl/Makefile diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.92 pkgsrc/databases/sqlite3-tcl/Makefile:1.93 --- pkgsrc/databases/sqlite3-tcl/Makefile:1.92 Sat Apr 14 07:34:14 2018 +++ pkgsrc/databases/sqlite3-tcl/Makefile Thu Jun 7 07:36:49 2018 @@ -1,6 +1,5 @@ -# $NetBSD: Makefile,v 1.92 2018/04/14 07:34:14 adam Exp $ +# $NetBSD: Makefile,v 1.93 2018/06/07 07:36:49 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.89 pkgsrc/databases/sqlite3-tcl/distinfo:1.90 --- pkgsrc/databases/sqlite3-tcl/distinfo:1.89 Thu Apr 12 10:21:38 2018 +++ pkgsrc/databases/sqlite3-tcl/distinfo Thu Jun 7 07:36:49 2018 @@ -1,7 +1,7 @@ -$NetBSD: distinfo,v 1.89 2018/04/12 10:21:38 adam Exp $ +$NetBSD: distinfo,v 1.90 2018/06/07 07:36:49 adam Exp $ -SHA1 (sqlite-autoconf-3230100.tar.gz) = 0edbfd75ececb95e8e6448d6ff33df82774c9646 -RMD160 (sqlite-autoconf-3230100.tar.gz) = 53070f0336914a525fa5aea282e9e5bebc703ff8 -SHA512 (sqlite-autoconf-3230100.tar.gz) = 52cae7ed0678b763d40373ae260672b906861379428529a58a017cbc82419a6b109e0b2ac7ff5532e6d941693cc4ab68e6563f424b92b3b27c8916859a6e4826 -Size (sqlite-autoconf-3230100.tar.gz) = 2675362 bytes +SHA1 (sqlite-autoconf-3240000.tar.gz) = da68915e3563b5244cbcdb6c7e20fb35559bcfc6 +RMD160 (sqlite-autoconf-3240000.tar.gz) = e1d3566adf3c61065420bc02956e37fe8b3e546e +SHA512 (sqlite-autoconf-3240000.tar.gz) = eaec866de26003ec36559aab15dd18dc0e6029453002a4eec5e176bb35a712b8b06c235436e6c1a226b67c7eb90d7a26c2b3b3d9a5e6e92a5af485236b77c878 +Size (sqlite-autoconf-3240000.tar.gz) = 2699252 bytes SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 Index: pkgsrc/devel/lemon/distinfo diff -u pkgsrc/devel/lemon/distinfo:1.18 pkgsrc/devel/lemon/distinfo:1.19 --- pkgsrc/devel/lemon/distinfo:1.18 Thu Apr 12 10:21:38 2018 +++ pkgsrc/devel/lemon/distinfo Thu Jun 7 07:36:49 2018 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.18 2018/04/12 10:21:38 adam Exp $ +$NetBSD: distinfo,v 1.19 2018/06/07 07:36:49 adam Exp $ -SHA1 (sqlite-src-3230100.zip) = 90bea4e46a01e9c27356b19c3150a8bf146c09fc -RMD160 (sqlite-src-3230100.zip) = ac5656f535e1316d890c8a4008d651781bb1aaeb -SHA512 (sqlite-src-3230100.zip) = 69a87b76860c3b172d9e68b0fc0b8c157b606375e2b7d793ce4bd4b898ef737cd721189bc6a3342c749e224e60fa96203d449668c49dff2ebdc682b49630a59b -Size (sqlite-src-3230100.zip) = 10849436 bytes +SHA1 (sqlite-src-3240000.zip) = fb558c49ee21a837713c4f1e7e413309aabdd9c7 +RMD160 (sqlite-src-3240000.zip) = be4281044f05b6ebfe87cc7304d47fd854ad29c4 +SHA512 (sqlite-src-3240000.zip) = 812c2df7179abb1e445b5b3e161c940b120c53366a7b2c1f0bfc3599cd9921e5543ba39ca3f297eeaefec318f10c15f630f00f9cf04133c7cd419a04f3bbdd0e +Size (sqlite-src-3240000.zip) = 10980065 bytes --_----------=_1528357009284490--