Accepting request 1106058 from home:amanzini:branches:server:database

- 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.
  * Enhancements to the date and time functions:
    + 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.
    + 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_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" 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.

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

sqlite-doc-3420000.zip

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

sqlite-doc-3430000.zip

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

sqlite-src-3420000.zip

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

sqlite-src-3430000.zip

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

sqlite3.changes

@@ -1,3 +1,23 @@
+-------------------------------------------------------------------
+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.
+  * Enhancements to the date and time functions:
+    + 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.
+    + 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_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" 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 3420000
+%define tarversion 3430000
 %bcond_with icu
 %bcond_without check
 Name:           sqlite3
-Version:        3.42.0
+Version:        3.43.0
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain