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-07-14 16:33:25 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/sqlite3 (Old) and /work/SRC/openSUSE:Factory/.sqlite3.new.1523 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "sqlite3" Thu Jul 14 16:33:25 2022 rev:134 rq:989013 version:3.39.0 Changes: -------- --- /work/SRC/openSUSE:Factory/sqlite3/sqlite3.changes 2022-05-14 22:52:11.306992870 +0200 +++ /work/SRC/openSUSE:Factory/.sqlite3.new.1523/sqlite3.changes 2022-07-14 16:33:32.756587009 +0200 @@ -1,0 +2,27 @@ +Fri Jul 1 21:10:07 UTC 2022 - Andreas Stieger <andreas.stie...@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 + +------------------------------------------------------------------- Old: ---- sqlite-doc-3380500.zip sqlite-src-3380100-atof1.patch sqlite-src-3380500.zip New: ---- sqlite-doc-3390000.zip sqlite-src-3390000-func7-pg-181.patch sqlite-src-3390000.zip ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ sqlite3.spec ++++++ --- /var/tmp/diff_new_pack.rCjsIc/_old 2022-07-14 16:33:33.312587530 +0200 +++ /var/tmp/diff_new_pack.rCjsIc/_new 2022-07-14 16:33:33.316587534 +0200 @@ -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 @@ 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 @@ %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 ++++++ sqlite-src-3390000-func7-pg-181.patch ++++++ From: Andreas Stieger <andreas.stie...@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}
