CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed Nov  1 20:46:04 UTC 2023

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

SQLite Release 3.44.0 On 2023-11-01

Aggregate functions can now include an ORDER BY clause after their last parameter. The arguments to the function are processed in the order specified. This can be important for functions like 
string_agg() and json_group_array().
Add support for the concat() and concat_ws() scalar SQL functions, compatible with PostgreSQL, SQLServer, and MySQL.
Add support for the string_agg() aggregate SQL function, compatible with PostgreSQL and SQLServer.
New conversion letters on the strftime() SQL function: %e %F %I %k %l %p %P %R %T %u
Add new C-language APIs: sqlite3_get_clientdata() and sqlite3_set_clientdata().
Many errors associated with CREATE TABLE are now raised when the CREATE TABLE statement itself is run, rather than being deferred until the first time the table is actually used.
The PRAGMA integrity_check command now verifies the consistency of the content in various built-in virtual tables using the new xIntegrity method. This works for the FTS3, FTS4, FTS5, RTREE, and 
GEOPOLY extensions.
The SQLITE_DBCONFIG_DEFENSIVE setting now prevents PRAGMA writable_schema from being turned on. Previously writable_schema could be turned on, but would not actually allow the schema to be writable. 
Now it simply cannot be turned on.
Tag the built-in FTS3, FTS4, FTS5, RTREE, and GEOPOLY virtual tables as SQLITE_VTAB_INNOCUOUS so that they can be used inside of triggers in high-security deployments.
The PRAGMA case_sensitive_like statement is deprecated, as its use when the schema contains LIKE operators can lead to reports of database corruption by PRAGMA integrity_check.
SQLITE_USE_SEH (Structured Exception Handling) is now enabled by default whenever SQLite is built using the Microsoft C compiler. It can be disabled using -DSQLITE_USE_SEH=0
Query planner optimizations:
In partial index scans, if the WHERE clause implies a constant value for a table column, replace occurrences of that table column with the constant. This increases the likelihood of the partial index 
being a covering index.
Disable the view-scan optimization (added in version 3.42.0 - item 1c) as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subqueries by a 
factor of 8.
SQLite now performs run-time detection of whether or not the underlying hardware supports "long double" with precision greater than "double" and uses appropriate floating-point routines depending on 
what it discovered.
The CLI for Windows now defaults to using UTF-8 for both input and output on platforms that support it. The --no-utf8 option is available to disable UTF8 support.


To generate a diff of this commit:
cvs rdiff -u -r1.104 -r1.105 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.198 -r1.199 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.127 -r1.128 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.130 -r1.131 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.144 -r1.145 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.71 -r1.72 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.104 pkgsrc/databases/sqlite3/Makefile.common:1.105
--- pkgsrc/databases/sqlite3/Makefile.common:1.104      Tue Oct 10 16:16:48 2023
+++ pkgsrc/databases/sqlite3/Makefile.common    Wed Nov  1 20:46:04 2023
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.104 2023/10/10 16:16:48 adam Exp $
+# $NetBSD: Makefile.common,v 1.105 2023/11/01 20:46:04 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=   3430200
-SQLITE3_VERSION=       3.43.2
+SQLITE3_DISTVERSION=   3440000
+SQLITE3_VERSION=       3.44.0
 
 MASTER_SITES=  http://www.sqlite.org/2023/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2023/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.198 pkgsrc/databases/sqlite3/distinfo:1.199
