Reviewed-by: Stefan Schantl > - 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 writes) 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 values when >      reporting errors associated with generated columns. >     Multiple fixes in the query optimizer for problems that cause > incorrect results 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=0 and -DHAVE_LOG10=0 to > enable 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 end 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 includes a >          GROUP BY clause. >         The query planner has improved awareness of when an index is > a covering index >          and adjusts predicted runtimes accordingly. >         The query planner is more aggressive about using co-routines > rather than >          materializing subqueries and views. >         Queries against the built-in table-valued functions > json_tree() and json_each() >          will now usually treat "ORDER BY rowid" as a no-op. >         Enhance the ability of the query planner to use indexed > expressions even if the >          expression has been modified by the constant-propagation > optimization. (See >          forum thread 0a539c7.) >     Add the built-in unhex() SQL function. >     Add the base64 and base85 application-defined functions as an > extension and include >      that extension in the CLI. >     Add the sqlite3_stmt_scanstatus_v2() interface. (This interface > is only available 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_scanstatus_v2() >          interface when compiled using SQLITE_ENABLE_STMT_SCANSTATUS. >         The ".scanstats est" command provides query planner estimates > in profiles. >         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 functions. >         The double-quoted string misfeature is now disabled by > default for CLI 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 strings in a >      table are equivalent to but not byte-for-byte identical to the > same strings in the >      index. >     Enhance the carray table-valued function so that it is able to > bind an array of BLOB >      objects. >     Added the sqlite3_is_interrupted() interface. >     Long-running calls to sqlite3_prepare() and similar now invoke > the progress handler >      callback and react to sqlite3_interrupt(). >     The sqlite3_vtab_in_first() and sqlite3_vtab_in_next() functions > are enhanced so >      that they reliably detect if they are invoked on a parameter > that was not selected >      for multi-value IN processing using sqlite3_vtab_in(). They > return SQLITE_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 this 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() API. >     Makefile improvements: >         The new makefile target "sqlite3r.c" builds an amalgamation > that includes 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 release 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 @@ >   >  include Config >   > -VER        = 3400100 > +VER        = 3410200 >   >  THISAPP    = sqlite-autoconf-$(VER) >  DL_FILE    = $(THISAPP).tar.gz > @@ -40,7 +40,7 @@ objects = $(DL_FILE) >   >  $(DL_FILE) = $(DL_FROM)/$(DL_FILE) >   > -$(DL_FILE)_BLAKE2 = > 495ffa185598b11e8258d2bfed88516753c0a13b3a67850f3464a112f225a13db3b75 > e4f977ed549305e05a995074a8c5ef12d65c2b353306e58c098c89b36b6 > +$(DL_FILE)_BLAKE2 = > 928134ec28c349bf984705b6296fc01f31028aee17035d38b2c0dbb020ab1a8c431fe > 29092f3742ac68bdd0d3146a42b72404da9a7744209f4ea1f20312cf8c3 >   >  install : $(TARGET) >