CVS commit: pkgsrc

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Sun Nov 28 20:48:29 UTC 2021

Modified Files:
        pkgsrc/databases/sqlite3: Makefile Makefile.common distinfo
        pkgsrc/databases/sqlite3-docs: PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: distinfo
        pkgsrc/devel/lemon: distinfo
Removed Files:
        pkgsrc/databases/sqlite3/patches: patch-shell.c

Log Message:
sqlite3: updated to 3.37.0

SQLite Release 3.37.0 On 2021-11-27

STRICT tables provide a prescriptive style of data type management, for developers who prefer that kind of thing.
When adding columns that contain a CHECK constraint or a generated column containing a NOT NULL constraint, the ALTER TABLE ADD COLUMN now checks new constraints against preexisting rows in the 
database and will only proceed if no constraints are violated.
Added the PRAGMA table_list statement.
CLI enhancements:
Add the .connection command, allowing the CLI to keep multiple database connections open at the same time.
Add the --safe command-line option that disables dot-commands and SQL statements that might cause side-effects that extend beyond the single database file named on the command-line.
Performance improvements when reading SQL statements that span many lines.
Added the sqlite3_autovacuum_pages() interface.
The sqlite3_deserialize() does not and has never worked for the TEMP database. That limitation is now noted in the documentation.
The query planner now omits ORDER BY clauses on subqueries and views if removing those clauses does not change the semantics of the query.
The generate_series table-valued function extension is modified so that the first parameter ("START") is now required. This is done as a way to demonstrate how to write table-valued functions with 
required parameters. The legacy behavior is available using the -DZERO_ARGUMENT_GENERATE_SERIES compile-time option.
Added new sqlite3_changes64() and sqlite3_total_changes64() interfaces.
Added the SQLITE_OPEN_EXRESCODE flag option to sqlite3_open_v2().
Use less memory to hold the database schema.


To generate a diff of this commit:
cvs rdiff -u -r1.142 -r1.143 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.81 -r1.82 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.174 -r1.175 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.104 -r1.105 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.107 -r1.108 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.119 -r1.120 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.1 -r0 pkgsrc/databases/sqlite3/patches/patch-shell.c
cvs rdiff -u -r1.48 -r1.49 pkgsrc/devel/lemon/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/sqlite3/Makefile
diff -u pkgsrc/databases/sqlite3/Makefile:1.142 pkgsrc/databases/sqlite3/Makefile:1.143
--- pkgsrc/databases/sqlite3/Makefile:1.142     Sun Oct 17 07:14:27 2021
+++ pkgsrc/databases/sqlite3/Makefile   Sun Nov 28 20:48:28 2021
@@ -1,10 +1,9 @@
-# $NetBSD: Makefile,v 1.142 2021/10/17 07:14:27 wiz Exp $
+# $NetBSD: Makefile,v 1.143 2021/11/28 20:48:28 adam Exp $
 
 .include "Makefile.common"
 
 DISTNAME=      sqlite-autoconf-${SQLITE3_DISTVERSION}
 PKGNAME=       sqlite3-${SQLITE3_VERSION}
-PKGREVISION=   1
 CATEGORIES=    databases
 
 MAINTAINER=    pkgsrc-users%NetBSD.org@localhost

Index: pkgsrc/databases/sqlite3/Makefile.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.81 pkgsrc/databases/sqlite3/Makefile.common:1.82
--- pkgsrc/databases/sqlite3/Makefile.common:1.81       Fri Jun 25 21:21:31 2021
+++ pkgsrc/databases/sqlite3/Makefile.common    Sun Nov 28 20:48:28 2021
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.81 2021/06/25 21:21:31 adam Exp $
+# $NetBSD: Makefile.common,v 1.82 2021/11/28 20:48:28 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=   3360000
-SQLITE3_VERSION=       3.36.0
+SQLITE3_DISTVERSION=   3370000
+SQLITE3_VERSION=       3.37.0
 
 MASTER_SITES=  http://www.sqlite.org/2021/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2021/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.174 pkgsrc/databases/sqlite3/distinfo:1.175
