Re: [PATCH] sqlite: Update to version 3410200

[Stefan Schantl <stefan.schantl@ipfire.org>]

[-- Attachment #1: Type: text/plain, Size: 7976 bytes --]

Reviewed-by: Stefan Schantl <stefan.schantl(a)ipfire.org>
> - 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 <adolf.belka(a)ipfire.org>
> ---
>  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 
> <info(a)ipfire.org>                     #
> +# Copyright (C) 2007-2023  IPFire Team 
> <info(a)ipfire.org>                     #
>  #                                                                   
>           #
>  # 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)
>