Received: from mail.netbsd.org (mail.netbsd.org [199.233.217.200]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) (Client CN "mail.NetBSD.org", Issuer "mail.NetBSD.org CA" (not verified)) by mollari.NetBSD.org (Postfix) with ESMTPS id F31FB1A9239 for ; Wed, 23 Feb 2022 17:07:39 +0000 (UTC) Received: by mail.netbsd.org (Postfix, from userid 605) id 3198884E55; Wed, 23 Feb 2022 17:07:39 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id 6A9DE84D44 for ; Wed, 23 Feb 2022 17:07:38 +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 qGnMpKMZHw77 for ; Wed, 23 Feb 2022 17:07:37 +0000 (UTC) Received: from cvs.NetBSD.org (ivanova.netbsd.org [199.233.217.197]) by mail.netbsd.org (Postfix) with ESMTP id 6A43184CDF for ; Wed, 23 Feb 2022 17:07:37 +0000 (UTC) Received: by cvs.NetBSD.org (Postfix, from userid 500) id 62295FB24; Wed, 23 Feb 2022 17:07:37 +0000 (UTC) Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_164563605747220" MIME-Version: 1.0 Date: Wed, 23 Feb 2022 17:07:37 +0000 From: "Adam Ciarcinski" Subject: CVS commit: pkgsrc To: pkgsrc-changes@NetBSD.org Reply-To: adam@netbsd.org X-Mailer: log_accum Message-Id: <20220223170737.62295FB24@cvs.NetBSD.org> Sender: pkgsrc-changes-owner@NetBSD.org List-Id: Precedence: bulk List-Unsubscribe: This is a multi-part message in MIME format. --_----------=_164563605747220 Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="US-ASCII" Module Name: pkgsrc Committed By: adam Date: Wed Feb 23 17:07:37 UTC 2022 Modified Files: pkgsrc/databases/sqlite3: Makefile.common distinfo pkgsrc/databases/sqlite3-docs: PLIST distinfo pkgsrc/databases/sqlite3-tcl: distinfo pkgsrc/devel/lemon: distinfo Log Message: sqlite3: updated to 3.38.0 SQLite Release 3.38.0 On 2022-02-22 Added the -> and ->> operators for easier processing of JSON. The new operators are compatible with MySQL and PostgreSQL. The JSON functions are now built-ins. It is no longer necessary to use the -DSQLITE_ENABLE_JSON1 compile-time option to enable JSON support. JSON is on by default. Disable the JSON interface using the new -DSQLITE_OMIT_JSON compile-time option. Enhancements to date and time functions: Added the unixepoch() function. Added the auto modifier and the julianday modifier. Rename the printf() SQL function to format() for better compatibility. The original printf() name is retained as an alias for backwards compatibility. Added the sqlite3_error_offset() interface, which can sometimes help to localize an SQL error to a specific character in the input SQL text, so that applications can provide better error messages. Enhanced the interface to virtual tables as follows: Added the sqlite3_vtab_distinct() interface. Added the sqlite3_vtab_rhs_value() interface. Added new operator types SQLITE_INDEX_CONSTRAINT_LIMIT and SQLITE_INDEX_CONSTRAINT_OFFSET. Added the sqlite3_vtab_in() interface (and related) to enable a virtual table to process IN operator constraints all at once, rather than processing each value of the right-hand side of the IN operator separately. CLI enhancements: Columnar output modes are enhanced to correctly handle tabs and newlines embedded in text. Added options like "--wrap N", "--wordwrap on", and "--quote" to the columnar output modes. Added the .mode qbox alias. The .import command automatically disambiguates column names. Use the new sqlite3_error_offset() interface to provide better error messages. Query planner enhancements: Use a Bloom filter to speed up large analytic queries. Use a balanced merge tree to evaluate UNION or UNION ALL compound SELECT statements that have an ORDER BY clause. The ALTER TABLE statement is changed to silently ignores entries in the sqlite_schema table that do not parse when PRAGMA writable_schema=ON. To generate a diff of this commit: cvs rdiff -u -r1.84 -r1.85 pkgsrc/databases/sqlite3/Makefile.common cvs rdiff -u -r1.177 -r1.178 pkgsrc/databases/sqlite3/distinfo cvs rdiff -u -r1.107 -r1.108 pkgsrc/databases/sqlite3-docs/PLIST cvs rdiff -u -r1.110 -r1.111 pkgsrc/databases/sqlite3-docs/distinfo cvs rdiff -u -r1.122 -r1.123 pkgsrc/databases/sqlite3-tcl/distinfo cvs rdiff -u -r1.51 -r1.52 pkgsrc/devel/lemon/distinfo Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files. --_----------=_164563605747220 Content-Disposition: inline Content-Length: 6604 Content-Transfer-Encoding: binary Content-Type: text/x-diff; charset=us-ascii Modified files: Index: pkgsrc/databases/sqlite3/Makefile.common diff -u pkgsrc/databases/sqlite3/Makefile.common:1.84 pkgsrc/databases/sqlite3/Makefile.common:1.85 --- pkgsrc/databases/sqlite3/Makefile.common:1.84 Fri Jan 7 21:06:28 2022 +++ pkgsrc/databases/sqlite3/Makefile.common Wed Feb 23 17:07:36 2022 @@ -1,12 +1,12 @@ -# $NetBSD: Makefile.common,v 1.84 2022/01/07 21:06:28 adam Exp $ +# $NetBSD: Makefile.common,v 1.85 2022/02/23 17:07:36 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= 3370200 -SQLITE3_VERSION= 3.37.2 +SQLITE3_DISTVERSION= 3380000 +SQLITE3_VERSION= 3.38.0 MASTER_SITES= http://www.sqlite.org/2022/ MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/ Index: pkgsrc/databases/sqlite3/distinfo diff -u pkgsrc/databases/sqlite3/distinfo:1.177 pkgsrc/databases/sqlite3/distinfo:1.178 --- pkgsrc/databases/sqlite3/distinfo:1.177 Fri Jan 7 21:06:28 2022 +++ pkgsrc/databases/sqlite3/distinfo Wed Feb 23 17:07:36 2022 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.177 2022/01/07 21:06:28 adam Exp $ +$NetBSD: distinfo,v 1.178 2022/02/23 17:07:36 adam Exp $ -BLAKE2s (sqlite-autoconf-3370200.tar.gz) = 02e087a45653742a3a3e949f3a617eb5f54300ada84e075a910a262a8575cf32 -SHA512 (sqlite-autoconf-3370200.tar.gz) = d41049ce4a2007c57f81c54b1cdc3f812abbfafd40736134604392ab16d2d4c29e40f4b927f1deb133b128a869cfdb3434c8640ec227bc4a5da1686024f65d4e -Size (sqlite-autoconf-3370200.tar.gz) = 3001797 bytes +BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c +SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28 +Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 Index: pkgsrc/databases/sqlite3-docs/PLIST diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.107 pkgsrc/databases/sqlite3-docs/PLIST:1.108 --- pkgsrc/databases/sqlite3-docs/PLIST:1.107 Fri Jan 7 21:06:28 2022 +++ pkgsrc/databases/sqlite3-docs/PLIST Wed Feb 23 17:07:36 2022 @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.107 2022/01/07 21:06:28 adam Exp $ +@comment $NetBSD: PLIST,v 1.108 2022/02/23 17:07:36 adam Exp $ share/doc/sqlite3/34to35.html share/doc/sqlite3/35to36.html share/doc/sqlite3/about.html @@ -213,8 +213,12 @@ share/doc/sqlite3/c3ref/vtab.html share/doc/sqlite3/c3ref/vtab_collation.html share/doc/sqlite3/c3ref/vtab_config.html share/doc/sqlite3/c3ref/vtab_cursor.html +share/doc/sqlite3/c3ref/vtab_distinct.html +share/doc/sqlite3/c3ref/vtab_in.html +share/doc/sqlite3/c3ref/vtab_in_first.html share/doc/sqlite3/c3ref/vtab_nochange.html share/doc/sqlite3/c3ref/vtab_on_conflict.html +share/doc/sqlite3/c3ref/vtab_rhs_value.html share/doc/sqlite3/c3ref/wal_autocheckpoint.html share/doc/sqlite3/c3ref/wal_checkpoint.html share/doc/sqlite3/c3ref/wal_checkpoint_v2.html @@ -637,6 +641,7 @@ share/doc/sqlite3/releaselog/3_36_0.html share/doc/sqlite3/releaselog/3_37_0.html share/doc/sqlite3/releaselog/3_37_1.html share/doc/sqlite3/releaselog/3_37_2.html +share/doc/sqlite3/releaselog/3_38_0.html share/doc/sqlite3/releaselog/3_3_0.html share/doc/sqlite3/releaselog/3_3_1.html share/doc/sqlite3/releaselog/3_3_10.html Index: pkgsrc/databases/sqlite3-docs/distinfo diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.110 pkgsrc/databases/sqlite3-docs/distinfo:1.111 --- pkgsrc/databases/sqlite3-docs/distinfo:1.110 Fri Jan 7 21:06:28 2022 +++ pkgsrc/databases/sqlite3-docs/distinfo Wed Feb 23 17:07:36 2022 @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.110 2022/01/07 21:06:28 adam Exp $ +$NetBSD: distinfo,v 1.111 2022/02/23 17:07:36 adam Exp $ -BLAKE2s (sqlite-doc-3370200.zip) = 1e2232c02989f511a9809b02702dc9af71884d956f1a60ef1d0cb99da89a7cc4 -SHA512 (sqlite-doc-3370200.zip) = 02c68a3906aee3fd05a4340549144032a239e5ab885d9b3b09236ed2b74a90c770de373e4ca9f99e72f92df090d0fb6789213fb361e954d9dd6709af20336857 -Size (sqlite-doc-3370200.zip) = 10542395 bytes +BLAKE2s (sqlite-doc-3380000.zip) = 86d1732125b456fdfb4b86131ff4b2ac27aec58eef4a31044b2167ef24aaa9b7 +SHA512 (sqlite-doc-3380000.zip) = 8e1f77504a1057cd23a8a6c2a285d63c5df50ceaf6ab84054a6f5422286dd868bdb3d5bd9be180b7834caba2b65ca185ffff60455bb504df30801157b62a62ef +Size (sqlite-doc-3380000.zip) = 10603776 bytes Index: pkgsrc/databases/sqlite3-tcl/distinfo diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.122 pkgsrc/databases/sqlite3-tcl/distinfo:1.123 --- pkgsrc/databases/sqlite3-tcl/distinfo:1.122 Fri Jan 7 21:06:28 2022 +++ pkgsrc/databases/sqlite3-tcl/distinfo Wed Feb 23 17:07:37 2022 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.122 2022/01/07 21:06:28 adam Exp $ +$NetBSD: distinfo,v 1.123 2022/02/23 17:07:37 adam Exp $ -BLAKE2s (sqlite-autoconf-3370200.tar.gz) = 02e087a45653742a3a3e949f3a617eb5f54300ada84e075a910a262a8575cf32 -SHA512 (sqlite-autoconf-3370200.tar.gz) = d41049ce4a2007c57f81c54b1cdc3f812abbfafd40736134604392ab16d2d4c29e40f4b927f1deb133b128a869cfdb3434c8640ec227bc4a5da1686024f65d4e -Size (sqlite-autoconf-3370200.tar.gz) = 3001797 bytes +BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c +SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28 +Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 Index: pkgsrc/devel/lemon/distinfo diff -u pkgsrc/devel/lemon/distinfo:1.51 pkgsrc/devel/lemon/distinfo:1.52 --- pkgsrc/devel/lemon/distinfo:1.51 Fri Jan 7 21:06:28 2022 +++ pkgsrc/devel/lemon/distinfo Wed Feb 23 17:07:37 2022 @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.51 2022/01/07 21:06:28 adam Exp $ +$NetBSD: distinfo,v 1.52 2022/02/23 17:07:37 adam Exp $ -BLAKE2s (sqlite-src-3370200.zip) = bebcb8c5cfd84f8b39edc09b8b999d36a8341d4d6856ba8cd851bc9d6daf4d12 -SHA512 (sqlite-src-3370200.zip) = 2db103965934bb34c8336cf82ff7d77e75dc1ca00fa6324ac5697f3bf4b41bffff355dec7593515a68816449e5c9827a9503f6d7841c4c13981c231d3414ff76 -Size (sqlite-src-3370200.zip) = 13145234 bytes +BLAKE2s (sqlite-src-3380000.zip) = 1239ff74cd5245e1f5180438a595a0ee68b17c277b8877ca3b6acf87afc5da80 +SHA512 (sqlite-src-3380000.zip) = 9f4d3c406df5e6290f3f0b5e24b568723ab54bb085cb8cd7621ab42b0b8cd4f76e9784a4a29b42ea8cb0d1b7d759267c3cd980913d490d08e7172df05949131d +Size (sqlite-src-3380000.zip) = 13236840 bytes --_----------=_164563605747220--