--- pkgsrc/databases/sqlite3/distinfo:1.198     Tue Oct 10 16:16:48 2023
+++ pkgsrc/databases/sqlite3/distinfo   Wed Nov  1 20:46:04 2023
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.198 2023/10/10 16:16:48 adam Exp $
+$NetBSD: distinfo,v 1.199 2023/11/01 20:46:04 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3430200.tar.gz) = 904d61d835a60ba9fa5e866a3eb5f9725f962d14abb5d96df8a436f62e25a5ee
-SHA512 (sqlite-autoconf-3430200.tar.gz) = 2cb69335aad278c175e680783081bdf48110c31ed31abb6b44b9a012f92ec67cca49c3bf3ec8212c3c9d72a3ec5d5a48ae556d04262bfa23882b6b05140d5901
-Size (sqlite-autoconf-3430200.tar.gz) = 3177625 bytes
+BLAKE2s (sqlite-autoconf-3440000.tar.gz) = 99d43825ed201dc050de5d8503c83d3edf3c5be3fe28205b1552801a3edf3435
+SHA512 (sqlite-autoconf-3440000.tar.gz) = f7fab7353a0be51f6e0c64f97651302ad6b518c921feca6e28570c44573d17804262bd11bbb43bbce82479b5087f37ec2c323cdf061048d39b1674967a9da35e
+Size (sqlite-autoconf-3440000.tar.gz) = 3198005 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.127 pkgsrc/databases/sqlite3-docs/PLIST:1.128
--- pkgsrc/databases/sqlite3-docs/PLIST:1.127   Tue Oct 10 16:16:48 2023
+++ pkgsrc/databases/sqlite3-docs/PLIST Wed Nov  1 20:46:04 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.127 2023/10/10 16:16:48 adam Exp $
+@comment $NetBSD: PLIST,v 1.128 2023/11/01 20:46:04 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -127,6 +127,7 @@ share/doc/sqlite3/c3ref/free_table.html
 share/doc/sqlite3/c3ref/funclist.html
 share/doc/sqlite3/c3ref/get_autocommit.html
 share/doc/sqlite3/c3ref/get_auxdata.html
+share/doc/sqlite3/c3ref/get_clientdata.html
 share/doc/sqlite3/c3ref/hard_heap_limit64.html
 share/doc/sqlite3/c3ref/index_info.html
 share/doc/sqlite3/c3ref/initialize.html
@@ -685,6 +686,7 @@ share/doc/sqlite3/releaselog/3_42_0.html
 share/doc/sqlite3/releaselog/3_43_0.html
 share/doc/sqlite3/releaselog/3_43_1.html
 share/doc/sqlite3/releaselog/3_43_2.html
+share/doc/sqlite3/releaselog/3_44_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
@@ -807,7 +809,7 @@ share/doc/sqlite3/serverless.html
 share/doc/sqlite3/session.html
 share/doc/sqlite3/session/c_changeset_abort.html
 share/doc/sqlite3/session/c_changeset_conflict.html
-share/doc/sqlite3/session/c_changesetapply_ignorenoop.html
+share/doc/sqlite3/session/c_changesetapply_fknoaction.html
 share/doc/sqlite3/session/c_changesetstart_invert.html
 share/doc/sqlite3/session/c_session_config_strmsize.html
 share/doc/sqlite3/session/c_session_objconfig_rowid.html
@@ -824,6 +826,7 @@ share/doc/sqlite3/session/sqlite3changeg
 share/doc/sqlite3/session/sqlite3changegroup_delete.html
 share/doc/sqlite3/session/sqlite3changegroup_new.html
 share/doc/sqlite3/session/sqlite3changegroup_output.html
+share/doc/sqlite3/session/sqlite3changegroup_schema.html
 share/doc/sqlite3/session/sqlite3changeset_apply.html
 share/doc/sqlite3/session/sqlite3changeset_concat.html
 share/doc/sqlite3/session/sqlite3changeset_conflict.html
@@ -836,6 +839,7 @@ share/doc/sqlite3/session/sqlite3changes
 share/doc/sqlite3/session/sqlite3changeset_op.html
 share/doc/sqlite3/session/sqlite3changeset_pk.html
 share/doc/sqlite3/session/sqlite3changeset_start.html
+share/doc/sqlite3/session/sqlite3changeset_upgrade.html
 share/doc/sqlite3/session/sqlite3rebaser_configure.html
 share/doc/sqlite3/session/sqlite3rebaser_create.html
 share/doc/sqlite3/session/sqlite3rebaser_delete.html
@@ -864,7 +868,6 @@ 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
@@ -903,6 +906,7 @@ share/doc/sqlite3/syntax/factored-select
 share/doc/sqlite3/syntax/filter-clause.html
 share/doc/sqlite3/syntax/foreign-key-clause.html
 share/doc/sqlite3/syntax/frame-spec.html
+share/doc/sqlite3/syntax/function-arguments.html
 share/doc/sqlite3/syntax/indexed-column.html
 share/doc/sqlite3/syntax/insert-stmt.html
 share/doc/sqlite3/syntax/join-clause.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.130 pkgsrc/databases/sqlite3-docs/distinfo:1.131
