CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed Aug 19 05:48:37 UTC 2020

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.33.0

SQLite Release 3.33.0

Support for UPDATE FROM following the PostgreSQL syntax.
Increase the maximum size of database files to 281 TB.
Extended the PRAGMA integrity_check statement so that it can optionally be limited to verifying just a single table and its indexes, rather than the entire database file.
Added the decimal extension for doing arbitrary-precision decimal arithmetic.
Enhancements to the ieee754 extension for working with IEEE 754 binary64 numbers.
CLI enhancements:
Added four new output modes: "box", "json", "markdown", and "table".
The "column" output mode automatically expands columns to contain the longest output row and automatically turns ".header" on if it has not been previously set.
The "quote" output mode honors ".separator"
The decimal extension and the ieee754 extension are built-in to the CLI
Query planner improvements:
Add the ability to find a full-index-scan query plan for queries using INDEXED BY which previously would fail with "no query solution".
Do a better job of detecting missing, incomplete, and/or dodgy sqlite_stat1 data and generates good query plans in spite of the misinformation.
Improved performance of queries like "SELECT min(x) FROM t WHERE y IN (?,?,?)" assuming an index on t(x,y).
In WAL mode, if a writer crashes and leaves the shm file in an inconsistent state, subsequent transactions are now able to recover the shm file even if there are active read transactions. Before this 
enhancement, shm file recovery that scenario would result in an SQLITE_PROTOCOL error.


To generate a diff of this commit:
cvs rdiff -u -r1.71 -r1.72 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.160 -r1.161 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.94 -r1.95 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.95 -r1.96 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.107 -r1.108 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.36 -r1.37 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.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.71 pkgsrc/databases/sqlite3/Makefile.common:1.72
--- pkgsrc/databases/sqlite3/Makefile.common:1.71       Fri Jun 19 07:31:08 2020
+++ pkgsrc/databases/sqlite3/Makefile.common    Wed Aug 19 05:48:37 2020
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.71 2020/06/19 07:31:08 adam Exp $
+# $NetBSD: Makefile.common,v 1.72 2020/08/19 05:48:37 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=   3320300
-SQLITE3_VERSION=       3.32.3
+SQLITE3_DISTVERSION=   3330000
+SQLITE3_VERSION=       3.33.0
 
 MASTER_SITES=  http://www.sqlite.org/2020/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2020/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.160 pkgsrc/databases/sqlite3/distinfo:1.161
--- pkgsrc/databases/sqlite3/distinfo:1.160     Fri Jun 19 07:31:08 2020
+++ pkgsrc/databases/sqlite3/distinfo   Wed Aug 19 05:48:37 2020
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.160 2020/06/19 07:31:08 adam Exp $
+$NetBSD: distinfo,v 1.161 2020/08/19 05:48:37 adam Exp $
 
-SHA1 (sqlite-autoconf-3320300.tar.gz) = ea14ef2dc4cc7fcbc5ebbb018d3a03faa3a41cb4
-RMD160 (sqlite-autoconf-3320300.tar.gz) = c73ebf70fd40f33af6f2987c48a5fc587f0eac73
-SHA512 (sqlite-autoconf-3320300.tar.gz) = add0ef47c059be0a75add7ab4fe52b2fbd4060cacbf1cbb93f1b4007cdeb8fc92256b1aadc224c4839e733fb868e56d9d73dd33c56a6f66180d1ff001d8d275e
-Size (sqlite-autoconf-3320300.tar.gz) = 2904404 bytes
+SHA1 (sqlite-autoconf-3330000.tar.gz) = d63f3ce52cb295d62d09fc2ad8f2d29c35e1645f
+RMD160 (sqlite-autoconf-3330000.tar.gz) = ee7e02714f9c1b70eac1eb7256d2010a939cb1dd
+SHA512 (sqlite-autoconf-3330000.tar.gz) = c0d79d4012a01f12128ab5044b887576a130663245b85befcc0ab82ad3a315dd1e7f54b6301f842410c9c21b73237432c44a1d7c2fe0e0709435fec1f1a20a11
+Size (sqlite-autoconf-3330000.tar.gz) = 2913759 bytes

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.94 pkgsrc/databases/sqlite3-docs/PLIST:1.95
--- pkgsrc/databases/sqlite3-docs/PLIST:1.94    Fri Jun 19 07:31:08 2020
+++ pkgsrc/databases/sqlite3-docs/PLIST Wed Aug 19 05:48:37 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.94 2020/06/19 07:31:08 adam Exp $
+@comment $NetBSD: PLIST,v 1.95 2020/08/19 05:48:37 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -268,6 +268,7 @@ share/doc/sqlite3/features.html
 share/doc/sqlite3/fileformat.html
 share/doc/sqlite3/fileformat2.html
 share/doc/sqlite3/fileio.html
+share/doc/sqlite3/floatingpoint.html
 share/doc/sqlite3/footprint.html
 share/doc/sqlite3/foreignkeys.html
 share/doc/sqlite3/formatchng.html
@@ -688,6 +689,7 @@ share/doc/sqlite3/releaselog/3_32_0.html
 share/doc/sqlite3/releaselog/3_32_1.html
 share/doc/sqlite3/releaselog/3_32_2.html
 share/doc/sqlite3/releaselog/3_32_3.html
