Fri Jul 12 10:04:27 2019 UTC ()
sqlite3: updated to 3.29.0

SQLite Release 3.29.0:
Added the SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL actions to sqlite3_db_config() for activating and deactivating the double-quoted string literal misfeature. Both default to "on" for legacy compatibility, but developers are encouraged to turn them "off", perhaps using the -DSQLITE_DQS=0 compile-time option.
-DSQLITE_DQS=0 is now a recommended compile-time option.

Improvements to the query planner:
Improved optimization of AND and OR operators when one or the other operand is a constant.
Enhancements to the LIKE optimization for cases when the left-hand side column has numeric affinity.
Added the "sqlite_dbdata" virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt.

Enhancements to the CLI:
Add the ".recover" command which tries to recover as much content as possible from a corrupt database file.
Add the ".filectrl" command useful for testing.
Add the long-standing ".testctrl" command to the ".help" menu.
Added the ".dbconfig" command


(adam)
diff -r1.62 -r1.63 pkgsrc/databases/sqlite3/Makefile.common
diff -r1.151 -r1.152 pkgsrc/databases/sqlite3/distinfo
diff -r1.85 -r1.86 pkgsrc/databases/sqlite3-docs/PLIST
diff -r1.86 -r1.87 pkgsrc/databases/sqlite3-docs/distinfo
diff -r1.98 -r1.99 pkgsrc/databases/sqlite3-tcl/distinfo
diff -r1.27 -r1.28 pkgsrc/devel/lemon/distinfo

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

--- pkgsrc/databases/sqlite3/Makefile.common 2019/04/18 10:10:03 1.62
+++ pkgsrc/databases/sqlite3/Makefile.common 2019/07/12 10:04:26 1.63
@@ -1,15 +1,15 @@ @@ -1,15 +1,15 @@
1# $NetBSD: Makefile.common,v 1.62 2019/04/18 10:10:03 adam Exp $ 1# $NetBSD: Makefile.common,v 1.63 2019/07/12 10:04:26 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= 3280000 8SQLITE3_DISTVERSION= 3290000
9SQLITE3_VERSION= 3.28.0 9SQLITE3_VERSION= 3.29.0
10 10
11MASTER_SITES= http://www.sqlite.org/2019/ 11MASTER_SITES= http://www.sqlite.org/2019/
12MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2019/ 12MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2019/
13 13
14HOMEPAGE?= http://www.sqlite.org/ 14HOMEPAGE?= http://www.sqlite.org/
15LICENSE= public-domain 15LICENSE= public-domain

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

--- pkgsrc/databases/sqlite3/distinfo 2019/04/18 10:10:03 1.151
+++ pkgsrc/databases/sqlite3/distinfo 2019/07/12 10:04:26 1.152
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.151 2019/04/18 10:10:03 adam Exp $ 1$NetBSD: distinfo,v 1.152 2019/07/12 10:04:26 adam Exp $
2 2
3SHA1 (sqlite-autoconf-3280000.tar.gz) = 01b9d8fc77085e144dddc87456c9783e53d09a53 3SHA1 (sqlite-autoconf-3290000.tar.gz) = 053d8237eb9741b0e297073810668c2611a8e38e
4RMD160 (sqlite-autoconf-3280000.tar.gz) = b4e13e4b6ae0678a3813e6c07c4df6596d2e6683 4RMD160 (sqlite-autoconf-3290000.tar.gz) = 2c976f4ee1a71c6600f829e04cd8be1712ff2420
5SHA512 (sqlite-autoconf-3280000.tar.gz) = e800c0d9e6c8c01ccf1d714c6c4da4b98e9610c4c06557dda6393d0792a8ae09788703d4a74dcb21844c49b3629ff7ed95a4a86ff79872aafd2b49c672c7a570 5SHA512 (sqlite-autoconf-3290000.tar.gz) = 85dcaa72cc2476c628e801d4ce46cf10ed8997f56cb0334062df5553f18c29d607883a1049bf75258204f2f53a29a02a01f014dcca383b05dfac1e2123778024
6Size (sqlite-autoconf-3280000.tar.gz) = 2810415 bytes 6Size (sqlite-autoconf-3290000.tar.gz) = 2833613 bytes

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

