Received: by mail.netbsd.org (Postfix, from userid 605) id 778CA84DB7; Thu, 18 Apr 2019 10:10:05 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id EF6C084DA4 for ; Thu, 18 Apr 2019 10:10:04 +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 8lDvWICP8FiQ for ; Thu, 18 Apr 2019 10:10:04 +0000 (UTC) Received: from cvs.NetBSD.org (ivanova.NetBSD.org [IPv6:2001:470:a085:999:28c:faff:fe03:5984]) by mail.netbsd.org (Postfix) with ESMTP id EA2A684D72 for ; Thu, 18 Apr 2019 10:10:03 +0000 (UTC) Received: by cvs.NetBSD.org (Postfix, from userid 500) id E7966FB16; Thu, 18 Apr 2019 10:10:03 +0000 (UTC) Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_1555582203101970" MIME-Version: 1.0 Date: Thu, 18 Apr 2019 10:10:03 +0000 From: "Adam Ciarcinski" Subject: CVS commit: pkgsrc To: pkgsrc-changes@NetBSD.org Reply-To: adam@netbsd.org X-Mailer: log_accum Message-Id: <20190418101003.E7966FB16@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. --_----------=_1555582203101970 Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="US-ASCII" Module Name: pkgsrc Committed By: adam Date: Thu Apr 18 10:10:03 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.28.0 SQLite Release 3.28.0: Enhanced window functions: Add support the EXCLUDE clause. Add support for window chaining. Add support for GROUPS frames. Add support for " PRECEDING" and " FOLLOWING" boundaries in RANGE frames. Added the new sqlite3_stmt_isexplain(S) interface for determining whether or not a prepared statement is an EXPLAIN. Enhanced VACUUM INTO so that it works for read-only databases. New query optimizations: Enable the LIKE optimization for cases when the ESCAPE keyword is present and PRAGMA case_sensitive_like is on. In queries that are driven by a partial index, avoid unnecessary tests of the constraint named in the WHERE clause of the partial index, since we know that constraint must always be true. Enhancements to the TCL Interface: Added the -returntype option to the function method. Added the new bind_fallback method. Enhancements to the CLI: Added support for bound parameters and the .parameter command. Fix the readfile() function so that it returns an empty BLOB rather than throwing an out-of-memory error when reading an empty file. Fix the writefile() function so that when it creates new directories along the path of a new file, it gives them umask permissions rather than the same permissions as the file. Change --update option in the .archive command so that it skips files that are already in the archive and are unchanged. Add the new --insert option that works like --update used to work. Added the fossildelta.c extension that can create, apply, and deconstruct the Fossil DVCS file delta format that is used by the RBU extension. Added the SQLITE_DBCONFIG_WRITABLE_SCHEMA verb for the sqlite3_db_config() interface, that does the same work as PRAGMA writable_schema without using the SQL parser. Added the sqlite3_value_frombind() API for determining if the argument to an SQL function is from a bound parameter. Security and compatibilities enhancements to fts3_tokenizer(): The fts3_tokenizer() function always returns NULL unless either the legacy application-defined FTS3 tokenizers interface are enabled using the sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting, or unless the first argument to fts3_tokenizer() is a bound parameter. The two-argument version of fts3_tokenizer() accepts a pointer to the tokenizer method object even without the sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting if the second argument is a bound parameter Improved robustness against corrupt database files. Miscellaneous performance enhancements To generate a diff of this commit: cvs rdiff -u -r1.130 -r1.131 pkgsrc/databases/sqlite3/Makefile cvs rdiff -u -r1.61 -r1.62 pkgsrc/databases/sqlite3/Makefile.common cvs rdiff -u -r1.150 -r1.151 pkgsrc/databases/sqlite3/distinfo cvs rdiff -u -r1.84 -r1.85 pkgsrc/databases/sqlite3-docs/PLIST cvs rdiff -u -r1.85 -r1.86 pkgsrc/databases/sqlite3-docs/distinfo cvs rdiff -u -r1.98 -r1.99 pkgsrc/databases/sqlite3-tcl/Makefile cvs rdiff -u -r1.97 -r1.98 pkgsrc/databases/sqlite3-tcl/distinfo cvs rdiff -u -r1.26 -r1.27 pkgsrc/devel/lemon/distinfo Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files. --_----------=_1555582203101970 Content-Disposition: inline Content-Length: 7741 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.130 pkgsrc/databases/sqlite3/Makefile:1.131 --- pkgsrc/databases/sqlite3/Makefile:1.130 Wed Apr 3 00:32:32 2019 +++ pkgsrc/databases/sqlite3/Makefile Thu Apr 18 10:10:03 2019 @@ -1,6 +1,5 @@ -# $NetBSD: Makefile,v 1.130 2019/04/03 00:32:32 ryoon Exp $ +# $NetBSD: Makefile,v 1.131 2019/04/18 10:10:03 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.61 pkgsrc/databases/sqlite3/Makefile.common:1.62 --- pkgsrc/databases/sqlite3/Makefile.common:1.61 Mon Feb 25 18:04:29 2019 +++ pkgsrc/databases/sqlite3/Makefile.common Thu Apr 18 10:10:03 2019 @@ -1,12 +1,12 @@ -# $NetBSD: Makefile.common,v 1.61 2019/02/25 18:04:29 adam Exp $ +# $NetBSD: Makefile.common,v 1.62 2019/04/18 10:10:03 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= 3270200 -SQLITE3_VERSION= 3.27.2 +SQLITE3_DISTVERSION= 3280000 +SQLITE3_VERSION= 3.28.0 MASTER_SITES= http://www.sqlite.org/2019/ MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2019/ Index: pkgsrc/databases/sqlite3/distinfo diff -u pkgsrc/databases/sqlite3/distinfo:1.150 pkgsrc/databases/sqlite3/distinfo:1.151 --- pkgsrc/databases/sqlite3/distinfo:1.150 Mon Feb 25 18:04:29 2019 +++ pkgsrc/databases/sqlite3/distinfo Thu Apr 18 10:10:03 2019 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.150 2019/02/25 18:04:29 adam Exp $ +$NetBSD: distinfo,v 1.151 2019/04/18 10:10:03 adam Exp $ -SHA1 (sqlite-autoconf-3270200.tar.gz) = 5f5750e3f39b7b60394a2fb6ddb2371f848670e6 -RMD160 (sqlite-autoconf-3270200.tar.gz) = c47b1ed9ffd5662b3dd1faf5eb2abad28e7d2554 -SHA512 (sqlite-autoconf-3270200.tar.gz) = 0ac2515c7816932a4f725e657122c9f202bd7aba637bad9af5b4592b85efdd10a55ad34ac621b60a7aea91b1021c2ef0924c6ddfe05b2edb4f70e3d34b005972 -Size (sqlite-autoconf-3270200.tar.gz) = 2797531 bytes +SHA1 (sqlite-autoconf-3280000.tar.gz) = 01b9d8fc77085e144dddc87456c9783e53d09a53 +RMD160 (sqlite-autoconf-3280000.tar.gz) = b4e13e4b6ae0678a3813e6c07c4df6596d2e6683 +SHA512 (sqlite-autoconf-3280000.tar.gz) = e800c0d9e6c8c01ccf1d714c6c4da4b98e9610c4c06557dda6393d0792a8ae09788703d4a74dcb21844c49b3629ff7ed95a4a86ff79872aafd2b49c672c7a570 +Size (sqlite-autoconf-3280000.tar.gz) = 2810415 bytes Index: pkgsrc/databases/sqlite3-docs/PLIST diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.84 pkgsrc/databases/sqlite3-docs/PLIST:1.85 --- pkgsrc/databases/sqlite3-docs/PLIST:1.84 Mon Feb 25 18:04:30 2019 +++ pkgsrc/databases/sqlite3-docs/PLIST Thu Apr 18 10:10:03 2019 @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.84 2019/02/25 18:04:30 adam Exp $ +@comment $NetBSD: PLIST,v 1.85 2019/04/18 10:10:03 adam Exp $ share/doc/sqlite3/34to35.html share/doc/sqlite3/35to36.html share/doc/sqlite3/about.html @@ -170,6 +170,7 @@ share/doc/sqlite3/c3ref/status.html share/doc/sqlite3/c3ref/step.html share/doc/sqlite3/c3ref/stmt.html share/doc/sqlite3/c3ref/stmt_busy.html +share/doc/sqlite3/c3ref/stmt_isexplain.html share/doc/sqlite3/c3ref/stmt_readonly.html share/doc/sqlite3/c3ref/stmt_scanstatus.html share/doc/sqlite3/c3ref/stmt_scanstatus_reset.html @@ -654,6 +655,7 @@ 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_27_2.html +share/doc/sqlite3/releaselog/3_28_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 Index: pkgsrc/databases/sqlite3-docs/distinfo diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.85 pkgsrc/databases/sqlite3-docs/distinfo:1.86 --- pkgsrc/databases/sqlite3-docs/distinfo:1.85 Mon Feb 25 18:04:30 2019 +++ pkgsrc/databases/sqlite3-docs/distinfo Thu Apr 18 10:10:03 2019 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.85 2019/02/25 18:04:30 adam Exp $ +$NetBSD: distinfo,v 1.86 2019/04/18 10:10:03 adam Exp $ -SHA1 (sqlite-doc-3270200.zip) = 7b49d59acdfd08be8d098b4fc7e150b3e90e6a9c -RMD160 (sqlite-doc-3270200.zip) = c433654546467cea6ebd358de5f5a4555c6f5abd -SHA512 (sqlite-doc-3270200.zip) = 00a7c51aeaea2d9338662553c331addca8cd4ae656f4090630b4b2c2e6ceffffd9bd3c6a97117915577cfd6dafeddf9da21f865ab378f86c4832ba0b1c419a2f -Size (sqlite-doc-3270200.zip) = 9371606 bytes +SHA1 (sqlite-doc-3280000.zip) = f3242cf186a4e194e7d1a5e00384dd4aa66ec16b +RMD160 (sqlite-doc-3280000.zip) = b495c4795641f9583b5b061ba7351274197689db +SHA512 (sqlite-doc-3280000.zip) = 83e23dff00614d31d501c66c29d8d4aa780b38859242b58937243235d185fe3db2f9f3c1accf9bf2df0b457a6e32612a00e82f503a8665aad4f19602e2b36396 +Size (sqlite-doc-3280000.zip) = 9421770 bytes Index: pkgsrc/databases/sqlite3-tcl/Makefile diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.98 pkgsrc/databases/sqlite3-tcl/Makefile:1.99 --- pkgsrc/databases/sqlite3-tcl/Makefile:1.98 Wed Apr 3 00:32:32 2019 +++ pkgsrc/databases/sqlite3-tcl/Makefile Thu Apr 18 10:10:03 2019 @@ -1,6 +1,5 @@ -# $NetBSD: Makefile,v 1.98 2019/04/03 00:32:32 ryoon Exp $ +# $NetBSD: Makefile,v 1.99 2019/04/18 10:10:03 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.97 pkgsrc/databases/sqlite3-tcl/distinfo:1.98 --- pkgsrc/databases/sqlite3-tcl/distinfo:1.97 Mon Feb 25 18:04:30 2019 +++ pkgsrc/databases/sqlite3-tcl/distinfo Thu Apr 18 10:10:03 2019 @@ -1,7 +1,7 @@ -$NetBSD: distinfo,v 1.97 2019/02/25 18:04:30 adam Exp $ +$NetBSD: distinfo,v 1.98 2019/04/18 10:10:03 adam Exp $ -SHA1 (sqlite-autoconf-3270200.tar.gz) = 5f5750e3f39b7b60394a2fb6ddb2371f848670e6 -RMD160 (sqlite-autoconf-3270200.tar.gz) = c47b1ed9ffd5662b3dd1faf5eb2abad28e7d2554 -SHA512 (sqlite-autoconf-3270200.tar.gz) = 0ac2515c7816932a4f725e657122c9f202bd7aba637bad9af5b4592b85efdd10a55ad34ac621b60a7aea91b1021c2ef0924c6ddfe05b2edb4f70e3d34b005972 -Size (sqlite-autoconf-3270200.tar.gz) = 2797531 bytes +SHA1 (sqlite-autoconf-3280000.tar.gz) = 01b9d8fc77085e144dddc87456c9783e53d09a53 +RMD160 (sqlite-autoconf-3280000.tar.gz) = b4e13e4b6ae0678a3813e6c07c4df6596d2e6683 +SHA512 (sqlite-autoconf-3280000.tar.gz) = e800c0d9e6c8c01ccf1d714c6c4da4b98e9610c4c06557dda6393d0792a8ae09788703d4a74dcb21844c49b3629ff7ed95a4a86ff79872aafd2b49c672c7a570 +Size (sqlite-autoconf-3280000.tar.gz) = 2810415 bytes SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 Index: pkgsrc/devel/lemon/distinfo diff -u pkgsrc/devel/lemon/distinfo:1.26 pkgsrc/devel/lemon/distinfo:1.27 --- pkgsrc/devel/lemon/distinfo:1.26 Mon Feb 25 18:04:30 2019 +++ pkgsrc/devel/lemon/distinfo Thu Apr 18 10:10:03 2019 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.26 2019/02/25 18:04:30 adam Exp $ +$NetBSD: distinfo,v 1.27 2019/04/18 10:10:03 adam Exp $ -SHA1 (sqlite-src-3270200.zip) = 823a77ee707b56722cd201aaf2f82e7bef57c042 -RMD160 (sqlite-src-3270200.zip) = c35455e494983a04dbff6bd4b9b1511d1b60a107 -SHA512 (sqlite-src-3270200.zip) = 52f61e2fa54558b953dba62b27961eef8563f40e6b4a62638087cb22c7d1fdf2c915ea1071939e2e98f3ce6041da2c9bfb1bdbc1e8b8b4a049b8148e878a4e5e -Size (sqlite-src-3270200.zip) = 12248529 bytes +SHA1 (sqlite-src-3280000.zip) = 21c391f177ac39750e5a8ac61d07550bf6befb4a +RMD160 (sqlite-src-3280000.zip) = 73241e9eb7a3938453e822e4af7ac71099c12f27 +SHA512 (sqlite-src-3280000.zip) = 49c35c65fa686a2326e13218db583c54fa5fe8f48f0caddd11a942601803b3023f7d32ffbab16641e0d72dc9ed288ad26eaa7226c865ac54e1f181859125651f +Size (sqlite-src-3280000.zip) = 12477204 bytes --_----------=_1555582203101970--