Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package sqlite3 for openSUSE:Factory checked in at 2025-12-02 13:18:34 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/sqlite3 (Old) and /work/SRC/openSUSE:Factory/.sqlite3.new.14147 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "sqlite3" Tue Dec 2 13:18:34 2025 rev:170 rq:1320534 version:3.51.1 Changes: -------- --- /work/SRC/openSUSE:Factory/sqlite3/sqlite3.changes 2025-10-23 16:35:47.870226014 +0200 +++ /work/SRC/openSUSE:Factory/.sqlite3.new.14147/sqlite3.changes 2025-12-02 13:18:56.067775469 +0100 @@ -1,0 +2,73 @@ +Fri Nov 28 20:49:24 UTC 2025 - Reinhard Max <[email protected]> + +- Update to version 3.51.1: + * Fix incorrect results from nested EXISTS queries caused by the + optimization in item 6b in the 3.51.0 release. + * Fix a latent bug in fts5vocab virtual table, exposed by new + optimizations in the 3.51.0 release + +- Changes in version 3.51.0: + * New macros in sqlite3.h: + - SQLITE_SCM_BRANCH → the name of the branch from which the + source code is taken. + - SQLITE_SCM_TAGS → space-separated list of tags on the source + code check-in. + - SQLITE_SCM_DATETIME → ISO-8601 date and time of the source + code check-in. + * Two new JSON functions, jsonb_each() and jsonb_tree() work the + same as the existing json_each() and json_tree() functions + except that they return JSONB for the "value" column when the + "type" is 'array' or 'object'. + * The carray and percentile extensions are now built into the + amalgamation, though they are disabled by default and must be + activated at compile-time using the -DSQLITE_ENABLE_CARRAY + and/or -DSQLITE_ENABLE_PERCENTILE options, respectively. + * Enhancements to TCL Interface: + - Add the -asdict flag to the eval command to have it set the + row data as a dict instead of an array. + - User-defined functions may now break to return an SQL NULL. + * CLI enhancements: + - Increase the precision of ".timer" to microseconds. + - Enhance the "box" and "column" formatting modes to deal with + double-wide characters. + - The ".imposter" command provides read-only imposter tables + that work with VACUUM and do not require the --unsafe-testing + option. + - Add the --ifexists option to the CLI command-line option and + to the .open command. + - Limit columns widths set by the ".width" command to 30,000 or + less, as there is not good reason to have wider columns, but + supporting wider columns provides opportunity to malefactors. + * Performance enhancements: + - Use fewer CPU cycles to commit a read transaction. + - Early detection of joins that return no rows due to one or + more of the tables containing no rows. + - Avoid evaluation of scalar subqueries if the result of the + subquery does not change the result of the overall expression. + - Faster window function queries when using + "BETWEEN :x FOLLOWING AND :y FOLLOWING" with a large :y. + * Add the PRAGMA wal_checkpoint=NOOP; command and the + SQLITE_CHECKPOINT_NOOP argument for sqlite3_wal_checkpoint_v2(). + * Add the sqlite3_set_errmsg() API for use by extensions. + * Add the sqlite3_db_status64() API, which works just like the + existing sqlite3_db_status() API except that it returns 64-bit + results. + * Add the SQLITE_DBSTATUS_TEMPBUF_SPILL option to the + sqlite3_db_status() and sqlite3_db_status64() interfaces. + * In the session extension add the sqlite3changeset_apply_v3() + interface. + * For the built-in printf() and the format() SQL function, omit + the leading '-' from negative floating point numbers if the '+' + flag is omitted and the "#" flag is present and all displayed + digits are '0'. Use '%#f' or similar to avoid outputs like + '-0.00' and instead show just '0.00'. + * Improved error messages generated by FTS5. + * Enforce STRICT typing on computed columns. + * Improved support for VxWorks + * JavaScript/WASM now supports 64-bit WASM. The canonical builds + continue to be 32-bit but creating one's own 64-bit build is + now as simple as running "make". + * Improved resistance to database corruption caused by an + application breaking Posix advisory locks using close(). + +------------------------------------------------------------------- Old: ---- sqlite-doc-3500400.zip sqlite-src-3500400.zip New: ---- sqlite-doc-3510100.zip sqlite-src-3510100.zip ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ sqlite3.spec ++++++ --- /var/tmp/diff_new_pack.aM8LHa/_old 2025-12-02 13:18:57.439833075 +0100 +++ /var/tmp/diff_new_pack.aM8LHa/_new 2025-12-02 13:18:57.443833243 +0100 @@ -19,12 +19,12 @@ %define _buildshell /bin/bash %define oname sqlite -%define tarversion 3500400 -%define docversion 3500400 +%define tarversion 3510100 +%define docversion 3510100 %bcond_with icu %bcond_without check Name: sqlite3 -Version: 3.50.4 +Version: 3.51.1 Release: 0 Summary: Embeddable SQL Database Engine License: SUSE-Public-Domain @@ -208,7 +208,6 @@ %install %make_install install -Dpvm 0644 -t %{buildroot}/%{_mandir}/man1 sqlite3.1 -install -Dpvm 0644 -t %{buildroot}/%{_mandir}/mann autoconf/tea/doc/sqlite3.n install -Dpvm 0755 -t %{buildroot}%{_bindir} lemon install -Dpvm 0644 -t %{buildroot}%{_datadir}/lemon tool/lempar.c # tcl bindings are provided by tcl itself @@ -233,7 +232,6 @@ %files tcl %tcl_archdir/* -%doc %_mandir/mann/* %files doc %doc sqlite-doc-%{docversion}/* ++++++ sqlite-doc-3500400.zip -> sqlite-doc-3510100.zip ++++++ /work/SRC/openSUSE:Factory/sqlite3/sqlite-doc-3500400.zip /work/SRC/openSUSE:Factory/.sqlite3.new.14147/sqlite-doc-3510100.zip differ: char 11, line 2 ++++++ sqlite-src-3500400.zip -> sqlite-src-3510100.zip ++++++ /work/SRC/openSUSE:Factory/sqlite3/sqlite-src-3500400.zip /work/SRC/openSUSE:Factory/.sqlite3.new.14147/sqlite-src-3510100.zip differ: char 11, line 2
