Accepting request 989013 from server:database

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

sqlite-doc-3380500.zip

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

sqlite-doc-3390000.zip

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

sqlite-src-3380100-atof1.patch

@@ -1,26 +0,0 @@
-Subject: Only run atof1.test on x86_64 machines. 
-Date: 2022-03-10 11:48:16
-From: drh@
-References: https://www3.sqlite.org/cgi/src/vinfo/4173819cd285a1c1?diff=1
-
-
-Index: test/atof1.test
-==================================================================
---- test/atof1.test
-+++ test/atof1.test
-@@ -16,10 +16,14 @@
- source $testdir/tester.tcl
- 
- if {$::longdouble_size<=8} {
-   finish_test
-   return
-+}
-+if {$::tcl_platform(machine)!="x86_64"} {
-+  finish_test
-+  return
- }
- 
- expr srand(1)
- for {set i 1} {$i<20000} {incr i} {
-   set pow [expr {int((rand()-0.5)*100)}]
-

sqlite-src-3380500.zip

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

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

@@ -0,0 +1,28 @@
+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-3390000.zip

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

sqlite3.changes

@@ -1,3 +1,30 @@
+-------------------------------------------------------------------
+Fri Jul  1 21:10:07 UTC 2022 - Andreas Stieger <andreas.stieger@gmx.de>
+
+- update to 3.39.0:
+  * Add (long overdue) support for RIGHT and FULL OUTER JOIN
+  * Add new binary comparison operators IS NOT DISTINCT FROM and 
+    IS DISTINCT FROM that are equivalent to IS and IS NOT, 
+    respective, for compatibility with PostgreSQL and SQL standards
+  * Add a new return code (value "3") from the sqlite3_vtab_distinct()
+    interface that indicates a query that has both DISTINCT and 
+    ORDER BY clauses
+  * Added the sqlite3_db_name() interface
+  * The unix os interface resolves all symbolic links in database
+    filenames to create a canonical name for the database before
+    the file is opened
+  * Defer materializing views until the materialization is actually
+    needed, thus avoiding unnecessary work if the materialization
+    turns out to never be used
+  * The HAVING clause of a SELECT statement is now allowed on any
+    aggregate query, even queries that do not have a GROUP BY
+    clause
+  * Many microoptimizations collectively reduce CPU cycles by about
+    2.3%. 
+- drop sqlite-src-3380100-atof1.patch, included upstream
+- add sqlite-src-3390000-func7-pg-181.patch to skip float precision
+  related test failures on 32 bit
+
 -------------------------------------------------------------------
 Sun May  8 10:00:51 UTC 2022 - Andreas Stieger <andreas.stieger@gmx.de>
 

sqlite3.spec

@@ -17,11 +17,11 @@
 
 
 %define oname sqlite
-%define tarversion 3380500
+%define tarversion 3390000
 %bcond_with icu
 %bcond_without check
 Name:           sqlite3
-Version:        3.38.5
+Version:        3.39.0
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
@@ -30,7 +30,7 @@ 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-3380100-atof1.patch
+Patch0:         sqlite-src-3390000-func7-pg-181.patch
 BuildRequires:  automake
 BuildRequires:  libtool
 BuildRequires:  pkgconfig
@@ -128,7 +128,7 @@ other documentation found on sqlite.org. The files can be found in
 
 %prep
 %setup -q -n sqlite-src-%{tarversion} -a2
-%patch0 -p0
+%autopatch -p1
 
 rm -v sqlite-doc-%{tarversion}/releaselog/current.html
 ln -sv `echo %{version} | sed "s/\./_/g"`.html sqlite-doc-%{tarversion}/releaselog/current.html