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" commanddiff -r1.62 -r1.63 pkgsrc/databases/sqlite3/Makefile.common
(adam)
@@ -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 | |||
8 | SQLITE3_DISTVERSION= 3280000 | 8 | SQLITE3_DISTVERSION= 3290000 | |
9 | SQLITE3_VERSION= 3.28.0 | 9 | SQLITE3_VERSION= 3.29.0 | |
10 | 10 | |||
11 | MASTER_SITES= http://www.sqlite.org/2019/ | 11 | MASTER_SITES= http://www.sqlite.org/2019/ | |
12 | MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2019/ | 12 | MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2019/ | |
13 | 13 | |||
14 | HOMEPAGE?= http://www.sqlite.org/ | 14 | HOMEPAGE?= http://www.sqlite.org/ | |
15 | LICENSE= public-domain | 15 | LICENSE= public-domain |
@@ -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 | |||
3 | SHA1 (sqlite-autoconf-3280000.tar.gz) = 01b9d8fc77085e144dddc87456c9783e53d09a53 | 3 | SHA1 (sqlite-autoconf-3290000.tar.gz) = 053d8237eb9741b0e297073810668c2611a8e38e | |
4 | RMD160 (sqlite-autoconf-3280000.tar.gz) = b4e13e4b6ae0678a3813e6c07c4df6596d2e6683 | 4 | RMD160 (sqlite-autoconf-3290000.tar.gz) = 2c976f4ee1a71c6600f829e04cd8be1712ff2420 | |
5 | SHA512 (sqlite-autoconf-3280000.tar.gz) = e800c0d9e6c8c01ccf1d714c6c4da4b98e9610c4c06557dda6393d0792a8ae09788703d4a74dcb21844c49b3629ff7ed95a4a86ff79872aafd2b49c672c7a570 | 5 | SHA512 (sqlite-autoconf-3290000.tar.gz) = 85dcaa72cc2476c628e801d4ce46cf10ed8997f56cb0334062df5553f18c29d607883a1049bf75258204f2f53a29a02a01f014dcca383b05dfac1e2123778024 | |
6 | Size (sqlite-autoconf-3280000.tar.gz) = 2810415 bytes | 6 | Size (sqlite-autoconf-3290000.tar.gz) = 2833613 bytes |
@@ -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 $ | |
2 | share/doc/sqlite3/34to35.html | 2 | share/doc/sqlite3/34to35.html | |
3 | share/doc/sqlite3/35to36.html | 3 | share/doc/sqlite3/35to36.html | |
4 | share/doc/sqlite3/about.html | 4 | share/doc/sqlite3/about.html | |
5 | share/doc/sqlite3/aff_short.html | 5 | share/doc/sqlite3/aff_short.html | |
6 | share/doc/sqlite3/affcase1.html | 6 | share/doc/sqlite3/affcase1.html | |
7 | share/doc/sqlite3/amalgamation.html | 7 | share/doc/sqlite3/amalgamation.html | |
8 | share/doc/sqlite3/appfileformat.html | 8 | share/doc/sqlite3/appfileformat.html | |
9 | share/doc/sqlite3/arch.html | 9 | share/doc/sqlite3/arch.html | |
10 | share/doc/sqlite3/assert.html | 10 | share/doc/sqlite3/assert.html | |
11 | share/doc/sqlite3/asyncvfs.html | 11 | share/doc/sqlite3/asyncvfs.html | |
12 | share/doc/sqlite3/atomiccommit.html | 12 | share/doc/sqlite3/atomiccommit.html | |
13 | share/doc/sqlite3/autoinc.html | 13 | share/doc/sqlite3/autoinc.html | |
14 | share/doc/sqlite3/backup.html | 14 | share/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 | |||
646 | share/doc/sqlite3/releaselog/3_22_0.html | 646 | share/doc/sqlite3/releaselog/3_22_0.html | |
647 | share/doc/sqlite3/releaselog/3_23_0.html | 647 | share/doc/sqlite3/releaselog/3_23_0.html | |
648 | share/doc/sqlite3/releaselog/3_23_1.html | 648 | share/doc/sqlite3/releaselog/3_23_1.html | |
649 | share/doc/sqlite3/releaselog/3_24_0.html | 649 | share/doc/sqlite3/releaselog/3_24_0.html | |
650 | share/doc/sqlite3/releaselog/3_25_0.html | 650 | share/doc/sqlite3/releaselog/3_25_0.html | |
651 | share/doc/sqlite3/releaselog/3_25_1.html | 651 | share/doc/sqlite3/releaselog/3_25_1.html | |
652 | share/doc/sqlite3/releaselog/3_25_2.html | 652 | share/doc/sqlite3/releaselog/3_25_2.html | |
653 | share/doc/sqlite3/releaselog/3_25_3.html | 653 | share/doc/sqlite3/releaselog/3_25_3.html | |
654 | share/doc/sqlite3/releaselog/3_26_0.html | 654 | share/doc/sqlite3/releaselog/3_26_0.html | |
655 | share/doc/sqlite3/releaselog/3_27_0.html | 655 | share/doc/sqlite3/releaselog/3_27_0.html | |
656 | share/doc/sqlite3/releaselog/3_27_1.html | 656 | share/doc/sqlite3/releaselog/3_27_1.html | |
657 | share/doc/sqlite3/releaselog/3_27_2.html | 657 | share/doc/sqlite3/releaselog/3_27_2.html | |
658 | share/doc/sqlite3/releaselog/3_28_0.html | 658 | share/doc/sqlite3/releaselog/3_28_0.html | |
659 | share/doc/sqlite3/releaselog/3_29_0.html | |||
659 | share/doc/sqlite3/releaselog/3_2_0.html | 660 | share/doc/sqlite3/releaselog/3_2_0.html | |
660 | share/doc/sqlite3/releaselog/3_2_1.html | 661 | share/doc/sqlite3/releaselog/3_2_1.html | |
661 | share/doc/sqlite3/releaselog/3_2_2.html | 662 | share/doc/sqlite3/releaselog/3_2_2.html | |
662 | share/doc/sqlite3/releaselog/3_2_3.html | 663 | share/doc/sqlite3/releaselog/3_2_3.html | |
663 | share/doc/sqlite3/releaselog/3_2_4.html | 664 | share/doc/sqlite3/releaselog/3_2_4.html | |
664 | share/doc/sqlite3/releaselog/3_2_5.html | 665 | share/doc/sqlite3/releaselog/3_2_5.html | |
665 | share/doc/sqlite3/releaselog/3_2_6.html | 666 | share/doc/sqlite3/releaselog/3_2_6.html | |
666 | share/doc/sqlite3/releaselog/3_2_7.html | 667 | share/doc/sqlite3/releaselog/3_2_7.html | |
667 | share/doc/sqlite3/releaselog/3_2_8.html | 668 | share/doc/sqlite3/releaselog/3_2_8.html | |
668 | share/doc/sqlite3/releaselog/3_3_0.html | 669 | share/doc/sqlite3/releaselog/3_3_0.html | |
669 | share/doc/sqlite3/releaselog/3_3_1.html | 670 | share/doc/sqlite3/releaselog/3_3_1.html | |
670 | share/doc/sqlite3/releaselog/3_3_10.html | 671 | share/doc/sqlite3/releaselog/3_3_10.html | |
671 | share/doc/sqlite3/releaselog/3_3_11.html | 672 | share/doc/sqlite3/releaselog/3_3_11.html |
@@ -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 | |||
3 | SHA1 (sqlite-doc-3280000.zip) = f3242cf186a4e194e7d1a5e00384dd4aa66ec16b | 3 | SHA1 (sqlite-doc-3290000.zip) = b0f697c557b415cb1d67acb61b40fbad0b012cad | |
4 | RMD160 (sqlite-doc-3280000.zip) = b495c4795641f9583b5b061ba7351274197689db | 4 | RMD160 (sqlite-doc-3290000.zip) = fd65542f02ef60217f1857202786114c439e2435 | |
5 | SHA512 (sqlite-doc-3280000.zip) = 83e23dff00614d31d501c66c29d8d4aa780b38859242b58937243235d185fe3db2f9f3c1accf9bf2df0b457a6e32612a00e82f503a8665aad4f19602e2b36396 | 5 | SHA512 (sqlite-doc-3290000.zip) = ca856cf250e395d9c7e9817337adb5a16b1d96a20548a4010f5137188d35bb9d49a4a6da47bf2a696deffa68d2976dbb35a036adce19b8320e0e286876ac094f | |
6 | Size (sqlite-doc-3280000.zip) = 9421770 bytes | 6 | Size (sqlite-doc-3290000.zip) = 9415641 bytes |
@@ -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 | |||
3 | SHA1 (sqlite-autoconf-3280000.tar.gz) = 01b9d8fc77085e144dddc87456c9783e53d09a53 | 3 | SHA1 (sqlite-autoconf-3290000.tar.gz) = 053d8237eb9741b0e297073810668c2611a8e38e | |
4 | RMD160 (sqlite-autoconf-3280000.tar.gz) = b4e13e4b6ae0678a3813e6c07c4df6596d2e6683 | 4 | RMD160 (sqlite-autoconf-3290000.tar.gz) = 2c976f4ee1a71c6600f829e04cd8be1712ff2420 | |
5 | SHA512 (sqlite-autoconf-3280000.tar.gz) = e800c0d9e6c8c01ccf1d714c6c4da4b98e9610c4c06557dda6393d0792a8ae09788703d4a74dcb21844c49b3629ff7ed95a4a86ff79872aafd2b49c672c7a570 | 5 | SHA512 (sqlite-autoconf-3290000.tar.gz) = 85dcaa72cc2476c628e801d4ce46cf10ed8997f56cb0334062df5553f18c29d607883a1049bf75258204f2f53a29a02a01f014dcca383b05dfac1e2123778024 | |
6 | Size (sqlite-autoconf-3280000.tar.gz) = 2810415 bytes | 6 | Size (sqlite-autoconf-3290000.tar.gz) = 2833613 bytes | |
7 | SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 | 7 | SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 |
@@ -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 | |||
3 | SHA1 (sqlite-src-3280000.zip) = 21c391f177ac39750e5a8ac61d07550bf6befb4a | 3 | SHA1 (sqlite-src-3290000.zip) = e8862aa46fb70e25c8006a1fe519067a1fa9e618 | |
4 | RMD160 (sqlite-src-3280000.zip) = 73241e9eb7a3938453e822e4af7ac71099c12f27 | 4 | RMD160 (sqlite-src-3290000.zip) = bff9c9e661f232f07196f94907e6102084d880d3 | |
5 | SHA512 (sqlite-src-3280000.zip) = 49c35c65fa686a2326e13218db583c54fa5fe8f48f0caddd11a942601803b3023f7d32ffbab16641e0d72dc9ed288ad26eaa7226c865ac54e1f181859125651f | 5 | SHA512 (sqlite-src-3290000.zip) = 575398fbe20c6471ee2abcbde170b8d48efbb3cb2716a65f42f05c52429a45d14e8046e50c59bbf75bfe2d8f151c34abd50b440c50af571f19e19f3290b230df | |
6 | Size (sqlite-src-3280000.zip) = 12477204 bytes | 6 | Size (sqlite-src-3290000.zip) = 12557725 bytes |