Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package sqlite3 for openSUSE:Factory checked in at 2022-03-15 19:04:12 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/sqlite3 (Old) and /work/SRC/openSUSE:Factory/.sqlite3.new.25692 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "sqlite3" Tue Mar 15 19:04:12 2022 rev:130 rq:961697 version:3.38.1 Changes: -------- --- /work/SRC/openSUSE:Factory/sqlite3/sqlite3.changes 2022-01-20 00:11:59.786562781 +0100 +++ /work/SRC/openSUSE:Factory/.sqlite3.new.25692/sqlite3.changes 2022-03-15 19:04:38.484936784 +0100 @@ -1,0 +2,43 @@ +Sun Mar 13 16:25:42 UTC 2022 - Andreas Stieger <andreas.stie...@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.stie...@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 + +------------------------------------------------------------------- Old: ---- sqlite-doc-3370200.zip sqlite-src-3370200.zip New: ---- sqlite-doc-3380100.zip sqlite-src-3380100-atof1.patch sqlite-src-3380100.zip ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ sqlite3.spec ++++++ --- /var/tmp/diff_new_pack.Xy33AC/_old 2022-03-15 19:04:39.208937274 +0100 +++ /var/tmp/diff_new_pack.Xy33AC/_new 2022-03-15 19:04:39.208937274 +0100 @@ -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 @@ 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 @@ %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 ++++++ sqlite-src-3380100-atof1.patch ++++++ 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)}]
