From mboxrd@z Thu Jan 1 00:00:00 1970 From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sqlite: Update to version 3410200 Date: Mon, 27 Mar 2023 15:01:47 +0200 Message-ID: <20230327130147.3424542-2-adolf.belka@ipfire.org> In-Reply-To: <20230327130147.3424542-1-adolf.belka@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7436942080931459597==" List-Id: --===============7436942080931459597== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable - Update from version 3400100 to 3410200 - Update of rootfile not required - Changelog 3.41.2 (2023-03-22): Multiple fixes for reads past the end of memory buffers (NB: reads not wr= ites) in the following circumstances: When processing a corrupt database file using the non-standard SQLITE= _ENABLE_STAT4 compile-time option. In the CLI when the sqlite3_error_offset() routine returns an out-of-= range value (see also the fix to sqlite3_error_offset() below). In the recovery extension. In FTS3 when processing a corrupt database file. Fix the sqlite3_error_offset() so that it does not return out-of-range va= lues when reporting errors associated with generated columns. Multiple fixes in the query optimizer for problems that cause incorrect r= esults for bizarre, fuzzer-generated queries. Increase the size of the reference counter in the page cache object to 64= bits to ensure that the counter never overflows. Fix a performance regression caused by a bug fix in patch release 3.41.1. Fix a few incorrect assert() statements. 3.41.1 (2023-03-10): Provide compile-time options -DHAVE_LOG2=3D0 and -DHAVE_LOG10=3D0 to enab= le SQLite to be compiled on systems that omit the standard library functions log2() and = log10(), repectively. Ensure that the datatype for column t1.x in "CREATE TABLE t1 AS SELECT CAST(7 AS INT) AS x;" continues to be INT and= is not NUM, for historical compatibility. Enhance PRAGMA integrity_check to detect when extra bytes appear at the e= nd of an index record. Fix various obscure bugs reported by the user community. See the timeline= of changes for details. 3.41.0 On 2023-02-21 Query planner improvements: Make use of indexed expressions within an aggregate query that includ= es a GROUP BY clause. The query planner has improved awareness of when an index is a coveri= ng index and adjusts predicted runtimes accordingly. The query planner is more aggressive about using co-routines rather t= han materializing subqueries and views. Queries against the built-in table-valued functions json_tree() and j= son_each() will now usually treat "ORDER BY rowid" as a no-op. Enhance the ability of the query planner to use indexed expressions e= ven if the expression has been modified by the constant-propagation optimizatio= n. (See forum thread 0a539c7.) Add the built-in unhex() SQL function. Add the base64 and base85 application-defined functions as an extension a= nd include that extension in the CLI. Add the sqlite3_stmt_scanstatus_v2() interface. (This interface is only a= vailable if SQLite is compiled using SQLITE_ENABLE_STMT_SCANSTATUS.) In-memory databases created using sqlite3_deserialize() now report their = filename as an empty string, not as 'x'. Changes to the CLI: Add the new base64() and base85() SQL functions Enhanced EXPLAIN QUERY PLAN output using the new sqlite3_stmt_scansta= tus_v2() interface when compiled using SQLITE_ENABLE_STMT_SCANSTATUS. The ".scanstats est" command provides query planner estimates in prof= iles. The continuation prompt indicates if the input is currently inside of= a string literal, identifier literal, comment, trigger definition, etc. Enhance the --safe command-line option to disallow dangerous SQL func= tions. The double-quoted string misfeature is now disabled by default for CL= I builds. Legacy use cases can reenable the misfeature at run-time using the ".dbconfig dqs_dml on" and ".dbconfig dqs_ddl on" commands. Enhance the PRAGMA integrity_check command so that it detects when text s= trings in a table are equivalent to but not byte-for-byte identical to the same stri= ngs in the index. Enhance the carray table-valued function so that it is able to bind an ar= ray of BLOB objects. Added the sqlite3_is_interrupted() interface. Long-running calls to sqlite3_prepare() and similar now invoke the progre= ss handler callback and react to sqlite3_interrupt(). The sqlite3_vtab_in_first() and sqlite3_vtab_in_next() functions are enha= nced so that they reliably detect if they are invoked on a parameter that was no= t selected for multi-value IN processing using sqlite3_vtab_in(). They return SQLIT= E_ERROR instead of SQLITE_MISUSE in this case. The parser now ignores excess parentheses around a subquery on the right-= hand side of an IN operator, so that SQLite now works the same as PostgreSQL in th= is regard. Formerly, SQLite treated the subquery as an expression with an implied "= LIMIT 1". Added the SQLITE_FCNTL_RESET_CACHE option to the sqlite3_file_control() A= PI. Makefile improvements: The new makefile target "sqlite3r.c" builds an amalgamation that incl= udes the recovery extension. New makefile targets "devtest" and "releasetest" for running a quick developmental test prior to doing a check-in and for doing a full re= lease test, respectively. Miscellaneous performance enhancements. Signed-off-by: Adolf Belka --- lfs/sqlite | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/lfs/sqlite b/lfs/sqlite index 49771ff33..40e7672cb 100644 --- a/lfs/sqlite +++ b/lfs/sqlite @@ -1,7 +1,7 @@ ############################################################################= ### # = # # IPFire.org - A linux based firewall = # -# Copyright (C) 2007-2022 IPFire Team = # +# Copyright (C) 2007-2023 IPFire Team = # # = # # This program is free software: you can redistribute it and/or modify = # # it under the terms of the GNU General Public License as published by = # @@ -24,7 +24,7 @@ =20 include Config =20 -VER =3D 3400100 +VER =3D 3410200 =20 THISAPP =3D sqlite-autoconf-$(VER) DL_FILE =3D $(THISAPP).tar.gz @@ -40,7 +40,7 @@ objects =3D $(DL_FILE) =20 $(DL_FILE) =3D $(DL_FROM)/$(DL_FILE) =20 -$(DL_FILE)_BLAKE2 =3D 495ffa185598b11e8258d2bfed88516753c0a13b3a67850f3464a1= 12f225a13db3b75e4f977ed549305e05a995074a8c5ef12d65c2b353306e58c098c89b36b6 +$(DL_FILE)_BLAKE2 =3D 928134ec28c349bf984705b6296fc01f31028aee17035d38b2c0db= b020ab1a8c431fe29092f3742ac68bdd0d3146a42b72404da9a7744209f4ea1f20312cf8c3 =20 install : $(TARGET) =20 --=20 2.40.0 --===============7436942080931459597==--