Accepting request 961697 from server:database

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

sqlite-doc-3370200.zip

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

sqlite-doc-3380100.zip

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

sqlite-src-3370200.zip

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

sqlite-src-3380100-atof1.patch

@@ -0,0 +1,26 @@
+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-3380100.zip

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

sqlite3.changes

@@ -1,3 +1,46 @@
+-------------------------------------------------------------------
+Sun Mar 13 16:25:42 UTC 2022 - Andreas Stieger <andreas.stieger@gmx.de>
+
+- update to 3.38.1:
+  * Fix problems with the new Bloom filter optimization that might
+    cause some obscure queries to get an incorrect answer.
+  * Fix the localtime modifier of the date and time functions so
+    that it preserves fractional seconds.
+  * Fix the sqlite_offset SQL function so that it works correctly
+    even in corner cases such as when the argument is a virtual
+    column or the column of a view.
+  * Fix row value IN operator constraints on virtual tables so that
+    they work correctly even if the virtual table implementation
+    relies on bytecode to filter rows that do not satisfy the
+    constraint.
+  * Other minor fixes to assert() statements, test cases, and
+    documentation. See the source code timeline for details.
+- add upstream patch to run atof1 tests only on x86_64
+  sqlite-src-3380100-atof1.patch
+
+-------------------------------------------------------------------
+Sat Feb 26 11:20:10 UTC 2022 - Andreas Stieger <andreas.stieger@gmx.de>
+
+- update to 3.38.0
+  * Add the -> and ->> operators for easier processing of JSON
+  * The JSON functions are now built-ins
+  * Enhancements to date and time functions
+  * Rename the printf() SQL function to format() for better
+    compatibility, with alias for backwards compatibility.
+  * Add the sqlite3_error_offset() interface for helping localize
+    an SQL error to a specific character in the input SQL text 
+  * Enhance the interface to virtual tables 
+  * CLI columnar output modes are enhanced to correctly handle tabs
+    and newlines embedded in text, and add options like "--wrap N",
+    "--wordwrap on", and "--quote" to the columnar output modes.
+  * Query planner enhancements using a Bloom filter to speed up 
+    large analytic queries, and a balanced merge tree to evaluate
+    UNION or UNION ALL compound SELECT statements that have an
+    ORDER BY clause.
+  * The ALTER TABLE statement is changed to silently ignores
+    entries in the sqlite_schema table that do not parse when
+    PRAGMA writable_schema=ON
+
 -------------------------------------------------------------------
 Wed Jan 12 20:25:08 UTC 2022 - Andreas Stieger <andreas.stieger@gmx.de>
 

sqlite3.spec

@@ -17,10 +17,10 @@
 
 
 %define oname sqlite
-%define tarversion 3370200
+%define tarversion 3380100
 %bcond_with icu
 Name:           sqlite3
-Version:        3.37.2
+Version:        3.38.1
 Release:        0
 Summary:        Embeddable SQL Database Engine
 License:        SUSE-Public-Domain
@@ -29,6 +29,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
 BuildRequires:  automake
 BuildRequires:  libtool
 BuildRequires:  pkgconfig
@@ -114,6 +115,7 @@ 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