Received: by mail.netbsd.org (Postfix, from userid 605) id 465BA84DAA; Mon, 30 Oct 2017 18:36:15 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id C529E84D5B for ; Mon, 30 Oct 2017 18:36:14 +0000 (UTC) X-Virus-Scanned: amavisd-new at netbsd.org Received: from mail.netbsd.org ([127.0.0.1]) by localhost (mail.netbsd.org [127.0.0.1]) (amavisd-new, port 10025) with ESMTP id bNdE3lMuLwiG for ; Mon, 30 Oct 2017 18:36:13 +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 D94EE84D1E for ; Mon, 30 Oct 2017 18:36:13 +0000 (UTC) Received: by cvs.NetBSD.org (Postfix, from userid 500) id CEEA1FBDE; Mon, 30 Oct 2017 18:36:13 +0000 (UTC) Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_1509388573159400" MIME-Version: 1.0 Date: Mon, 30 Oct 2017 18:36:13 +0000 From: "Adam Ciarcinski" Subject: CVS commit: pkgsrc To: pkgsrc-changes@NetBSD.org Reply-To: adam@netbsd.org X-Mailer: log_accum Message-Id: <20171030183613.CEEA1FBDE@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. --_----------=_1509388573159400 Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="US-ASCII" Module Name: pkgsrc Committed By: adam Date: Mon Oct 30 18:36:13 UTC 2017 Modified Files: pkgsrc/databases/sqlite3: Makefile Makefile.version distinfo pkgsrc/databases/sqlite3-docs: PLIST distinfo pkgsrc/databases/sqlite3-tcl: Makefile distinfo pkgsrc/devel/lemon: distinfo Log Message: sqlite3: updated to 3.21.0 Release 3.21.0: Take advantage of the atomic-write capabilities in the F2FS filesystem when available, for greatly reduced transaction overhead. This currently requires the SQLITE_ENABLE_BATCH_ATOMIC_WRITE compile-time option. Allow ATTACH and DETACH commands to work inside of a transaction. Allow WITHOUT ROWID virtual tables to be writable if the PRIMARY KEY contains exactly one column. The "fsync()" that occurs after the header is written in a WAL reset now uses the sync settings for checkpoints. This means it will use a "fullfsync" on macs if PRAGMA checkpoint_fullfsync set on. The sqlite3_sourceid() function tries to detect if the source code has been modified from what is checked into version control and if there are modifications, the last four characters of the version hash are shown as "alt1" or "alt2". The objective is to detect accidental and/or careless edits. A forger can subvert this feature. Improved de-quoting of column names for CREATE TABLE AS statements with an aggregate query on the right-hand side. Fewer "stat()" system calls issued by the unix VFS. Enhanced the LIKE optimization so that it works with an ESCAPE clause. Enhanced PRAGMA integrity_check and PRAGMA quick_check to detect obscure row corruption that they were formerly missing. Also update both pragmas so that they return error text rather than SQLITE_CORRUPT when encountering corruption in records. The query planner now prefers to implement FROM-clause subqueries using co-routines rather using the query flattener optimization. Support for the use of co-routines for subqueries may no longer be disabled. Pass information about !=, IS, IS NOT, NOT NULL, and IS NULL constraints into the xBestIndex method of virtual tables. Enhanced the CSV virtual table so that it accepts the last row of input if the final new-line character is missing. Remove the rarely-used "scratch" memory allocator. Replace it with the SQLITE_CONFIG_SMALL_MALLOC configuration setting that gives SQLite a hint that large memory allocations should be avoided when possible. Added the swarm virtual table to the existing union virtual table extension. Added the sqlite_dbpage virtual table for providing direct access to pages of the database file. The source code is built into the amalgamation and is activated using the -DSQLITE_ENABLE_DBPAGE_VTAB compile-time option. Add a new type of fts5vocab virtual table - "instance" - that provides direct access to an FTS5 full-text index at the lowest possible level. Remove a call to rand_s() in the Windows VFS since it was causing problems in Firefox on some older laptops. The src/shell.c source code to the command-line shell is no longer under version control. That file is now generated as part of the build process. Miscellaneous microoptimizations reduce CPU usage by about 2.1%. Bug fixes To generate a diff of this commit: cvs rdiff -u -r1.118 -r1.119 pkgsrc/databases/sqlite3/Makefile cvs rdiff -u -r1.36 -r1.37 pkgsrc/databases/sqlite3/Makefile.version cvs rdiff -u -r1.138 -r1.139 pkgsrc/databases/sqlite3/distinfo cvs rdiff -u -r1.72 -r1.73 pkgsrc/databases/sqlite3-docs/PLIST cvs rdiff -u -r1.73 -r1.74 pkgsrc/databases/sqlite3-docs/distinfo cvs rdiff -u -r1.87 -r1.88 pkgsrc/databases/sqlite3-tcl/Makefile cvs rdiff -u -r1.85 -r1.86 pkgsrc/databases/sqlite3-tcl/distinfo cvs rdiff -u -r1.14 -r1.15 pkgsrc/devel/lemon/distinfo Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files. --_----------=_1509388573159400 Content-Disposition: inline Content-Length: 8171 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.118 pkgsrc/databases/sqlite3/Makefile:1.119 --- pkgsrc/databases/sqlite3/Makefile:1.118 Mon Sep 18 09:52:57 2017 +++ pkgsrc/databases/sqlite3/Makefile Mon Oct 30 18:36:13 2017 @@ -1,6 +1,5 @@ -# $NetBSD: Makefile,v 1.118 2017/09/18 09:52:57 maya Exp $ +# $NetBSD: Makefile,v 1.119 2017/10/30 18:36:13 adam Exp $ -PKGREVISION= 1 .include "Makefile.common" PKGNAME= sqlite3-${SQLITE3_VERSION} Index: pkgsrc/databases/sqlite3/Makefile.version diff -u pkgsrc/databases/sqlite3/Makefile.version:1.36 pkgsrc/databases/sqlite3/Makefile.version:1.37 --- pkgsrc/databases/sqlite3/Makefile.version:1.36 Fri Aug 25 05:27:53 2017 +++ pkgsrc/databases/sqlite3/Makefile.version Mon Oct 30 18:36:13 2017 @@ -1,12 +1,12 @@ -# $NetBSD: Makefile.version,v 1.36 2017/08/25 05:27:53 adam Exp $ +# $NetBSD: Makefile.version,v 1.37 2017/10/30 18:36:13 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= 3200100 -SQLITE3_VERSION= 3.20.1 +SQLITE3_DISTVERSION= 3210000 +SQLITE3_VERSION= 3.21.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.138 pkgsrc/databases/sqlite3/distinfo:1.139 --- pkgsrc/databases/sqlite3/distinfo:1.138 Fri Aug 25 05:27:53 2017 +++ pkgsrc/databases/sqlite3/distinfo Mon Oct 30 18:36:13 2017 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.138 2017/08/25 05:27:53 adam Exp $ +$NetBSD: distinfo,v 1.139 2017/10/30 18:36:13 adam Exp $ -SHA1 (sqlite-autoconf-3200100.tar.gz) = 48593dcd19473f25fe6fcd08048e13ddbff4c983 -RMD160 (sqlite-autoconf-3200100.tar.gz) = 9e6f5367269bdeba47cce342be0cb428b1d6e169 -SHA512 (sqlite-autoconf-3200100.tar.gz) = 56e3d326ea2225cadc628c3518d46d9f7c4bafa0e3612f2b7ab0dc0d79fcbb7e095f6d84a9a48e1c6d83adcdc8706ad5ac4404f0f622c7fe38cfde3a7e7e69f0 -Size (sqlite-autoconf-3200100.tar.gz) = 2565638 bytes +SHA1 (sqlite-autoconf-3210000.tar.gz) = f56fe3407d8297fc0a68a058f4c9e6b77e83575c +RMD160 (sqlite-autoconf-3210000.tar.gz) = eff831c68562a4da921f38da2b29e16bc8904d1a +SHA512 (sqlite-autoconf-3210000.tar.gz) = 8f00708965eacef171620c49538f75768d350ec3f2bfef412a5c70af865ab03b6a64ce1e65d9fdb3d66f4d00262a30fc162b01fd69f63c05c14d5243374b6298 +Size (sqlite-autoconf-3210000.tar.gz) = 2568942 bytes Index: pkgsrc/databases/sqlite3-docs/PLIST diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.72 pkgsrc/databases/sqlite3-docs/PLIST:1.73 --- pkgsrc/databases/sqlite3-docs/PLIST:1.72 Fri Aug 25 05:27:53 2017 +++ pkgsrc/databases/sqlite3-docs/PLIST Mon Oct 30 18:36:13 2017 @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.72 2017/08/25 05:27:53 adam Exp $ +@comment $NetBSD: PLIST,v 1.73 2017/10/30 18:36:13 adam Exp $ share/doc/sqlite3/34to35.html share/doc/sqlite3/35to36.html share/doc/sqlite3/about.html @@ -45,7 +45,7 @@ share/doc/sqlite3/c3ref/c_dbstatus_optio share/doc/sqlite3/c3ref/c_deny.html share/doc/sqlite3/c3ref/c_deterministic.html share/doc/sqlite3/c3ref/c_fail.html -share/doc/sqlite3/c3ref/c_fcntl_busyhandler.html +share/doc/sqlite3/c3ref/c_fcntl_begin_atomic_write.html share/doc/sqlite3/c3ref/c_index_constraint_eq.html share/doc/sqlite3/c3ref/c_index_scan_unique.html share/doc/sqlite3/c3ref/c_iocap_atomic.html @@ -301,6 +301,7 @@ share/doc/sqlite3/images/btreemodule_bal share/doc/sqlite3/images/btreemodule_balance_shallower.svg share/doc/sqlite3/images/btreemodule_delete1.svg share/doc/sqlite3/images/btreemodule_overview.svg +share/doc/sqlite3/images/cc-diff.jpg share/doc/sqlite3/images/chw.jpg share/doc/sqlite3/images/cpu-usage.jpg share/doc/sqlite3/images/dan1.jpg @@ -603,6 +604,7 @@ share/doc/sqlite3/releaselog/3_1_5.html share/doc/sqlite3/releaselog/3_1_6.html share/doc/sqlite3/releaselog/3_20_0.html share/doc/sqlite3/releaselog/3_20_1.html +share/doc/sqlite3/releaselog/3_21_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.73 pkgsrc/databases/sqlite3-docs/distinfo:1.74 --- pkgsrc/databases/sqlite3-docs/distinfo:1.73 Fri Aug 25 05:27:53 2017 +++ pkgsrc/databases/sqlite3-docs/distinfo Mon Oct 30 18:36:13 2017 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.73 2017/08/25 05:27:53 adam Exp $ +$NetBSD: distinfo,v 1.74 2017/10/30 18:36:13 adam Exp $ -SHA1 (sqlite-doc-3200100.zip) = 9c2faf412173e51841d311e740d2061cad6544ad -RMD160 (sqlite-doc-3200100.zip) = 9ca1b91c37a4c7e9df7d3ca32dc9ccaf5ca88319 -SHA512 (sqlite-doc-3200100.zip) = 518ca59644cecfcd67f511268112e421c5d7bbd77ef1e33304bf306ef110becf1e2a7fe37c506ec6892edb9d5c6ee77657b374c2e061f49890d18af062dea2b3 -Size (sqlite-doc-3200100.zip) = 5759028 bytes +SHA1 (sqlite-doc-3210000.zip) = d919b648e128028d17c5435dc88f2f190f7d6a2e +RMD160 (sqlite-doc-3210000.zip) = 5993694cefcc94724300ba99c776b603894908f5 +SHA512 (sqlite-doc-3210000.zip) = 799c7279166b489d1a5acc9410808c2d4b78e64037fc15b60764180fe1c698f35e27e86793140302f560cfa583baa2c33e416d5c9e1842ec58c6cb6093729334 +Size (sqlite-doc-3210000.zip) = 5800635 bytes Index: pkgsrc/databases/sqlite3-tcl/Makefile diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.87 pkgsrc/databases/sqlite3-tcl/Makefile:1.88 --- pkgsrc/databases/sqlite3-tcl/Makefile:1.87 Mon Sep 18 09:53:15 2017 +++ pkgsrc/databases/sqlite3-tcl/Makefile Mon Oct 30 18:36:13 2017 @@ -1,6 +1,5 @@ -# $NetBSD: Makefile,v 1.87 2017/09/18 09:53:15 maya Exp $ +# $NetBSD: Makefile,v 1.88 2017/10/30 18:36:13 adam Exp $ -PKGREVISION= 1 .include "../../databases/sqlite3/Makefile.common" PKGNAME= sqlite3-tcl-${SQLITE3_VERSION} Index: pkgsrc/databases/sqlite3-tcl/distinfo diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.85 pkgsrc/databases/sqlite3-tcl/distinfo:1.86 --- pkgsrc/databases/sqlite3-tcl/distinfo:1.85 Fri Aug 25 05:27:53 2017 +++ pkgsrc/databases/sqlite3-tcl/distinfo Mon Oct 30 18:36:13 2017 @@ -1,7 +1,7 @@ -$NetBSD: distinfo,v 1.85 2017/08/25 05:27:53 adam Exp $ +$NetBSD: distinfo,v 1.86 2017/10/30 18:36:13 adam Exp $ -SHA1 (sqlite-autoconf-3200100.tar.gz) = 48593dcd19473f25fe6fcd08048e13ddbff4c983 -RMD160 (sqlite-autoconf-3200100.tar.gz) = 9e6f5367269bdeba47cce342be0cb428b1d6e169 -SHA512 (sqlite-autoconf-3200100.tar.gz) = 56e3d326ea2225cadc628c3518d46d9f7c4bafa0e3612f2b7ab0dc0d79fcbb7e095f6d84a9a48e1c6d83adcdc8706ad5ac4404f0f622c7fe38cfde3a7e7e69f0 -Size (sqlite-autoconf-3200100.tar.gz) = 2565638 bytes +SHA1 (sqlite-autoconf-3210000.tar.gz) = f56fe3407d8297fc0a68a058f4c9e6b77e83575c +RMD160 (sqlite-autoconf-3210000.tar.gz) = eff831c68562a4da921f38da2b29e16bc8904d1a +SHA512 (sqlite-autoconf-3210000.tar.gz) = 8f00708965eacef171620c49538f75768d350ec3f2bfef412a5c70af865ab03b6a64ce1e65d9fdb3d66f4d00262a30fc162b01fd69f63c05c14d5243374b6298 +Size (sqlite-autoconf-3210000.tar.gz) = 2568942 bytes SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 Index: pkgsrc/devel/lemon/distinfo diff -u pkgsrc/devel/lemon/distinfo:1.14 pkgsrc/devel/lemon/distinfo:1.15 --- pkgsrc/devel/lemon/distinfo:1.14 Fri Aug 25 05:27:53 2017 +++ pkgsrc/devel/lemon/distinfo Mon Oct 30 18:36:13 2017 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.14 2017/08/25 05:27:53 adam Exp $ +$NetBSD: distinfo,v 1.15 2017/10/30 18:36:13 adam Exp $ -SHA1 (sqlite-src-3200100.zip) = 808448837323b4ef9c0771af89d06dca5f0832dd -RMD160 (sqlite-src-3200100.zip) = 5260e6bcf35dc360a6dd31cec4792268feede6b7 -SHA512 (sqlite-src-3200100.zip) = 845a0d64c9356aadf178c04dd716bbd37a7353526b06cfa8e8f65653cf6a1893a5c5e8c78d20b43910c34d9167272cf517749c91ed0ba7686977e3d0327e8939 -Size (sqlite-src-3200100.zip) = 10575637 bytes +SHA1 (sqlite-src-3210000.zip) = 1892ebbac215095351a0ecc0c60a36e4d03104bc +RMD160 (sqlite-src-3210000.zip) = e6dacc512d897e2b35579e4258cccd3548c57bbc +SHA512 (sqlite-src-3210000.zip) = 3a054422da80d750fd5ab297f9d2728f4e7b55fa790a72d55da8c381835571992d56b349e50d4680b04c9e2e44d6fa83009c2df3ffa045f43ff9059bb8736894 +Size (sqlite-src-3210000.zip) = 10577695 bytes --_----------=_1509388573159400--