Wed Aug 19 05:48:37 2020 UTC ()
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.


(adam)
diff -r1.71 -r1.72 pkgsrc/databases/sqlite3/Makefile.common
diff -r1.160 -r1.161 pkgsrc/databases/sqlite3/distinfo
diff -r1.94 -r1.95 pkgsrc/databases/sqlite3-docs/PLIST
diff -r1.95 -r1.96 pkgsrc/databases/sqlite3-docs/distinfo
diff -r1.107 -r1.108 pkgsrc/databases/sqlite3-tcl/distinfo
diff -r1.36 -r1.37 pkgsrc/devel/lemon/distinfo

cvs diff -r1.71 -r1.72 pkgsrc/databases/sqlite3/Makefile.common (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/Makefile.common 2020/06/19 07:31:08 1.71
+++ pkgsrc/databases/sqlite3/Makefile.common 2020/08/19 05:48:37 1.72
@@ -1,15 +1,15 @@ @@ -1,15 +1,15 @@
1# $NetBSD: Makefile.common,v 1.71 2020/06/19 07:31:08 adam Exp $ 1# $NetBSD: Makefile.common,v 1.72 2020/08/19 05:48:37 adam Exp $
2# 2#
3# used by databases/sqlite3/Makefile 3# used by databases/sqlite3/Makefile
4# used by databases/sqlite3-docs/Makefile 4# used by databases/sqlite3-docs/Makefile
5# used by databases/sqlite3-tcl/Makefile 5# used by databases/sqlite3-tcl/Makefile
6# used by devel/lemon/Makefile 6# used by devel/lemon/Makefile
7 7
8SQLITE3_DISTVERSION= 3320300 8SQLITE3_DISTVERSION= 3330000
9SQLITE3_VERSION= 3.32.3 9SQLITE3_VERSION= 3.33.0
10 10
11MASTER_SITES= http://www.sqlite.org/2020/ 11MASTER_SITES= http://www.sqlite.org/2020/
12MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2020/ 12MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2020/
13 13
14HOMEPAGE?= http://www.sqlite.org/ 14HOMEPAGE?= http://www.sqlite.org/
15LICENSE= public-domain 15LICENSE= public-domain

cvs diff -r1.160 -r1.161 pkgsrc/databases/sqlite3/distinfo (expand / switch to unified diff)

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

cvs diff -r1.94 -r1.95 pkgsrc/databases/sqlite3-docs/PLIST (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-docs/PLIST 2020/06/19 07:31:08 1.94
+++ pkgsrc/databases/sqlite3-docs/PLIST 2020/08/19 05:48:37 1.95
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.94 2020/06/19 07:31:08 adam Exp $ 1@comment $NetBSD: PLIST,v 1.95 2020/08/19 05:48:37 adam Exp $
2share/doc/sqlite3/34to35.html 2share/doc/sqlite3/34to35.html
3share/doc/sqlite3/35to36.html 3share/doc/sqlite3/35to36.html
4share/doc/sqlite3/about.html 4share/doc/sqlite3/about.html
5share/doc/sqlite3/aff_short.html 5share/doc/sqlite3/aff_short.html
6share/doc/sqlite3/affcase1.html 6share/doc/sqlite3/affcase1.html
7share/doc/sqlite3/amalgamation.html 7share/doc/sqlite3/amalgamation.html
8share/doc/sqlite3/appfileformat.html 8share/doc/sqlite3/appfileformat.html
9share/doc/sqlite3/appfunc.html 9share/doc/sqlite3/appfunc.html
10share/doc/sqlite3/arch.html 10share/doc/sqlite3/arch.html
11share/doc/sqlite3/assert.html 11share/doc/sqlite3/assert.html
12share/doc/sqlite3/asyncvfs.html 12share/doc/sqlite3/asyncvfs.html
13share/doc/sqlite3/atomiccommit.html 13share/doc/sqlite3/atomiccommit.html
14share/doc/sqlite3/autoinc.html 14share/doc/sqlite3/autoinc.html
@@ -258,26 +258,27 @@ share/doc/sqlite3/doclist.html @@ -258,26 +258,27 @@ share/doc/sqlite3/doclist.html
258share/doc/sqlite3/docs.html 258share/doc/sqlite3/docs.html
259share/doc/sqlite3/download.html 259share/doc/sqlite3/download.html
260share/doc/sqlite3/eqp.html 260share/doc/sqlite3/eqp.html
261share/doc/sqlite3/errlog.html 261share/doc/sqlite3/errlog.html
262share/doc/sqlite3/expridx.html 262share/doc/sqlite3/expridx.html
263share/doc/sqlite3/famous.html 263share/doc/sqlite3/famous.html
264share/doc/sqlite3/faq.html 264share/doc/sqlite3/faq.html
265share/doc/sqlite3/fasterthanfs.html 265share/doc/sqlite3/fasterthanfs.html
266share/doc/sqlite3/favicon.ico 266share/doc/sqlite3/favicon.ico
267share/doc/sqlite3/features.html 267share/doc/sqlite3/features.html
268share/doc/sqlite3/fileformat.html 268share/doc/sqlite3/fileformat.html
269share/doc/sqlite3/fileformat2.html 269share/doc/sqlite3/fileformat2.html
270share/doc/sqlite3/fileio.html 270share/doc/sqlite3/fileio.html
 271share/doc/sqlite3/floatingpoint.html
271share/doc/sqlite3/footprint.html 272share/doc/sqlite3/footprint.html
272share/doc/sqlite3/foreignkeys.html 273share/doc/sqlite3/foreignkeys.html
273share/doc/sqlite3/formatchng.html 274share/doc/sqlite3/formatchng.html
274share/doc/sqlite3/fts3.html 275share/doc/sqlite3/fts3.html
275share/doc/sqlite3/fts5.html 276share/doc/sqlite3/fts5.html
276share/doc/sqlite3/fullsql.html 277share/doc/sqlite3/fullsql.html
277share/doc/sqlite3/gencol.html 278share/doc/sqlite3/gencol.html
278share/doc/sqlite3/geopoly.html 279share/doc/sqlite3/geopoly.html
279share/doc/sqlite3/getthecode.html 280share/doc/sqlite3/getthecode.html
280share/doc/sqlite3/hirely.html 281share/doc/sqlite3/hirely.html
281share/doc/sqlite3/howitworks.html 282share/doc/sqlite3/howitworks.html
282share/doc/sqlite3/howtocompile.html 283share/doc/sqlite3/howtocompile.html
283share/doc/sqlite3/howtocorrupt.html 284share/doc/sqlite3/howtocorrupt.html
@@ -678,26 +679,27 @@ share/doc/sqlite3/releaselog/3_2_3.html @@ -678,26 +679,27 @@ share/doc/sqlite3/releaselog/3_2_3.html
678share/doc/sqlite3/releaselog/3_2_4.html 679share/doc/sqlite3/releaselog/3_2_4.html
679share/doc/sqlite3/releaselog/3_2_5.html 680share/doc/sqlite3/releaselog/3_2_5.html
680share/doc/sqlite3/releaselog/3_2_6.html 681share/doc/sqlite3/releaselog/3_2_6.html
681share/doc/sqlite3/releaselog/3_2_7.html 682share/doc/sqlite3/releaselog/3_2_7.html
682share/doc/sqlite3/releaselog/3_2_8.html 683share/doc/sqlite3/releaselog/3_2_8.html
683share/doc/sqlite3/releaselog/3_30_0.html 684share/doc/sqlite3/releaselog/3_30_0.html
684share/doc/sqlite3/releaselog/3_30_1.html 685share/doc/sqlite3/releaselog/3_30_1.html
685share/doc/sqlite3/releaselog/3_31_0.html 686share/doc/sqlite3/releaselog/3_31_0.html
686share/doc/sqlite3/releaselog/3_31_1.html 687share/doc/sqlite3/releaselog/3_31_1.html
687share/doc/sqlite3/releaselog/3_32_0.html 688share/doc/sqlite3/releaselog/3_32_0.html
688share/doc/sqlite3/releaselog/3_32_1.html 689share/doc/sqlite3/releaselog/3_32_1.html
689share/doc/sqlite3/releaselog/3_32_2.html 690share/doc/sqlite3/releaselog/3_32_2.html
690share/doc/sqlite3/releaselog/3_32_3.html 691share/doc/sqlite3/releaselog/3_32_3.html
 692share/doc/sqlite3/releaselog/3_33_0.html
691share/doc/sqlite3/releaselog/3_3_0.html 693share/doc/sqlite3/releaselog/3_3_0.html
692share/doc/sqlite3/releaselog/3_3_1.html 694share/doc/sqlite3/releaselog/3_3_1.html
693share/doc/sqlite3/releaselog/3_3_10.html 695share/doc/sqlite3/releaselog/3_3_10.html
694share/doc/sqlite3/releaselog/3_3_11.html 696share/doc/sqlite3/releaselog/3_3_11.html
695share/doc/sqlite3/releaselog/3_3_12.html 697share/doc/sqlite3/releaselog/3_3_12.html
696share/doc/sqlite3/releaselog/3_3_13.html 698share/doc/sqlite3/releaselog/3_3_13.html
697share/doc/sqlite3/releaselog/3_3_14.html 699share/doc/sqlite3/releaselog/3_3_14.html
698share/doc/sqlite3/releaselog/3_3_15.html 700share/doc/sqlite3/releaselog/3_3_15.html
699share/doc/sqlite3/releaselog/3_3_16.html 701share/doc/sqlite3/releaselog/3_3_16.html
700share/doc/sqlite3/releaselog/3_3_17.html 702share/doc/sqlite3/releaselog/3_3_17.html
701share/doc/sqlite3/releaselog/3_3_2.html 703share/doc/sqlite3/releaselog/3_3_2.html
702share/doc/sqlite3/releaselog/3_3_3.html 704share/doc/sqlite3/releaselog/3_3_3.html
703share/doc/sqlite3/releaselog/3_3_4.html 705share/doc/sqlite3/releaselog/3_3_4.html
@@ -807,26 +809,27 @@ share/doc/sqlite3/releaselog/3_8_8_2.htm @@ -807,26 +809,27 @@ share/doc/sqlite3/releaselog/3_8_8_2.htm
807share/doc/sqlite3/releaselog/3_8_8_3.html 809share/doc/sqlite3/releaselog/3_8_8_3.html
808share/doc/sqlite3/releaselog/3_8_9.html 810share/doc/sqlite3/releaselog/3_8_9.html
809share/doc/sqlite3/releaselog/3_9_0.html 811share/doc/sqlite3/releaselog/3_9_0.html
810share/doc/sqlite3/releaselog/3_9_1.html 812share/doc/sqlite3/releaselog/3_9_1.html
811share/doc/sqlite3/releaselog/3_9_2.html 813share/doc/sqlite3/releaselog/3_9_2.html
812share/doc/sqlite3/releaselog/3_9_3.html 814share/doc/sqlite3/releaselog/3_9_3.html
813share/doc/sqlite3/releaselog/current.html 815share/doc/sqlite3/releaselog/current.html
814share/doc/sqlite3/requirements.html 816share/doc/sqlite3/requirements.html
815share/doc/sqlite3/rescode.html 817share/doc/sqlite3/rescode.html
816share/doc/sqlite3/robots.txt 818share/doc/sqlite3/robots.txt
817share/doc/sqlite3/rowidtable.html 819share/doc/sqlite3/rowidtable.html
818share/doc/sqlite3/rowvalue.html 820share/doc/sqlite3/rowvalue.html
819share/doc/sqlite3/rtree.html 821share/doc/sqlite3/rtree.html
 822share/doc/sqlite3/schematab.html
820share/doc/sqlite3/search 823share/doc/sqlite3/search
821share/doc/sqlite3/search.d/admin 824share/doc/sqlite3/search.d/admin
822share/doc/sqlite3/search.d/search.db 825share/doc/sqlite3/search.d/search.db
823share/doc/sqlite3/security.html 826share/doc/sqlite3/security.html
824share/doc/sqlite3/selfcontained.html 827share/doc/sqlite3/selfcontained.html
825share/doc/sqlite3/series.html 828share/doc/sqlite3/series.html
826share/doc/sqlite3/serverless.html 829share/doc/sqlite3/serverless.html
827share/doc/sqlite3/session.html 830share/doc/sqlite3/session.html
828share/doc/sqlite3/session/c_changeset_abort.html 831share/doc/sqlite3/session/c_changeset_abort.html
829share/doc/sqlite3/session/c_changeset_conflict.html 832share/doc/sqlite3/session/c_changeset_conflict.html
830share/doc/sqlite3/session/c_changesetapply_invert.html 833share/doc/sqlite3/session/c_changesetapply_invert.html
831share/doc/sqlite3/session/c_changesetstart_invert.html 834share/doc/sqlite3/session/c_changesetstart_invert.html
832share/doc/sqlite3/session/c_session_config_strmsize.html 835share/doc/sqlite3/session/c_session_config_strmsize.html

cvs diff -r1.95 -r1.96 pkgsrc/databases/sqlite3-docs/distinfo (expand / switch to unified diff)

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

cvs diff -r1.107 -r1.108 pkgsrc/databases/sqlite3-tcl/distinfo (expand / switch to unified diff)

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

cvs diff -r1.36 -r1.37 pkgsrc/devel/lemon/distinfo (expand / switch to unified diff)

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