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-11-30 13:27:12
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/sqlite3 (Old)
and /work/SRC/openSUSE:Factory/.sqlite3.new.28523 (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "sqlite3"
Sat Nov 30 13:27:12 2024 rev:154 rq:1227134 version:3.47.1
Changes:
--------
--- /work/SRC/openSUSE:Factory/sqlite3/sqlite3.changes 2024-10-31
16:09:33.467545142 +0100
+++ /work/SRC/openSUSE:Factory/.sqlite3.new.28523/sqlite3.changes
2024-11-30 13:27:19.836417808 +0100
@@ -1,0 +2,86 @@
+Wed Nov 27 10:09:03 UTC 2024 - Reinhard Max <m...@suse.com>
+
+- Update to release 3.47.1:
+ * Fix the makefiles so that they once again honored DESTDIR for
+ the "install" target.
+ * Add the SQLITE_IOCAP_SUBPAGE_READ capability to the VFS, to
+ work around issues on some non-standard VFSes caused by making
+ SQLITE_DIRECT_OVERFLOW_READ the default in version 3.45.0.
+ * Fix incorrect answers to certain obscure IN queries caused by
+ new query optimizations added in the 3.47.0 release.
+ * Other minor bug fixes.
+
+-------------------------------------------------------------------
+Tue Oct 22 16:05:19 UTC 2024 - Reinhard Max <m...@suse.com>
+
+- Update to release 3.47.0:
+ * Allow arbitrary expressions in the second argument to the RAISE
+ function.
+ * If the RHS of the ->> operator is negative, then access array
+ elements counting from the right.
+ * Fix a problem with rolling back hot journal files in the
+ seldom-used unix-dotfile VFS.
+ * FTS5 tables can now be dropped even if they use a non-standard
+ tokenizer that has not been registered.
+ * Fix the group_concat() aggregate function so that it returns an
+ empty string, not a NULL, if it receives a single input value
+ which is an empty string.
+ * Enhance the generate_series() table-valued function so that it
+ is able to recognize and use constraints on its output value.
+ Preupdate hooks now recognize when a column added by ALTER
+ TABLE ADD COLUMN has a non-null default value.
+ * Improved reuse of subqueries associated with the IN operator,
+ especially when the IN operator has been duplicated due to
+ predicate push-down.
+ * Use a Bloom filter on subqueries on the right-hand side of the
+ IN operator, in cases where that seems likely to improve
+ performance.
+ * Ensure that queries like "SELECT func(a) FROM tab GROUP BY 1"
+ only invoke the func() function once per row.
+ * No attempt is made to create automatic indexes on a column
+ that is known to be non-selective because of its use in other
+ indexes that have been analyzed.
+ * Adjustments to the query planner so that it produces better
+ plans for star queries with a large number of dimension
+ tables.
+ * Add the "order-by-subquery" optimization, that seeks to
+ disable sort operations in outer queries if the desired order
+ is obtained naturally due to ORDER BY clauses in subqueries.
+ * The "indexed-subtype-expr" optimization strives to use
+ expressions that are part of an index rather than recomputing
+ the expression based on table values, as long as the query
+ planner can prove that the subtype of the expression will
+ never be used.
+ * Miscellaneous coding tweaks for faster runtimes.
+ * Add the experimental sqlite3_rsync program.
+ * Add extension functions median(), percentile(),
+ percentile_cont(), and percentile_disc() to the CLI.
+ * Add the .www dot-command to the CLI.
+ * The sqlite3_analyzer utility now provides a break-out of
+ statistics for WITHOUT ROWID tables.
+ * The sqldiff utility avoids creating an empty database if its
+ second argument does not exist.
+ * Enhance the sqlite_dbpage table-valued function such that
+ INSERT can be used to increase or decrease the size of the
+ database file.
+ * SQLite no longer makes any use of the "long double" data type,
+ as hardware support for long double is becoming less common
+ and long double creates challenges for some compiler tool
+ chains. Instead, SQLite uses Dekker's algorithm when extended
+ precision is needed.
+ * The TCL Interface for SQLite supports TCL9. Everything
+ probably still works for TCL 8.5 and later, though this is not
+ guaranteed. Users are encouraged to upgrade to TCL9.
+ * Fix a corruption-causing bug in the JavaScript "opfs" VFS.
+ Correct "mode=ro" handling for the "opfs" VFS. Work around a
+ couple of browser-specific OPFS quirks.
+ * Add the fts5_tokenizer_v2 API and the locale=1 option, for
+ creating custom locale-aware tokenizers and fts5 tables that
+ may take advantage of them.
+ * Add the contentless_unindexed=1 option, for creating
+ contentless fts5 tables that store the values of any UNINDEXED
+ columns persistently in the database.
+ * Allow an FTS5 table to be dropped even if it uses a custom
+ tokenizer whose implementation is not available.
+
+-------------------------------------------------------------------
Old:
----
sqlite-doc-3460100.zip
sqlite-src-3460100.zip
New:
----
sqlite-doc-3470100.zip
sqlite-src-3470100.zip
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Other differences:
------------------
++++++ sqlite3.spec ++++++
--- /var/tmp/diff_new_pack.mUfbKM/_old 2024-11-30 13:27:20.392440967 +0100
+++ /var/tmp/diff_new_pack.mUfbKM/_new 2024-11-30 13:27:20.392440967 +0100
@@ -17,12 +17,12 @@
%define oname sqlite
-%define tarversion 3460100
-%define docversion 3460100
+%define tarversion 3470100
+%define docversion 3470100
%bcond_with icu
%bcond_without check
Name: sqlite3
-Version: 3.46.1
+Version: 3.47.1
Release: 0
Summary: Embeddable SQL Database Engine
License: SUSE-Public-Domain
@@ -145,7 +145,8 @@
%build
export TCLLIBDIR=%tcl_archdir/sqlite%version
-export LIBS="$LIBS -lm %{?with_icu:-licuuc -licui18n}"
+export CC=gcc
+export CC_FOR_BUILD=gcc
export CFLAGS="%{optflags} \
-DSQLITE_ENABLE_API_ARMOR \
-DSQLITE_ENABLE_COLUMN_METADATA \
++++++ sqlite-doc-3460100.zip -> sqlite-doc-3470100.zip ++++++
/work/SRC/openSUSE:Factory/sqlite3/sqlite-doc-3460100.zip
/work/SRC/openSUSE:Factory/.sqlite3.new.28523/sqlite-doc-3470100.zip differ:
char 11, line 2
++++++ sqlite-src-3460100.zip -> sqlite-src-3470100.zip ++++++
/work/SRC/openSUSE:Factory/sqlite3/sqlite-src-3460100.zip
/work/SRC/openSUSE:Factory/.sqlite3.new.28523/sqlite-src-3470100.zip differ:
char 11, line 2
