Accepting request 986280 from home:AndreasStieger:branches:server:database

sqlite3 3.39.0

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

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.zip

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

sqlite3.changes

@@ -1,3 +1,28 @@
+-------------------------------------------------------------------
+Fri Jul  1 19:31:59 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
+
 -------------------------------------------------------------------
 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,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-3380100-atof1.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 -p0
 
 rm -v sqlite-doc-%{tarversion}/releaselog/current.html
 ln -sv `echo %{version} | sed "s/\./_/g"`.html sqlite-doc-%{tarversion}/releaselog/current.html