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.46.0
Date: Wed, 29 May 2024 10:11:30 +0100
Message-ID: <6435069A-68C1-4E4C-ADF0-4F3033E56DA7@ipfire.org>
In-Reply-To: <20240528154144.3777068-2-adolf.belka@ipfire.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============3805039911025136736=="
List-Id: <development.lists.ipfire.org>

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

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

> On 28 May 2024, at 16:41, Adolf Belka <adolf.belka(a)ipfire.org> wrote:
>=20
> - Update from version 3.45.3 to 3.46.0
> - Update of rootfile not required
> - Changelog
>    3.46.0
> Enhance PRAGMA optimize in multiple ways, to make it simpler to use:
>    PRAGMA optimize automatically implements a temporary analysis limit to p=
revent
>     excess runtime on large databases.
>    Added the new 0x10000 bitmask option to check for updates on all tables.
>    Automatically re-analyze tables that do not have sqlite_stat1 entries.
> Enhancements to the date and time functions:
>    The strftime() SQL function now supports %G, %g, %U, and %V.
>    New modifiers 'ceiling' and 'floor' control the algorithm used to resolve
>     ambiguous dates when shifting a date by an integer number of months and=
/or
>     years.
>    The 'utc' and 'localtime' modifiers are now no-ops if SQLite knows that =
the
>     time is already in UTC or in the localtime, respectively.
> Add support for underscore ("_") characters between digits in numeric liter=
als.
> Add the json_pretty() SQL function.
> Query planner improvements:
>    The "VALUES-as-coroutine" optimization enables INSERT statements with
>     thousands of rows in the VALUES clause to parse and run in about half t=
he
>     time and using about half as much memory.
>    Allow the use of an index for queries like
>     "SELECT count(DISTINCT col) FROM ...", even if the index records are not
>     smaller than the table records.
>    Improved recognition of cases where the value of an SQL function is cons=
tant
>     because all its arguments are constant.
>    Enhance the WHERE-clause push-down optimization so that it is able to pu=
sh
>     down WHERE clause terms containing uncorrelated subqueries.
> Allocate additional memory from the heap for the SQL parser stack if that s=
tack
> overflows, rather than reporting a "parser stack overflow" error.
> JSON changes:
>    Allow ASCII control characters within JSON5 string literals.
>    Fix the -> and ->> operators so that when the right-hand side operand is=
 a
>     string that looks like an integer it is still treated as a string, beca=
use
>     that is what PostgreSQL does.
> Allow large hexadecimal literals to be used as the DEFAULT value to a table=
 column.
>=20
> Signed-off-by: Adolf Belka <adolf.belka(a)ipfire.org>
> ---
> lfs/sqlite | 4 ++--
> 1 file changed, 2 insertions(+), 2 deletions(-)
>=20
> diff --git a/lfs/sqlite b/lfs/sqlite
> index 421e32dd2..d001a5f49 100644
> --- a/lfs/sqlite
> +++ b/lfs/sqlite
> @@ -24,7 +24,7 @@
>=20
> include Config
>=20
> -VER        =3D 3450300
> +VER        =3D 3460000
>=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 24e47dcfb8fb1dbd0055d48cfc540884439e9443b1b79700e867=
326feb60b340a9b5d5bdb83eeca210b47251e61b706ec67eb1b84e59b11bae6c76271b1030bf
> +$(DL_FILE)_BLAKE2 =3D 2f484823b84ab758e21960ac6b730cefa62c26f7ccf5344299a2=
6e6f559d0e02cfd4cff5f5921effdee6e2e49d2ab36b1f91cffdd8599bc2189efab44bf4b197
>=20
> install : $(TARGET)
>=20
> --=20
> 2.44.0
>=20


--===============3805039911025136736==--