+share/doc/sqlite3/releaselog/3_33_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
@@ -817,6 +819,7 @@ share/doc/sqlite3/robots.txt
 share/doc/sqlite3/rowidtable.html
 share/doc/sqlite3/rowvalue.html
 share/doc/sqlite3/rtree.html
+share/doc/sqlite3/schematab.html
 share/doc/sqlite3/search
 share/doc/sqlite3/search.d/admin
 share/doc/sqlite3/search.d/search.db

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.95 pkgsrc/databases/sqlite3-docs/distinfo:1.96
--- pkgsrc/databases/sqlite3-docs/distinfo:1.95 Fri Jun 19 07:31:08 2020
+++ pkgsrc/databases/sqlite3-docs/distinfo      Wed Aug 19 05:48:37 2020
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.95 2020/06/19 07:31:08 adam Exp $
+$NetBSD: distinfo,v 1.96 2020/08/19 05:48:37 adam Exp $
 
-SHA1 (sqlite-doc-3320300.zip) = 10b845972f6fe834300d1162ef47ce419a4a5d55
-RMD160 (sqlite-doc-3320300.zip) = e0ebc34f47752a4238892a8fbbc1ad9ec7bcdea0
-SHA512 (sqlite-doc-3320300.zip) = af9dca970b4c03c058d7d1cd55a3d11fa4b112dccac942b8660d82a7e9ba2956963fcb429eedfdc85915637c102e1f904ace98c8e0455c4120422bbd9f2f3cd0
-Size (sqlite-doc-3320300.zip) = 9772933 bytes
+SHA1 (sqlite-doc-3330000.zip) = 424facd5414f3e956ba0d0141f8ae88a652b58c2
+RMD160 (sqlite-doc-3330000.zip) = 521841f68ca44c34657ccd3c8955f637d01d2c62
+SHA512 (sqlite-doc-3330000.zip) = 14a3cccb4ff6af57738990eeadd37a1b827f89c9c1b16201c62ca5bb9301d39223d48677b9c269ce332210e5c9ae3f42aa0f9de7d79b38acb9809c732d038368
+Size (sqlite-doc-3330000.zip) = 9834159 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.107 pkgsrc/databases/sqlite3-tcl/distinfo:1.108
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.107 Fri Jun 19 07:31:08 2020
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Wed Aug 19 05:48:37 2020
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.107 2020/06/19 07:31:08 adam Exp $
+$NetBSD: distinfo,v 1.108 2020/08/19 05:48:37 adam Exp $
 
-SHA1 (sqlite-autoconf-3320300.tar.gz) = ea14ef2dc4cc7fcbc5ebbb018d3a03faa3a41cb4
-RMD160 (sqlite-autoconf-3320300.tar.gz) = c73ebf70fd40f33af6f2987c48a5fc587f0eac73
-SHA512 (sqlite-autoconf-3320300.tar.gz) = add0ef47c059be0a75add7ab4fe52b2fbd4060cacbf1cbb93f1b4007cdeb8fc92256b1aadc224c4839e733fb868e56d9d73dd33c56a6f66180d1ff001d8d275e
-Size (sqlite-autoconf-3320300.tar.gz) = 2904404 bytes
+SHA1 (sqlite-autoconf-3330000.tar.gz) = d63f3ce52cb295d62d09fc2ad8f2d29c35e1645f
+RMD160 (sqlite-autoconf-3330000.tar.gz) = ee7e02714f9c1b70eac1eb7256d2010a939cb1dd
+SHA512 (sqlite-autoconf-3330000.tar.gz) = c0d79d4012a01f12128ab5044b887576a130663245b85befcc0ab82ad3a315dd1e7f54b6301f842410c9c21b73237432c44a1d7c2fe0e0709435fec1f1a20a11
+Size (sqlite-autoconf-3330000.tar.gz) = 2913759 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.36 pkgsrc/devel/lemon/distinfo:1.37
--- pkgsrc/devel/lemon/distinfo:1.36    Fri Jun 19 07:31:08 2020
+++ pkgsrc/devel/lemon/distinfo Wed Aug 19 05:48:37 2020
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.36 2020/06/19 07:31:08 adam Exp $
+$NetBSD: distinfo,v 1.37 2020/08/19 05:48:37 adam Exp $
 
-SHA1 (sqlite-src-3320300.zip) = d46f60e0fb2b1a959ae59bfa881fc95a510c4d21
-RMD160 (sqlite-src-3320300.zip) = 2e5276cef9b5b814772f50e6ddf95896d0813611
-SHA512 (sqlite-src-3320300.zip) = 7e027c7163a760fb9b6dbfd2e4ccffb39d4972280583fb0d7f8390017101dfed3b12a36653b3130a548ae4d04c6abb11c0a1921b6f09c54c6ae1e72fbdcb2fd4
-Size (sqlite-src-3320300.zip) = 12461750 bytes
+SHA1 (sqlite-src-3330000.zip) = 8b7a80225ac6fe8c355a6f5e44fc4589a8d91f18
+RMD160 (sqlite-src-3330000.zip) = d6104c5ed3b7cdf0273e56076a1ce72f68a8e16d
+SHA512 (sqlite-src-3330000.zip) = 3260e3e03ee2f6a4ff2bc4ea4bada5a1497afeca33878c155a8005824970c6c1eb8a2db58eb3023cab084af475fadb81d1c3c9892ae92c07f884881e6602e173
+Size (sqlite-src-3330000.zip) = 12591089 bytes