--- pkgsrc/databases/sqlite3-docs/distinfo:1.130        Tue Oct 10 16:16:48 2023
+++ pkgsrc/databases/sqlite3-docs/distinfo      Wed Nov  1 20:46:04 2023
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.130 2023/10/10 16:16:48 adam Exp $
+$NetBSD: distinfo,v 1.131 2023/11/01 20:46:04 adam Exp $
 
-BLAKE2s (sqlite-doc-3430200.zip) = e6f3c485388aa76ef84019f245afaf603d7f336ffd04e92a73a10979daa4e2b4
-SHA512 (sqlite-doc-3430200.zip) = efef55ee96745afccbb48fa5b611b4de86871ccf36ee1da8d164a9c063aca3049392de856c5f81fc6117b8e5ef8dba63bda9bd1bd4663a0746f81f1f348aa11c
-Size (sqlite-doc-3430200.zip) = 10681883 bytes
+BLAKE2s (sqlite-doc-3440000.zip) = 020ed7923830c5007b9d4389b6048d08e5329781d335287584593dc67d57197c
+SHA512 (sqlite-doc-3440000.zip) = 6873fcc265a1d89e63237d7703e750f5e4191591e17392a1060091408a9bce75e824b0bbc3d8cf2a82d6d58454f73cf3fd7c65c7276268bdfba527a168c580ff
+Size (sqlite-doc-3440000.zip) = 10689348 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.144 pkgsrc/databases/sqlite3-tcl/distinfo:1.145
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.144 Tue Oct 10 16:16:49 2023
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Wed Nov  1 20:46:04 2023
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.144 2023/10/10 16:16:49 adam Exp $
+$NetBSD: distinfo,v 1.145 2023/11/01 20:46:04 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3430200.tar.gz) = 904d61d835a60ba9fa5e866a3eb5f9725f962d14abb5d96df8a436f62e25a5ee
-SHA512 (sqlite-autoconf-3430200.tar.gz) = 2cb69335aad278c175e680783081bdf48110c31ed31abb6b44b9a012f92ec67cca49c3bf3ec8212c3c9d72a3ec5d5a48ae556d04262bfa23882b6b05140d5901
-Size (sqlite-autoconf-3430200.tar.gz) = 3177625 bytes
+BLAKE2s (sqlite-autoconf-3440000.tar.gz) = 99d43825ed201dc050de5d8503c83d3edf3c5be3fe28205b1552801a3edf3435
+SHA512 (sqlite-autoconf-3440000.tar.gz) = f7fab7353a0be51f6e0c64f97651302ad6b518c921feca6e28570c44573d17804262bd11bbb43bbce82479b5087f37ec2c323cdf061048d39b1674967a9da35e
+Size (sqlite-autoconf-3440000.tar.gz) = 3198005 bytes
 SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.71 pkgsrc/devel/lemon/distinfo:1.72
--- pkgsrc/devel/lemon/distinfo:1.71    Tue Oct 10 16:16:49 2023
+++ pkgsrc/devel/lemon/distinfo Wed Nov  1 20:46:04 2023
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.71 2023/10/10 16:16:49 adam Exp $
+$NetBSD: distinfo,v 1.72 2023/11/01 20:46:04 adam Exp $
 
-BLAKE2s (sqlite-src-3430200.zip) = e683bc45c61a0f4343e8aed84498c365acc12507280f144f2eab6ae405da5bc9
-SHA512 (sqlite-src-3430200.zip) = ab704038ae8d315144935cb99a727f85a7457ab5f0b8c639f49bb14a973dabe4784f9b23bd1ae7a351a81ce4a443142a05867c29eddb724beeff0b5c8dc0409f
-Size (sqlite-src-3430200.zip) = 13929567 bytes
+BLAKE2s (sqlite-src-3440000.zip) = 0a4f2e7b93d39f74e704376d9bee89e0aa4b982829b0a1fc8480337618a232c2
+SHA512 (sqlite-src-3440000.zip) = 3376d42b5f78afa028e4112ec545b5dd63b38188368046b92f0ebc536fd3ba909b0fdf6cd36f4d2de1d08a5eb3aa29a723f368adfa7208a5c737a04e878ca0d4
+Size (sqlite-src-3440000.zip) = 14059695 bytes