--- pkgsrc/databases/sqlite3-docs/PLIST 2019/04/18 10:10:03 1.85
+++ pkgsrc/databases/sqlite3-docs/PLIST 2019/07/12 10:04:27 1.86
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.85 2019/04/18 10:10:03 adam Exp $ 1@comment $NetBSD: PLIST,v 1.86 2019/07/12 10:04:27 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/arch.html 9share/doc/sqlite3/arch.html
10share/doc/sqlite3/assert.html 10share/doc/sqlite3/assert.html
11share/doc/sqlite3/asyncvfs.html 11share/doc/sqlite3/asyncvfs.html
12share/doc/sqlite3/atomiccommit.html 12share/doc/sqlite3/atomiccommit.html
13share/doc/sqlite3/autoinc.html 13share/doc/sqlite3/autoinc.html
14share/doc/sqlite3/backup.html 14share/doc/sqlite3/backup.html
@@ -646,26 +646,27 @@ share/doc/sqlite3/releaselog/3_21_0.html @@ -646,26 +646,27 @@ share/doc/sqlite3/releaselog/3_21_0.html
646share/doc/sqlite3/releaselog/3_22_0.html 646share/doc/sqlite3/releaselog/3_22_0.html
647share/doc/sqlite3/releaselog/3_23_0.html 647share/doc/sqlite3/releaselog/3_23_0.html
648share/doc/sqlite3/releaselog/3_23_1.html 648share/doc/sqlite3/releaselog/3_23_1.html
649share/doc/sqlite3/releaselog/3_24_0.html 649share/doc/sqlite3/releaselog/3_24_0.html
650share/doc/sqlite3/releaselog/3_25_0.html 650share/doc/sqlite3/releaselog/3_25_0.html
651share/doc/sqlite3/releaselog/3_25_1.html 651share/doc/sqlite3/releaselog/3_25_1.html
652share/doc/sqlite3/releaselog/3_25_2.html 652share/doc/sqlite3/releaselog/3_25_2.html
653share/doc/sqlite3/releaselog/3_25_3.html 653share/doc/sqlite3/releaselog/3_25_3.html
654share/doc/sqlite3/releaselog/3_26_0.html 654share/doc/sqlite3/releaselog/3_26_0.html
655share/doc/sqlite3/releaselog/3_27_0.html 655share/doc/sqlite3/releaselog/3_27_0.html
656share/doc/sqlite3/releaselog/3_27_1.html 656share/doc/sqlite3/releaselog/3_27_1.html
657share/doc/sqlite3/releaselog/3_27_2.html 657share/doc/sqlite3/releaselog/3_27_2.html
658share/doc/sqlite3/releaselog/3_28_0.html 658share/doc/sqlite3/releaselog/3_28_0.html
 659share/doc/sqlite3/releaselog/3_29_0.html
659share/doc/sqlite3/releaselog/3_2_0.html 660share/doc/sqlite3/releaselog/3_2_0.html
660share/doc/sqlite3/releaselog/3_2_1.html 661share/doc/sqlite3/releaselog/3_2_1.html
661share/doc/sqlite3/releaselog/3_2_2.html 662share/doc/sqlite3/releaselog/3_2_2.html
662share/doc/sqlite3/releaselog/3_2_3.html 663share/doc/sqlite3/releaselog/3_2_3.html
663share/doc/sqlite3/releaselog/3_2_4.html 664share/doc/sqlite3/releaselog/3_2_4.html
664share/doc/sqlite3/releaselog/3_2_5.html 665share/doc/sqlite3/releaselog/3_2_5.html
665share/doc/sqlite3/releaselog/3_2_6.html 666share/doc/sqlite3/releaselog/3_2_6.html
666share/doc/sqlite3/releaselog/3_2_7.html 667share/doc/sqlite3/releaselog/3_2_7.html
667share/doc/sqlite3/releaselog/3_2_8.html 668share/doc/sqlite3/releaselog/3_2_8.html
668share/doc/sqlite3/releaselog/3_3_0.html 669share/doc/sqlite3/releaselog/3_3_0.html
669share/doc/sqlite3/releaselog/3_3_1.html 670share/doc/sqlite3/releaselog/3_3_1.html
670share/doc/sqlite3/releaselog/3_3_10.html 671share/doc/sqlite3/releaselog/3_3_10.html
671share/doc/sqlite3/releaselog/3_3_11.html 672share/doc/sqlite3/releaselog/3_3_11.html

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

