CVS commit: pkgsrc

To: pkgsrc-changes%NetBSD.org@localhost
Subject: CVS commit: pkgsrc
From: "Adam Ciarcinski" <adam%netbsd.org@localhost>
Date: Thu, 17 Nov 2022 06:20:45 +0000

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Nov 17 06:20:45 UTC 2022

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

Log Message:
sqlite3: updated to 3.40.0

SQLite Release 3.40.0

Add support for compiling SQLite to WASM and running it in web browsers. NB: The WASM build and its interfaces are considered "beta" and are subject to minor changes if the need arises. We anticipate 
finalizing the interface for the next release.
Add the recovery extension that might be able to recover some content from a corrupt database file.
Query planner enhancements:
Recognize covering indexes on tables with more than 63 columns where columns beyond the 63rd column are used in the query and/or are referenced by the index.
Extract the values of expressions contained within expression indexes where practical, rather than recomputing the expression.
The NOT NULL and IS NULL operators (and their equivalents) avoid loading the content of large strings and BLOB values from disk.
Avoid materializing a view on which a full scan is performed exactly once. Use and discard the rows of the view as they are computed.
Allow flattening of a subquery that is the right-hand operand of a LEFT JOIN in an aggregate query.
A new typedef named sqlite3_filename is added and used to represent the name of a database file. Various interfaces are modified to use the new typedef instead of "char*". This interface change 
should be fully backwards compatible, though it might cause (harmless) compiler warnings when rebuilding some legacy applications.
Add the sqlite3_value_encoding() interface.
Security enhancement: SQLITE_DBCONFIG_DEFENSIVE is augmented to prohibit changing the schema_version. The schema_version becomes read-only in defensive mode.
Enhancements to the PRAGMA integrity_check statement:
Columns in non-STRICT tables with TEXT affinity should not contain numeric values.
Columns in non-STRICT tables with NUMERIC affinity should not contain TEXT values that could be converted into numbers.
Verify that the rows of a WITHOUT ROWID table are in the correct order.
Enhance the VACUUM INTO statement so that it honors they PRAGMA synchronous setting.
Enhance the sqlite3_strglob() and sqlite3_strlike() APIs so that they are able to accept NULL pointers for their string parameters and still generate a sensible result.
Provide the new SQLITE_MAX_ALLOCATION_SIZE compile-time option for limiting the size of memory allocations.
Change the algorithm used by SQLite's built-in pseudo-random number generator (PRNG) from RC4 to Chacha20.
Allow two or more indexes to have the same name as long as they are all in separate schemas.
Miscellaneous performance optimizations result in about 1% fewer CPU cycles used on typical workloads.


To generate a diff of this commit:
cvs rdiff -u -r1.95 -r1.96 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.188 -r1.189 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.118 -r1.119 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.121 -r1.122 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.133 -r1.134 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.1 -r1.2 \
    pkgsrc/databases/sqlite3-tcl/patches/patch-Makefile.in
cvs rdiff -u -r1.62 -r1.63 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.95 pkgsrc/databases/sqlite3/Makefile.common:1.96
--- pkgsrc/databases/sqlite3/Makefile.common:1.95       Mon Oct  3 12:27:52 2022
+++ pkgsrc/databases/sqlite3/Makefile.common    Thu Nov 17 06:20:44 2022
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.95 2022/10/03 12:27:52 adam Exp $
+# $NetBSD: Makefile.common,v 1.96 2022/11/17 06:20:44 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=   3390400
-SQLITE3_VERSION=       3.39.4
+SQLITE3_DISTVERSION=   3400000
+SQLITE3_VERSION=       3.40.0
 
 MASTER_SITES=  http://www.sqlite.org/2022/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.188 pkgsrc/databases/sqlite3/distinfo:1.189
