Re: [PATCH] sqlite: Update to version 3.37.0

[Michael Tremer <michael.tremer@ipfire.org>]

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

Reviewed-by: Michael Tremer <michael.tremer(a)ipfire.org>

> On 1 Dec 2021, at 12:30, Adolf Belka <adolf.belka(a)ipfire.org> wrote:
> 
> - Update from 3.36.0 to 3.37.0
> - Update of rootfile not required
> - Changelog
>   Release 3.37.0 On 2021-11-27
>     STRICT tables provide a prescriptive style of data type management, for developers
>      who prefer that kind of thing.
>     When adding columns that contain a CHECK constraint or a generated column containing
>      a NOT NULL constraint, the ALTER TABLE ADD COLUMN now checks new constraints against
>      preexisting rows in the database and will only proceed if no constraints are violated.
>     Added the PRAGMA table_list statement.
>     CLI enhancements:
>        Add the .connection command, allowing the CLI to keep multiple database
>         connections open at the same time.
>        Add the --safe command-line option that disables dot-commands and SQL statements
>         that might cause side-effects that extend beyond the single database file named
>         on the command-line.
>        Performance improvements when reading SQL statements that span many lines.
>     Added the sqlite3_autovacuum_pages() interface.
>     The sqlite3_deserialize() does not and has never worked for the TEMP database. That
>      limitation is now noted in the documentation.
>     The query planner now omits ORDER BY clauses on subqueries and views if removing
>      those clauses does not change the semantics of the query.
>     The generate_series table-valued function extension is modified so that the first
>      parameter ("START") is now required. This is done as a way to demonstrate how to
>      write table-valued functions with required parameters. The legacy behavior is
>      available using the -DZERO_ARGUMENT_GENERATE_SERIES compile-time option.
>     Added new sqlite3_changes64() and sqlite3_total_changes64() interfaces.
>     Added the SQLITE_OPEN_EXRESCODE flag option to sqlite3_open_v2().
>     Use less memory to hold the database schema.
> 
> Signed-off-by: Adolf Belka <adolf.belka(a)ipfire.org>
> ---
> lfs/sqlite | 8 +++++---
> 1 file changed, 5 insertions(+), 3 deletions(-)
> 
> diff --git a/lfs/sqlite b/lfs/sqlite
> index 04eada9d8..84a04004a 100644
> --- a/lfs/sqlite
> +++ b/lfs/sqlite
> @@ -24,7 +24,7 @@
> 
> include Config
> 
> -VER        = 3360000
> +VER        = 3370000
> 
> THISAPP    = sqlite-autoconf-$(VER)
> DL_FILE    = $(THISAPP).tar.gz
> @@ -40,7 +40,7 @@ objects = $(DL_FILE)
> 
> $(DL_FILE) = $(DL_FROM)/$(DL_FILE)
> 
> -$(DL_FILE)_MD5 = f5752052fc5b8e1b539af86a3671eac7
> +$(DL_FILE)_MD5 = 021c1d936c157bb68d6d0b158636ac7a
> 
> install : $(TARGET)
> 
> @@ -70,7 +70,9 @@ $(subst %,%_MD5,$(objects)) :
> $(TARGET) : $(patsubst %,$(DIR_DL)/%,$(objects))
> 	@$(PREBUILD)
> 	@rm -rf $(DIR_APP) && cd $(DIR_SRC) && tar zxf $(DIR_DL)/$(DL_FILE)
> -	cd $(DIR_APP) && ./configure --prefix=/usr
> +	cd $(DIR_APP) && ./configure \
> +	                --prefix=/usr \
> +	                --disable-static
> 	cd $(DIR_APP) && make $(MAKETUNING)
> 	cd $(DIR_APP) && make install
> 	@rm -rf $(DIR_APP)
> -- 
> 2.34.0
>