Accepting request 1227134 from server:database

- 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.

- 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

OBS-URL: https://build.opensuse.org/request/show/1227134
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=154

sqlite-doc-3460100.zip

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:e969131f93ca79fbc64d57724a1035735881555a52600dbe69c69eab72c9fcd1
-size 10851427

sqlite-doc-3470100.zip

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:f9dec8e563db0de0a8171a107f58f71456c16913048082934951d25fddfe4dad
+size 10945765

sqlite-src-3460100.zip

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:def3fc292eb9ecc444f6c1950e5c79d8462ed5e7b3d605fd6152d145e1d5abb4
-size 14276926

sqlite-src-3470100.zip

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:572457f02b03fea226a6cde5aafd55a0a6737786bcb29e3b85bfb21918b52ce7
+size 14415832

sqlite3.changes

@@ -1,3 +1,89 @@
+-------------------------------------------------------------------
+Wed Nov 27 10:09:03 UTC 2024 - Reinhard Max <max@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 <max@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.
+
 -------------------------------------------------------------------
 Tue Sep 24 11:36:12 UTC 2024 - Reinhard Max <max@suse.com>
 

sqlite3.spec

@@ -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 @@ cmp sqlite-doc-%{docversion}/fileformat{,2}.html && ln -sf fileformat.html sqlit
 
 %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 \