--- pkgsrc/databases/sqlite3/distinfo:1.188     Mon Oct  3 12:27:52 2022
+++ pkgsrc/databases/sqlite3/distinfo   Thu Nov 17 06:20:44 2022
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.188 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.189 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3390400.tar.gz) = efef4f594d97c8a4bd724c16f7ae7c9f295eb0a52193146753cb08392e5d5b97
-SHA512 (sqlite-autoconf-3390400.tar.gz) = cc1de214e69ef677cac3f6dd2000ccfcf4b672ab464a115d96f24707009a408630e762c3cda89741b728ab34c4d9f5b8f8b12e9b11448e8364642b4421c3393d
-Size (sqlite-autoconf-3390400.tar.gz) = 3065214 bytes
+BLAKE2s (sqlite-autoconf-3400000.tar.gz) = 378945cc6da267e3c5652afe62731904acc6d4a2154c0b2fb08355a5cbdced00
+SHA512 (sqlite-autoconf-3400000.tar.gz) = 175271e620dd947df2ca63c3ea6cff80e16f8f808a3ea7f6700282768adc2d61ac375d42b2064c73eec849c67307ac5291fdadc3059861caa015ac3ac7a480e4
+Size (sqlite-autoconf-3400000.tar.gz) = 3097756 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.118 pkgsrc/databases/sqlite3-docs/PLIST:1.119
--- pkgsrc/databases/sqlite3-docs/PLIST:1.118   Mon Oct  3 12:27:52 2022
+++ pkgsrc/databases/sqlite3-docs/PLIST Thu Nov 17 06:20:44 2022
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.118 2022/10/03 12:27:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.119 2022/11/17 06:20:44 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -118,6 +118,7 @@ share/doc/sqlite3/c3ref/experimental.htm
 share/doc/sqlite3/c3ref/extended_result_codes.html
 share/doc/sqlite3/c3ref/file.html
 share/doc/sqlite3/c3ref/file_control.html
+share/doc/sqlite3/c3ref/filename.html
 share/doc/sqlite3/c3ref/filename_database.html
 share/doc/sqlite3/c3ref/finalize.html
 share/doc/sqlite3/c3ref/free.html
@@ -468,6 +469,7 @@ share/doc/sqlite3/images/sqlite370.jpg
 share/doc/sqlite3/images/sqlite370_banner.gif
 share/doc/sqlite3/images/sqlitepie.jpg
 share/doc/sqlite3/images/src_logo.gif
+share/doc/sqlite3/images/sschart20221116.jpg
 share/doc/sqlite3/images/sw.gif
 share/doc/sqlite3/images/sw.png
 share/doc/sqlite3/images/table-ex1b2.gif
@@ -551,6 +553,7 @@ share/doc/sqlite3/queryplanner.html
 share/doc/sqlite3/quickstart.html
 share/doc/sqlite3/quirks.html
 share/doc/sqlite3/rbu.html
+share/doc/sqlite3/recovery.html
 share/doc/sqlite3/releaselog/3_0_0.html
 share/doc/sqlite3/releaselog/3_0_1.html
 share/doc/sqlite3/releaselog/3_0_2.html
@@ -669,6 +672,7 @@ share/doc/sqlite3/releaselog/3_3_6.html
 share/doc/sqlite3/releaselog/3_3_7.html
 share/doc/sqlite3/releaselog/3_3_8.html
 share/doc/sqlite3/releaselog/3_3_9.html
+share/doc/sqlite3/releaselog/3_40_0.html
 share/doc/sqlite3/releaselog/3_4_0.html
 share/doc/sqlite3/releaselog/3_4_1.html
 share/doc/sqlite3/releaselog/3_4_2.html
@@ -846,6 +850,7 @@ share/doc/sqlite3/sqlanalyze.html
 share/doc/sqlite3/sqlar.html
 share/doc/sqlite3/sqldiff.html
 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

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.121 pkgsrc/databases/sqlite3-docs/distinfo:1.122
--- pkgsrc/databases/sqlite3-docs/distinfo:1.121        Mon Oct  3 12:27:52 2022
+++ pkgsrc/databases/sqlite3-docs/distinfo      Thu Nov 17 06:20:44 2022
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.121 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.122 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-doc-3390400.zip) = ee8d991decabf8089b0dd80157930f33a9d38c8526c97da6faa17c1033a9939e
-SHA512 (sqlite-doc-3390400.zip) = 75d97b0f2f0d530b2e0ad505574af3bf657d82f0859bb5de7ee45c40a80351e933944845cedca56b579925a3d07505c6f4721f756f27862ffafdfc2caff539fb
-Size (sqlite-doc-3390400.zip) = 10853153 bytes
+BLAKE2s (sqlite-doc-3400000.zip) = 335f41408e24dc66874aeaf55bf6c7f5594b8afc0938c061c34a9f9f73d10d85
+SHA512 (sqlite-doc-3400000.zip) = 3557fe49e08fd24890da584f3fa7fb93d1e3317787f98a8ce1062dcac07733782026e50dfef7db72582739ddf0a77095cc4d3a81f3df097a69e85c672591bf7e
+Size (sqlite-doc-3400000.zip) = 10921883 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.133 pkgsrc/databases/sqlite3-tcl/distinfo:1.134
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.133 Mon Oct  3 12:27:52 2022
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Thu Nov 17 06:20:44 2022
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.133 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.134 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3390400.tar.gz) = efef4f594d97c8a4bd724c16f7ae7c9f295eb0a52193146753cb08392e5d5b97
-SHA512 (sqlite-autoconf-3390400.tar.gz) = cc1de214e69ef677cac3f6dd2000ccfcf4b672ab464a115d96f24707009a408630e762c3cda89741b728ab34c4d9f5b8f8b12e9b11448e8364642b4421c3393d
-Size (sqlite-autoconf-3390400.tar.gz) = 3065214 bytes
-SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
+BLAKE2s (sqlite-autoconf-3400000.tar.gz) = 378945cc6da267e3c5652afe62731904acc6d4a2154c0b2fb08355a5cbdced00
+SHA512 (sqlite-autoconf-3400000.tar.gz) = 175271e620dd947df2ca63c3ea6cff80e16f8f808a3ea7f6700282768adc2d61ac375d42b2064c73eec849c67307ac5291fdadc3059861caa015ac3ac7a480e4
+Size (sqlite-autoconf-3400000.tar.gz) = 3097756 bytes
+SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5