--- pkgsrc/databases/sqlite3-docs/distinfo 2019/04/18 10:10:03 1.86
+++ pkgsrc/databases/sqlite3-docs/distinfo 2019/07/12 10:04:27 1.87
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.86 2019/04/18 10:10:03 adam Exp $ 1$NetBSD: distinfo,v 1.87 2019/07/12 10:04:27 adam Exp $
2 2
3SHA1 (sqlite-doc-3280000.zip) = f3242cf186a4e194e7d1a5e00384dd4aa66ec16b 3SHA1 (sqlite-doc-3290000.zip) = b0f697c557b415cb1d67acb61b40fbad0b012cad
4RMD160 (sqlite-doc-3280000.zip) = b495c4795641f9583b5b061ba7351274197689db 4RMD160 (sqlite-doc-3290000.zip) = fd65542f02ef60217f1857202786114c439e2435
5SHA512 (sqlite-doc-3280000.zip) = 83e23dff00614d31d501c66c29d8d4aa780b38859242b58937243235d185fe3db2f9f3c1accf9bf2df0b457a6e32612a00e82f503a8665aad4f19602e2b36396 5SHA512 (sqlite-doc-3290000.zip) = ca856cf250e395d9c7e9817337adb5a16b1d96a20548a4010f5137188d35bb9d49a4a6da47bf2a696deffa68d2976dbb35a036adce19b8320e0e286876ac094f
6Size (sqlite-doc-3280000.zip) = 9421770 bytes 6Size (sqlite-doc-3290000.zip) = 9415641 bytes

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

--- pkgsrc/databases/sqlite3-tcl/distinfo 2019/04/18 10:10:03 1.98
+++ pkgsrc/databases/sqlite3-tcl/distinfo 2019/07/12 10:04:27 1.99
@@ -1,7 +1,7 @@ @@ -1,7 +1,7 @@
1$NetBSD: distinfo,v 1.98 2019/04/18 10:10:03 adam Exp $ 1$NetBSD: distinfo,v 1.99 2019/07/12 10:04:27 adam Exp $
2 2
3SHA1 (sqlite-autoconf-3280000.tar.gz) = 01b9d8fc77085e144dddc87456c9783e53d09a53 3SHA1 (sqlite-autoconf-3290000.tar.gz) = 053d8237eb9741b0e297073810668c2611a8e38e
4RMD160 (sqlite-autoconf-3280000.tar.gz) = b4e13e4b6ae0678a3813e6c07c4df6596d2e6683 4RMD160 (sqlite-autoconf-3290000.tar.gz) = 2c976f4ee1a71c6600f829e04cd8be1712ff2420
5SHA512 (sqlite-autoconf-3280000.tar.gz) = e800c0d9e6c8c01ccf1d714c6c4da4b98e9610c4c06557dda6393d0792a8ae09788703d4a74dcb21844c49b3629ff7ed95a4a86ff79872aafd2b49c672c7a570 5SHA512 (sqlite-autoconf-3290000.tar.gz) = 85dcaa72cc2476c628e801d4ce46cf10ed8997f56cb0334062df5553f18c29d607883a1049bf75258204f2f53a29a02a01f014dcca383b05dfac1e2123778024
6Size (sqlite-autoconf-3280000.tar.gz) = 2810415 bytes 6Size (sqlite-autoconf-3290000.tar.gz) = 2833613 bytes
7SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 7SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

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

--- pkgsrc/devel/lemon/distinfo 2019/04/18 10:10:03 1.27
+++ pkgsrc/devel/lemon/distinfo 2019/07/12 10:04:27 1.28
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.27 2019/04/18 10:10:03 adam Exp $ 1$NetBSD: distinfo,v 1.28 2019/07/12 10:04:27 adam Exp $
2 2
3SHA1 (sqlite-src-3280000.zip) = 21c391f177ac39750e5a8ac61d07550bf6befb4a 3SHA1 (sqlite-src-3290000.zip) = e8862aa46fb70e25c8006a1fe519067a1fa9e618
4RMD160 (sqlite-src-3280000.zip) = 73241e9eb7a3938453e822e4af7ac71099c12f27 4RMD160 (sqlite-src-3290000.zip) = bff9c9e661f232f07196f94907e6102084d880d3
5SHA512 (sqlite-src-3280000.zip) = 49c35c65fa686a2326e13218db583c54fa5fe8f48f0caddd11a942601803b3023f7d32ffbab16641e0d72dc9ed288ad26eaa7226c865ac54e1f181859125651f 5SHA512 (sqlite-src-3290000.zip) = 575398fbe20c6471ee2abcbde170b8d48efbb3cb2716a65f42f05c52429a45d14e8046e50c59bbf75bfe2d8f151c34abd50b440c50af571f19e19f3290b230df
6Size (sqlite-src-3280000.zip) = 12477204 bytes 6Size (sqlite-src-3290000.zip) = 12557725 bytes