Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package sqlite3 for openSUSE:Factory checked in at 2024-03-17 22:13:29 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/sqlite3 (Old) and /work/SRC/openSUSE:Factory/.sqlite3.new.1905 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "sqlite3" Sun Mar 17 22:13:29 2024 rev:150 rq:1158281 version:3.45.2 Changes: -------- --- /work/SRC/openSUSE:Factory/sqlite3/sqlite3.changes 2023-12-15 21:47:13.938047143 +0100 +++ /work/SRC/openSUSE:Factory/.sqlite3.new.1905/sqlite3.changes 2024-03-17 22:13:31.406940129 +0100 @@ -1,0 +2,37 @@ +Tue Mar 12 14:50:27 UTC 2024 - Reinhard Max <m...@suse.com> + +- Update to release 3.45.2: + * Added the SQLITE_RESULT_SUBTYPE property for application- + defined SQL functions. + * Enhancements to the JSON SQL functions + * Add the FTS5 tokendata option to the FTS5 virtual table. + * The SQLITE_DIRECT_OVERFLOW_READ optimization is now enabled by + default. + * Query planner improvements + * Increase the default value for SQLITE_MAX_PAGE_COUNT from + 1073741824 to 4294967294. + * Enhancements to the CLI + * Restore the JSON BLOB input bug, and promise to support the + anomaly in subsequent releases, for backward compatibility. + * Fix the PRAGMA integrity_check command so that it works on + read-only databases that contain FTS3 and FTS5 tables. + * Fix issues associated with processing corrupt JSONB inputs. + * Fix a long-standing bug in which a read of a few bytes past the + end of a memory-mapped segment might occur when accessing a + craftily corrupted database using memory-mapped database. + * Fix a long-standing bug in which a NULL pointer dereference + might occur in the bytecode engine due to incorrect bytecode + being generated for a class of SQL statements that are + deliberately designed to stress the query planner but which + are otherwise pointless. + * Fix an error in UPSERT, introduced in version 3.35.0. + * Reduce the scope of the NOT NULL strength reduction + optimization that was added in version 3.35.0. + +- Add sqlite3-float-i586.patch to fix build on i586. + +- sqlite3-rtree-i686.patch is not needed anymore. + +- Abort build when %version and %tarversion don't match. + +------------------------------------------------------------------- Old: ---- sqlite-doc-3440200.zip sqlite-src-3440200.zip sqlite3-rtree-i686.patch New: ---- sqlite-doc-3450200.zip sqlite-src-3450200.zip sqlite3-float-i586.patch BETA DEBUG BEGIN: Old: - sqlite3-rtree-i686.patch is not needed anymore. BETA DEBUG END: BETA DEBUG BEGIN: New: - Add sqlite3-float-i586.patch to fix build on i586. BETA DEBUG END: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ sqlite3.spec ++++++ --- /var/tmp/diff_new_pack.qk2x0j/_old 2024-03-17 22:13:32.214969693 +0100 +++ /var/tmp/diff_new_pack.qk2x0j/_new 2024-03-17 22:13:32.218969839 +0100 @@ -1,7 +1,7 @@ # # spec file for package sqlite3 # -# Copyright (c) 2023 SUSE LLC +# Copyright (c) 2024 SUSE LLC # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -17,12 +17,12 @@ %define oname sqlite -%define tarversion 3440200 -%define docversion 3440200 +%define tarversion 3450200 +%define docversion 3450200 %bcond_with icu %bcond_without check Name: sqlite3 -Version: 3.44.2 +Version: 3.45.2 Release: 0 Summary: Embeddable SQL Database Engine License: SUSE-Public-Domain @@ -31,7 +31,7 @@ Source0: https://www.sqlite.org/2023/sqlite-src-%{tarversion}.zip Source1: baselibs.conf Source2: https://www.sqlite.org/2023/sqlite-doc-%{docversion}.zip -Patch0: sqlite3-rtree-i686.patch +Patch0: sqlite3-float-i586.patch BuildRequires: automake BuildRequires: libtool BuildRequires: pkgconfig @@ -129,7 +129,15 @@ %{_docdir}/%{name}-doc. %prep -%autosetup -p1 -n sqlite-src-%{tarversion} -a2 +# Version and %tarversion need to match, but %docversion might be different, +IFS=. read a b c d <<< "%version" +if [ "%tarversion" != $(printf "%1d%02d%02d%02d" $a $b $c $d) ] +then + echo "Version %version does not match tarversion %tarversion." + exit 1 +fi + +%autosetup -p0 -n sqlite-src-%{tarversion} -a2 rm -v sqlite-doc-%{docversion}/releaselog/current.html ln -sv `echo %{docversion} | sed "s/\./_/g"`.html sqlite-doc-%{docversion}/releaselog/current.html ++++++ sqlite-doc-3440200.zip -> sqlite-doc-3450200.zip ++++++ /work/SRC/openSUSE:Factory/sqlite3/sqlite-doc-3440200.zip /work/SRC/openSUSE:Factory/.sqlite3.new.1905/sqlite-doc-3450200.zip differ: char 11, line 2 ++++++ sqlite-src-3440200.zip -> sqlite-src-3450200.zip ++++++ /work/SRC/openSUSE:Factory/sqlite3/sqlite-src-3440200.zip /work/SRC/openSUSE:Factory/.sqlite3.new.1905/sqlite-src-3450200.zip differ: char 11, line 2 ++++++ sqlite3-float-i586.patch ++++++ Index: test/func4.test ================================================================== --- test/func4.test +++ test/func4.test @@ -1,6 +1,6 @@ -# 2013 March 10 +# 2023-03-10 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. @@ -7,11 +7,14 @@ # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The focus of -# this file is testing the tointeger() and toreal() functions. +# this file is testing the tointeger() and toreal() functions that are +# part of the "totype.c" extension. This file does not test the core +# SQLite library. Failures of tests in this file are related to the +# ext/misc/totype.c extension. # # Several of the toreal() tests are disabled on platforms where floating # point precision is not high enough to represent their constant integer # expression arguments as double precision floating point values. # @@ -21,10 +24,24 @@ set tcl_precision 0 load_static_extension db totype set highPrecision(1) [expr \ {[db eval {SELECT tointeger(9223372036854775807 + 1);}] eq {{}}}] +set highPrecision(2) [expr \ + {[db eval {SELECT toreal(-9223372036854775808 + 1);}] eq {{}}}] + +# highPrecision(3) is only known to be false on i586 with gcc-13 and -O2. +# It is true on the exact same platform with -O0. Both results seem +# reasonable, so we'll just very the expectation accordingly. +# +set highPrecision(3) [expr \ + {[db eval {SELECT toreal(9007199254740992 + 1);}] eq {{}}}] + +if {!$highPrecision(1) || !$highPrecision(2) || !$highPrecision(3)} { + puts "NOTICE: use_long_double: [use_long_double] \ + highPrecision: $highPrecision(1) $highPrecision(2) $highPrecision(3)" +} do_execsql_test func4-1.1 { SELECT tointeger(NULL); } {{}} do_execsql_test func4-1.2 { @@ -193,12 +210,10 @@ do_execsql_test func4-1.55 { SELECT tointeger(18446744073709551616 + 1); } {{}} ifcapable floatingpoint { - set highPrecision(2) [expr \ - {[db eval {SELECT toreal(-9223372036854775808 + 1);}] eq {{}}}] do_execsql_test func4-2.1 { SELECT toreal(NULL); } {{}} do_execsql_test func4-2.2 { @@ -339,14 +354,18 @@ SELECT toreal(9007199254740992 - 1); } {9007199254740991.0} do_execsql_test func4-2.45 { SELECT toreal(9007199254740992); } {9007199254740992.0} - if {$highPrecision(2)} { + if {$highPrecision(3)} { + do_execsql_test func4-2.46 { + SELECT toreal(9007199254740992 + 1); + } {{}} + } else { do_execsql_test func4-2.46 { SELECT toreal(9007199254740992 + 1); - } {{}} + } {9007199254740992.0} } do_execsql_test func4-2.47 { SELECT toreal(9007199254740992 + 2); } {9007199254740994.0} do_execsql_test func4-2.48 { @@ -624,14 +643,18 @@ SELECT tointeger(toreal(9007199254740992 - 1)); } {9007199254740991} do_execsql_test func4-5.22 { SELECT tointeger(toreal(9007199254740992)); } {9007199254740992} - if {$highPrecision(2)} { + if {$highPrecision(3)} { do_execsql_test func4-5.23 { SELECT tointeger(toreal(9007199254740992 + 1)); } {{}} + } else { + do_execsql_test func4-5.23 { + SELECT tointeger(toreal(9007199254740992 + 1)); + } {9007199254740992} } do_execsql_test func4-5.24 { SELECT tointeger(toreal(9007199254740992 + 2)); } {9007199254740994} if {$highPrecision(1)} {