Index: pkgsrc/databases/sqlite3-tcl/patches/patch-Makefile.in
diff -u pkgsrc/databases/sqlite3-tcl/patches/patch-Makefile.in:1.1 pkgsrc/databases/sqlite3-tcl/patches/patch-Makefile.in:1.2
--- pkgsrc/databases/sqlite3-tcl/patches/patch-Makefile.in:1.1  Sat Jun 10 19:14:00 2017
+++ pkgsrc/databases/sqlite3-tcl/patches/patch-Makefile.in      Thu Nov 17 06:20:44 2022
@@ -1,10 +1,10 @@
-$NetBSD: patch-Makefile.in,v 1.1 2017/06/10 19:14:00 adam Exp $
+$NetBSD: patch-Makefile.in,v 1.2 2022/11/17 06:20:44 adam Exp $
 
 Install into correct directory.
 
---- Makefile.in.orig   2014-03-10 13:47:51.000000000 +0000
+--- Makefile.in.orig   2022-11-16 13:42:39.000000000 +0000
 +++ Makefile.in
-@@ -81,7 +81,7 @@ DESTDIR              =
+@@ -83,7 +83,7 @@ DESTDIR              =
  
  PKG_DIR               = $(PACKAGE_NAME)$(PACKAGE_VERSION)
  pkgdatadir    = $(datadir)/$(PKG_DIR)
@@ -12,4 +12,4 @@ Install into correct directory.
 +pkglibdir     = $(libdir)/sqlite3
  pkgincludedir = $(includedir)/$(PKG_DIR)
  
- top_builddir  = .
+ top_builddir  = @abs_top_builddir@

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.62 pkgsrc/devel/lemon/distinfo:1.63
--- pkgsrc/devel/lemon/distinfo:1.62    Mon Oct  3 12:27:52 2022
+++ pkgsrc/devel/lemon/distinfo Thu Nov 17 06:20:44 2022
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.62 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.63 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-src-3390400.zip) = 58782c11d2e04d06f8ed91c5ae61bf2099cb9f812373f761c8cf697c5f584063
-SHA512 (sqlite-src-3390400.zip) = 0acb8afc87f911c91ec555cc97af5b77b6b0e80cc8672711ddd87c651d9e11b697c9669ff9ba2b58da12b972bb46acdf8b8fe35993950f10735b4036501b73bb
-Size (sqlite-src-3390400.zip) = 13405169 bytes
+BLAKE2s (sqlite-src-3400000.zip) = 6fcf2d0a0046143a892cef16c3c5d4986aa93febebbf4fcae207e9069a94a038
+SHA512 (sqlite-src-3400000.zip) = c3bb3829f99c663f3381f4c610e401173f133fe944558b70da7521cc44116d048e4e1651993feb128b0f3814381aa4fa93f48ba3e277abca3442af805159287d
+Size (sqlite-src-3400000.zip) = 13723231 bytes

Prev by Date: CVS commit: pkgsrc/archivers/unrar
Next by Date: CVS commit: pkgsrc/doc
Previous by Thread: CVS commit: pkgsrc/archivers/unrar
Next by Thread: CVS commit: pkgsrc/doc
Indexes:

Home | Main Index | Thread Index | Old Index