Accepting request 1238215 from server:database

- Update to release 3.48.0:
  * Improved EXPLAIN QUERY PLAN output for covering indexes.
  * Allow a two-argument version of the iif() SQL function.
  * Also allow if() as an alternative spelling for iif().
  * Add the ".dbtotxt" command to the CLI.
  * Add the SQLITE_IOCAP_SUBPAGE_READ property to the
    xDeviceCharacteristics method of the sqlite3_io_methods object.
  * Add the SQLITE_PREPARE_DONT_LOG option to sqlite3_prepare_v3()
    that prevents warning messages being sent to the error log if
    the SQL is ill-formed. This allows sqlite3_prepare_v3() to be
    used to do test compiles of SQL to check for validity without
    polluting the error log with false messages.
  * Increase the minimum allowed value of SQLITE_LIMIT_LENGTH from
    1 to 30.
  * Added the SQLITE_FCNTL_NULL_IO file control.
  * Extend the FTS5 auxiliary API xInstToken() to work with prefix
    queries via the insttoken configuration option and the
    fts5_insttoken() SQL function.
  * Increase the maximum number of arguments to an SQL function
    from 127 to 1000.
  * Obsoletes sqlite3-6216bfcb.patch .
- Re-enable SONAME which got disabled by default in 3.48.0.
  * https://www.sqlite.org/src/forumpost/5a3b44f510df8ded
  * https://sqlite.org/forum/forumpost/ab8f15697a  

- Update to release 3.48.0:
  * Improved EXPLAIN QUERY PLAN output for covering indexes.
  * Allow a two-argument version of the iif() SQL function.
  * Also allow if() as an alternative spelling for iif().
  * Add the ".dbtotxt" command to the CLI.

OBS-URL: https://build.opensuse.org/request/show/1238215
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=157

sqlite-doc-3470200.zip

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

sqlite-src-3470200.zip

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

sqlite3-6216bfcb.patch

@@ -1,46 +0,0 @@
-Index: test/fts3corrupt4.test
-==================================================================
---- test/fts3corrupt4.test
-+++ test/fts3corrupt4.test
-@@ -4401,14 +4401,36 @@
- do_catchsql_test 25.5 {
-   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x%1 FROM c WHERE x<599237)
-     INSERT INTO t1( a ) SELECT randomblob(3000) FROM t2 ;
- } {0 {}}
- 
--do_catchsql_test 25.6 {
--  INSERT INTO t1(t1) SELECT x FROM t2;
--  INSERT INTO t1(t1) SELECT x FROM t2;
--} {1 {database disk image is malformed}}
-+if {$tcl_platform(byteOrder)=="littleEndian"} {
-+  # The SQLITE_CORRUPT error depends on the specific random byte
-+  # sequence generated by SQLite's PRNG.  But the SQLite PRNG
-+  # uses ChaCha20, which generates a different byte sequence on
-+  # big-endian and little-endian platforms.  The SQLITE_CORRUPT
-+  # error only comes up when the pseudo-random byte sequence is
-+  # the one generated on little-endian platforms.
-+  #
-+  # See Forum thread:
-+  # https://sqlite.org/forum/forumpost/b5f89d813babfd88
-+  #
-+  do_catchsql_test 25.6a {
-+    INSERT INTO t1(t1) SELECT x FROM t2;
-+  } {1 {database disk image is malformed}}
-+  do_catchsql_test 25.6b {
-+    INSERT INTO t1(t1) SELECT x FROM t2;
-+  } {1 {database disk image is malformed}}
-+} else {
-+  do_catchsql_test 25.6a {
-+    INSERT INTO t1(t1) SELECT x FROM t2;
-+  } {0 {}}
-+  do_catchsql_test 25.6b {
-+    INSERT INTO t1(t1) SELECT x FROM t2;
-+  } {0 {}}
-+}
-+
- 
- #-------------------------------------------------------------------------
- reset_db
- do_test 26.0 {
-   sqlite3 db {}
-

sqlite3.changes

@@ -1,3 +1,35 @@
+-------------------------------------------------------------------
+Thu Jan 16 10:39:29 UTC 2025 - Reinhard Max <max@suse.com>
+
+- Re-enable SONAME which got disabled by default in 3.48.0.
+  * https://www.sqlite.org/src/forumpost/5a3b44f510df8ded
+  * https://sqlite.org/forum/forumpost/ab8f15697a  
+
+-------------------------------------------------------------------
+Tue Jan 14 15:44:26 UTC 2025 - Reinhard Max <max@suse.com>
+
+- Update to release 3.48.0:
+  * Improved EXPLAIN QUERY PLAN output for covering indexes.
+  * Allow a two-argument version of the iif() SQL function.
+  * Also allow if() as an alternative spelling for iif().
+  * Add the ".dbtotxt" command to the CLI.
+  * Add the SQLITE_IOCAP_SUBPAGE_READ property to the
+    xDeviceCharacteristics method of the sqlite3_io_methods object.
+  * Add the SQLITE_PREPARE_DONT_LOG option to sqlite3_prepare_v3()
+    that prevents warning messages being sent to the error log if
+    the SQL is ill-formed. This allows sqlite3_prepare_v3() to be
+    used to do test compiles of SQL to check for validity without
+    polluting the error log with false messages.
+  * Increase the minimum allowed value of SQLITE_LIMIT_LENGTH from
+    1 to 30.
+  * Added the SQLITE_FCNTL_NULL_IO file control.
+  * Extend the FTS5 auxiliary API xInstToken() to work with prefix
+    queries via the insttoken configuration option and the
+    fts5_insttoken() SQL function.
+  * Increase the maximum number of arguments to an SQL function
+    from 127 to 1000.
+  * Obsoletes sqlite3-6216bfcb.patch .
+
 -------------------------------------------------------------------
 Mon Dec 16 15:40:43 UTC 2024 - Reinhard Max <max@suse.com>
 

sqlite3.spec

@@ -1,7 +1,7 @@
 #
 # spec file for package sqlite3
 #
-# Copyright (c) 2024 SUSE LLC
+# Copyright (c) 2025 SUSE LLC
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -17,12 +17,12 @@
 
 
 %define oname sqlite
-%define tarversion 3470200
+%define tarversion 3480000
-%define docversion 3470200
+%define docversion 3480000
 %bcond_with icu
 %bcond_without check
 Name:           sqlite3
-Version:        3.47.2
+Version:        3.48.0
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
@@ -31,7 +31,6 @@ URL:            https://www.sqlite.org/
 Source0:        https://www.sqlite.org/2023/sqlite-src-%{tarversion}.zip
 Source1:        baselibs.conf
 Source2:        https://www.sqlite.org/2023/sqlite-doc-%{docversion}.zip
-Patch0:         sqlite3-6216bfcb.patch
 BuildRequires:  automake
 BuildRequires:  libtool
 BuildRequires:  pkgconfig
@@ -170,6 +169,7 @@ export CFLAGS="%{optflags} \
 	-DSQLITE_STRICT_SUBTYPE=1 \
 	"
 %configure \
+  --soname=legacy \
   --disable-static \
   --enable-readline \
   --enable-fts3 \