--- pkgsrc/databases/sqlite3/distinfo:1.174     Tue Oct 26 10:10:05 2021
+++ pkgsrc/databases/sqlite3/distinfo   Sun Nov 28 20:48:28 2021
@@ -1,7 +1,6 @@
-$NetBSD: distinfo,v 1.174 2021/10/26 10:10:05 nia Exp $
+$NetBSD: distinfo,v 1.175 2021/11/28 20:48:28 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3360000.tar.gz) = 41933bf3a5296420336e87d7b1a4acecc685f7433035c5c339de1545f25d5863
-SHA512 (sqlite-autoconf-3360000.tar.gz) = e59c57f421b4956c7759af528a2da929167e15179ab9d28267474683e2272f93c901203e5a648732f1a3d43e7be3ac4217c3cdd7adf108c378b9127b771a7cd0
-Size (sqlite-autoconf-3360000.tar.gz) = 2977080 bytes
+BLAKE2s (sqlite-autoconf-3370000.tar.gz) = df964e39d338c8a4ba4fecd8a0be9d1b8536867cd0b8e27ed168fc8c202200fb
+SHA512 (sqlite-autoconf-3370000.tar.gz) = 413655d7b61b4d0a510bc42eb2e4f3e801ff35dee7d825d84b8397c956f23c5eac6a1a73134d3d7a63e40704968a4607d5762a137557e688ec5f87efb5b729ea
+Size (sqlite-autoconf-3370000.tar.gz) = 3001298 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4
-SHA1 (patch-shell.c) = d20cddef6cf75753c78d95b7dd1ae928caba5df6

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.104 pkgsrc/databases/sqlite3-docs/PLIST:1.105
--- pkgsrc/databases/sqlite3-docs/PLIST:1.104   Fri Jun 25 21:21:31 2021
+++ pkgsrc/databases/sqlite3-docs/PLIST Sun Nov 28 20:48:28 2021
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.104 2021/06/25 21:21:31 adam Exp $
+@comment $NetBSD: PLIST,v 1.105 2021/11/28 20:48:28 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -20,6 +20,7 @@ share/doc/sqlite3/c3ref/aggregate_contex
 share/doc/sqlite3/c3ref/aggregate_count.html
 share/doc/sqlite3/c3ref/api_routines.html
 share/doc/sqlite3/c3ref/auto_extension.html
+share/doc/sqlite3/c3ref/autovacuum_pages.html
 share/doc/sqlite3/c3ref/backup.html
 share/doc/sqlite3/c3ref/backup_finish.html
 share/doc/sqlite3/c3ref/bind_blob.html
@@ -270,6 +271,7 @@ share/doc/sqlite3/features.html
 share/doc/sqlite3/fileformat.html
 share/doc/sqlite3/fileformat2.html
 share/doc/sqlite3/fileio.html
+share/doc/sqlite3/flextypegood.html
 share/doc/sqlite3/floatingpoint.html
 share/doc/sqlite3/footprint.html
 share/doc/sqlite3/foreignkeys.html
@@ -631,6 +633,7 @@ share/doc/sqlite3/releaselog/3_35_3.html
 share/doc/sqlite3/releaselog/3_35_4.html
 share/doc/sqlite3/releaselog/3_35_5.html
 share/doc/sqlite3/releaselog/3_36_0.html
+share/doc/sqlite3/releaselog/3_37_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
@@ -829,6 +832,7 @@ share/doc/sqlite3/sqlite.css
 share/doc/sqlite3/sqlite.css~
 share/doc/sqlite3/sqlite.html
 share/doc/sqlite3/stmt.html
+share/doc/sqlite3/stricttables.html
 share/doc/sqlite3/support.html
 share/doc/sqlite3/swarmvtab.html
 share/doc/sqlite3/syntax.html
@@ -892,6 +896,7 @@ share/doc/sqlite3/syntax/simple-select-s
 share/doc/sqlite3/syntax/sql-stmt-list.html
 share/doc/sqlite3/syntax/sql-stmt.html
 share/doc/sqlite3/syntax/table-constraint.html
+share/doc/sqlite3/syntax/table-options.html
 share/doc/sqlite3/syntax/table-or-subquery.html
 share/doc/sqlite3/syntax/type-name.html
 share/doc/sqlite3/syntax/update-stmt-limited.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.107 pkgsrc/databases/sqlite3-docs/distinfo:1.108
--- pkgsrc/databases/sqlite3-docs/distinfo:1.107        Tue Oct 26 10:10:05 2021
+++ pkgsrc/databases/sqlite3-docs/distinfo      Sun Nov 28 20:48:28 2021
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.107 2021/10/26 10:10:05 nia Exp $
+$NetBSD: distinfo,v 1.108 2021/11/28 20:48:28 adam Exp $
 
-BLAKE2s (sqlite-doc-3360000.zip) = 4bf60a58ed2f84cb9993fec9723875b6e67d15c230c2a6829a010355a22c4db4
-SHA512 (sqlite-doc-3360000.zip) = c9b5628f823c322688e2fcce0effe7564dccaf8bcdbb3397ee09c433975bfb5fd63fd81830c5c6d573314e1e55d25cdf1b3842d798f7be63b9b88b32f6694add
-Size (sqlite-doc-3360000.zip) = 12274411 bytes
+BLAKE2s (sqlite-doc-3370000.zip) = 805b096d27353253ddf402e7a3447ee58628bdfb4ca89a633683345a4cf10522
+SHA512 (sqlite-doc-3370000.zip) = f245731675c67347318578e773b8d5f548c26eac7a333d6028cf7e11c4c9d2c3314da0a5428533ff26416f4194dce5c805d7f61f1fef27e02e9b91efa3c6d4c7
+Size (sqlite-doc-3370000.zip) = 10509325 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.119 pkgsrc/databases/sqlite3-tcl/distinfo:1.120
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.119 Tue Oct 26 10:10:05 2021
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Sun Nov 28 20:48:29 2021
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.119 2021/10/26 10:10:05 nia Exp $
+$NetBSD: distinfo,v 1.120 2021/11/28 20:48:29 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3360000.tar.gz) = 41933bf3a5296420336e87d7b1a4acecc685f7433035c5c339de1545f25d5863
-SHA512 (sqlite-autoconf-3360000.tar.gz) = e59c57f421b4956c7759af528a2da929167e15179ab9d28267474683e2272f93c901203e5a648732f1a3d43e7be3ac4217c3cdd7adf108c378b9127b771a7cd0
-Size (sqlite-autoconf-3360000.tar.gz) = 2977080 bytes
+BLAKE2s (sqlite-autoconf-3370000.tar.gz) = df964e39d338c8a4ba4fecd8a0be9d1b8536867cd0b8e27ed168fc8c202200fb
+SHA512 (sqlite-autoconf-3370000.tar.gz) = 413655d7b61b4d0a510bc42eb2e4f3e801ff35dee7d825d84b8397c956f23c5eac6a1a73134d3d7a63e40704968a4607d5762a137557e688ec5f87efb5b729ea
+Size (sqlite-autoconf-3370000.tar.gz) = 3001298 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.48 pkgsrc/devel/lemon/distinfo:1.49
--- pkgsrc/devel/lemon/distinfo:1.48    Tue Oct 26 10:15:13 2021
+++ pkgsrc/devel/lemon/distinfo Sun Nov 28 20:48:29 2021
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.48 2021/10/26 10:15:13 nia Exp $
+$NetBSD: distinfo,v 1.49 2021/11/28 20:48:29 adam Exp $
 
-BLAKE2s (sqlite-src-3360000.zip) = 9a7d289fd601660861657b5b5b5131a8f7409bb1b894056275154079d976890e
-SHA512 (sqlite-src-3360000.zip) = 4083f96265c59001d21dce4d0288ddc6ea80ae079cbce2144c0fc3200b1904fd0d665fc54b08978c6b818527580042cde025c03b73d20d0bc56ccbeb75a330c3
-Size (sqlite-src-3360000.zip) = 12985683 bytes
+BLAKE2s (sqlite-src-3370000.zip) = 0925ae0bdd00ab5371f9145510a2cc0a5dc3a6596b7bfbfc4ff729569762448f
+SHA512 (sqlite-src-3370000.zip) = 5a3c358c42782bc248a0795ca78a10d834861f98ab0a021a05d8358ba1716f3febb3da29ded187dfd205902f77bbf284ed3207aabe4979b68b90d0557d1676f7
+Size (sqlite-src-3370000.zip) = 13141152 bytes