- Update to: 3.43.1

* Fix a regression in the way that the sum(), avg(), and total()
    aggregate functions handle infinities.
  * Fix a bug in the json_array_length() function that occurs when
    the argument comes directly from json_remove().
  * Fix the omit-unused-subquery-columns optimization (introduced
    in in version 3.42.0) so that it works correctly if the
    subquery is a compound where one arm is DISTINCT and the other
    is not.

OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=316

sqlite-doc-3430000.zip

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:e88f98c5651f996e989ef3b7122ed29b01bd2a0100b0aa72dd96013248442291
-size 10663888

sqlite-doc-3430100.zip

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:de4e2b6489f3ef4f7068c77d9df11a7c099851cd2431c457c88ee194eb56d41d
+size 10668827

sqlite-src-3430000.zip

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:976c31a5a49957a7a8b11ab0407af06b1923d01b76413c9cf1c9f7fc61a3501c
-size 13927457

sqlite-src-3430100.zip

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:22e9c2ef49fe6f8a2dbc93c4d3dce09c6d6a4f563de52b0a8171ad49a8c72917
+size 13928044

sqlite3.changes

@@ -1,22 +1,51 @@
+-------------------------------------------------------------------
+Mon Sep 11 14:36:02 UTC 2023 - Reinhard Max <max@suse.com>
+
+- Update to: 3.43.1
+  * Fix a regression in the way that the sum(), avg(), and total()
+    aggregate functions handle infinities.
+  * Fix a bug in the json_array_length() function that occurs when
+    the argument comes directly from json_remove().
+  * Fix the omit-unused-subquery-columns optimization (introduced
+    in in version 3.42.0) so that it works correctly if the
+    subquery is a compound where one arm is DISTINCT and the other
+    is not.
+
 -------------------------------------------------------------------
 Sat Aug 26 14:38:21 UTC 2023 - Andrea Manzini <andrea.manzini@suse.com>
 
 - Update to 3.43.0:
-  * Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being indexed while also allowing records to be deleted.
+  * Add support for Contentless-Delete FTS5 Indexes. This is a
+    variety of FTS5 full-text search index that omits storing the
+    content that is being indexed while also allowing records to
+    be deleted.
   * Enhancements to the date and time functions:
-    + Added new time shift modifiers of the form ±YYYY-MM-DD HH:MM:SS.SSS.
+    + Added new time shift modifiers of the form
+      ±YYYY-MM-DD HH:MM:SS.SSS.
     + Added the timediff() SQL function.
   * Added the octet_length(X) SQL function.
   * Added the sqlite3_stmt_explain() API.
   * Query planner enhancements:
-    + Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength reduction.
+    + Generalize the LEFT JOIN strength reduction optimization so
-    + Enhance the theorem prover in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives.
+      that it works for RIGHT and FULL JOINs as well. Rename it to
+      OUTER JOIN strength reduction.
+    + Enhance the theorem prover in the OUTER JOIN strength
+      reduction optimization so that it returns fewer
+      false-negatives.
   * Enhancements to the decimal extension:
-    + New function decimal_pow2(N) returns the N-th power of 2 for integer N between -20000 and +20000.
+    + New function decimal_pow2(N) returns the N-th power of 2 for
-    + New function decimal_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" at the end.
+      integer N between -20000 and +20000.
-    + If X is a floating-point value, then the decimal(X) function now does a full expansion of that value into its exact decimal equivalent.
+    + New function decimal_exp(X) works like decimal(X) except that
-  * Performance enhancements to JSON processing results in a 2x performance improvement for some kinds of processing on large JSON strings.
+      it returns the result in exponential notation - with a "e+NN"
-  * The VFS for unix now assumes that the nanosleep() system call is available unless compiled with -DHAVE_NANOSLEEP=0.
+      at the end.
+    + If X is a floating-point value, then the decimal(X) function
+      now does a full expansion of that value into its exact
+      decimal equivalent.
+  * Performance enhancements to JSON processing results in a 2x
+    performance improvement for some kinds of processing on large
+    JSON strings.
+  * The VFS for unix now assumes that the nanosleep() system call
+    is available unless compiled with -DHAVE_NANOSLEEP=0.
 
 -------------------------------------------------------------------
 Wed May 17 08:23:04 UTC 2023 - Reinhard Max <max@suse.com>

sqlite3.spec

@@ -17,11 +17,11 @@
 
 
 %define oname sqlite
-%define tarversion 3430000
+%define tarversion 3430100
 %bcond_with icu
 %bcond_without check
 Name:           sqlite3
-Version:        3.43.0
+Version:        3.43.1
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain