From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Tremer <michael.tremer@ipfire.org>
To: development@lists.ipfire.org
Subject: Re: [PATCH] sqlite: Update to version 3.37.0
Date: Wed, 01 Dec 2021 13:55:10 +0000
Message-ID: <02366FC1-4D9E-42D3-B2F7-EA323652A073@ipfire.org>
In-Reply-To: <20211201123000.3436751-1-adolf.belka@ipfire.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============8401652347563469682=="
List-Id: <development.lists.ipfire.org>

--===============8401652347563469682==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

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

> On 1 Dec 2021, at 12:30, Adolf Belka <adolf.belka(a)ipfire.org> wrote:
>=20
> - 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 colu=
mn containing
>      a NOT NULL constraint, the ALTER TABLE ADD COLUMN now checks new const=
raints against
>      preexisting rows in the database and will only proceed if no constrain=
ts are violated.
>     Added the PRAGMA table_list statement.
>     CLI enhancements:
>        Add the .connection command, allowing the CLI to keep multiple datab=
ase
>         connections open at the same time.
>        Add the --safe command-line option that disables dot-commands and SQ=
L statements
>         that might cause side-effects that extend beyond the single databas=
e 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 da=
tabase. 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 demonstr=
ate how to
>      write table-valued functions with required parameters. The legacy beha=
vior is
>      available using the -DZERO_ARGUMENT_GENERATE_SERIES compile-time optio=
n.
>     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.
>=20
> Signed-off-by: Adolf Belka <adolf.belka(a)ipfire.org>
> ---
> lfs/sqlite | 8 +++++---
> 1 file changed, 5 insertions(+), 3 deletions(-)
>=20
> diff --git a/lfs/sqlite b/lfs/sqlite
> index 04eada9d8..84a04004a 100644
> --- a/lfs/sqlite
> +++ b/lfs/sqlite
> @@ -24,7 +24,7 @@
>=20
> include Config
>=20
> -VER        =3D 3360000
> +VER        =3D 3370000
>=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)_MD5 =3D f5752052fc5b8e1b539af86a3671eac7
> +$(DL_FILE)_MD5 =3D 021c1d936c157bb68d6d0b158636ac7a
>=20
> install : $(TARGET)
>=20
> @@ -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=3D/usr
> +	cd $(DIR_APP) && ./configure \
> +	                --prefix=3D/usr \
> +	                --disable-static
> 	cd $(DIR_APP) && make $(MAKETUNING)
> 	cd $(DIR_APP) && make install
> 	@rm -rf $(DIR_APP)
> --=20
> 2.34.0
>=20


--===============8401652347563469682==--