- Update to 3.41.0:

* https://www.sqlite.org/releaselog/3_41_0.html
  * Various query planner improvements.
  * Add the built-in unhex() SQL function.
  * Add the base64 and base85 application-defined functions as an
    extension and include that extension in the CLI.
  * In-memory databases created using sqlite3_deserialize() now
    report their filename as an empty string, not as 'x'.
  * The ".scanstats est" command provides query planner estimates
    in profiles.
  * Enhance the --safe command-line option to disallow dangerous
    SQL functions.
  * The double-quoted string misfeature is now disabled by default
    for CLI builds.
  * Various other improvements and performance enhancements.

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

sqlite-doc-3400100.zip

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

sqlite-doc-3410000.zip

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

sqlite-src-3390000-func7-pg-181.patch

@@ -1,28 +0,0 @@
-From: Andreas Stieger <Andreas.Stieger@gmx.de>
-Subject: [PATCH] skip float precision related test failures on 32 bit
-Date: Fri, 01 Jul 2022 21:12:29 +0000
-Upstream: no
-
-Introduced by: https://sqlite.org/src/info/c48a735bd4a1dbd5
-Upstream thread: https://sqlite.org/forum/forumpost/dd4767885a
-
-[  642s] ! func7-pg-181 expected: [2.000000000000000000000000000000]
-[  642s] ! func7-pg-181 got:      [1.999999999999999000000000000000]
-
-Index: sqlite-src-3390000/test/func7.test
-===================================================================
---- sqlite-src-3390000.orig/test/func7.test
-+++ sqlite-src-3390000/test/func7.test
-@@ -60,12 +60,6 @@ do_execsql_test func7-pg-170 {
- do_execsql_test func7-pg-180 {
-   SELECT log10(1000.0)
- } {3.0}
--do_execsql_test func7-pg-181 {
--  SELECT format('%.30f', log10(100.0) );
--} {2.000000000000000000000000000000}
--do_execsql_test func7-pg-182 {
--  SELECT format('%.30f', ln(exp(2.0)) );
--} {2.000000000000000000000000000000}
- do_execsql_test func7-pg-190 {
-   SELECT log(2.0, 64.0)
- } {6.0}

sqlite-src-3400100.zip

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

sqlite-src-3410000.zip

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

sqlite3.changes

@@ -1,3 +1,22 @@
+-------------------------------------------------------------------
+Wed Feb 22 09:42:51 UTC 2023 - Reinhard Max <max@suse.com>
+
+- Update to 3.41.0:
+  * https://www.sqlite.org/releaselog/3_41_0.html
+  * Various query planner improvements.
+  * Add the built-in unhex() SQL function.
+  * Add the base64 and base85 application-defined functions as an
+    extension and include that extension in the CLI.
+  * In-memory databases created using sqlite3_deserialize() now
+    report their filename as an empty string, not as 'x'.
+  * The ".scanstats est" command provides query planner estimates
+    in profiles.
+  * Enhance the --safe command-line option to disallow dangerous
+    SQL functions.
+  * The double-quoted string misfeature is now disabled by default
+    for CLI builds.
+  * Various other improvements and performance enhancements.
+
 -------------------------------------------------------------------
 Wed Dec 28 21:37:44 UTC 2022 - Andreas Stieger <andreas.stieger@gmx.de>
 

sqlite3.spec

@@ -1,7 +1,7 @@
 #
 # spec file for package sqlite3
 #
-# Copyright (c) 2022 SUSE LLC
+# Copyright (c) 2023 SUSE LLC
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -17,11 +17,11 @@
 
 
 %define oname sqlite
-%define tarversion 3400100
+%define tarversion 3410000
 %bcond_with icu
 %bcond_without check
 Name:           sqlite3
-Version:        3.40.1
+Version:        3.41.0
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
@@ -30,7 +30,6 @@ URL:            https://www.sqlite.org/
 Source0:        https://www.sqlite.org/2022/sqlite-src-%{tarversion}.zip
 Source1:        baselibs.conf
 Source2:        https://www.sqlite.org/2022/sqlite-doc-%{tarversion}.zip
-Patch0:         sqlite-src-3390000-func7-pg-181.patch
 BuildRequires:  automake
 BuildRequires:  libtool
 BuildRequires:  pkgconfig
@@ -128,7 +127,6 @@ other documentation found on sqlite.org. The files can be found in
 
 %prep
 %setup -q -n sqlite-src-%{tarversion} -a2
-%patch0 -p1
 
 rm -v sqlite-doc-%{tarversion}/releaselog/current.html
 ln -sv `echo %{version} | sed "s/\./_/g"`.html sqlite-doc-%{tarversion}/releaselog/current.html