From mboxrd@z Thu Jan  1 00:00:00 1970
From: Peter =?utf-8?q?M=C3=BCller?= <peter.mueller@ipfire.org>
To: development@lists.ipfire.org
Subject: Re: [PATCH] sqlite: Update to version 3380300
Date: Fri, 29 Apr 2022 18:35:27 +0000
Message-ID: <9b203de2-9b2b-96f1-3673-deef279122eb@ipfire.org>
In-Reply-To: <20220428111425.3578089-1-adolf.belka@ipfire.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6571783047110576029=="
List-Id: <development.lists.ipfire.org>

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

Reviewed-by: Peter M=C3=BCller <peter.mueller(a)ipfire.org>

> - Update from version 3380000 to 3380300
> - Update of rootfile not required
> - Changelog
> 	3.38.3 (2022-04-27):
> 	    Fix a case of the query planner be overly aggressive with optimizing
>              automatic-index and Bloom-filter construction, using inappropr=
iate ON clause
>              terms to restrict the size of the automatic-index or Bloom fil=
ter, and
>              resulting in missing rows in the output. Forum thread 0d3200f4=
f3bcd3a3.
> 	    Other minor patches. See the timeline for details.
> 	3.38.2 (2022-03-26):
> 	    Fix a user-discovered problem with the new Bloom filter optimization t=
hat
>              might cause an incorrect answer when doing a LEFT JOIN with a =
WHERE clause
>              constraint that says that one of the columns on the right tabl=
e of the LEFT
>              JOIN is NULL. See forum thread 031e262a89b6a9d2.
> 	    Other minor patches. See the timeline for details.
> 	3.38.1 (2022-03-12):
> 	    Fix problems with the new Bloom filter optimization that might cause s=
ome
>              obscure queries to get an incorrect answer.
> 	    Fix the localtime modifier of the date and time functions so that it
>              preserves fractional seconds.
> 	    Fix the sqlite_offset SQL function so that it works correctly even in =
corner
>              cases such as when the argument is a virtual column or the col=
umn of a view.
> 	    Fix row value IN operator constraints on virtual tables so that they w=
ork
>              correctly even if the virtual table implementation relies on b=
ytecode to
>              filter rows that do not satisfy the constraint.
> 	    Other minor fixes to assert() statements, test cases, and documentatio=
n. See
>              the source code timeline for details.
>=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 7986b2ce5..076943280 100644
> --- a/lfs/sqlite
> +++ b/lfs/sqlite
> @@ -24,7 +24,7 @@
> =20
>  include Config
> =20
> -VER        =3D 3380000
> +VER        =3D 3380300
> =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 0b4eff73e9a7b317d080439c9e74b47a09e8809d4629a2ee31d4=
10df2ce626d6bd6e9c5bdc5d0d4f104d981ee7b3a8a31bf2d7153932ad866f5e876c1608f6da
> +$(DL_FILE)_BLAKE2 =3D 35271246a27597ce88b4eaa1ff483b42421371737b5fe357eb6d=
2ad1d9c543b2d60341f7ee63f7dc95e374f61c539a607472b53881027c843b0da07704dd200f
> =20
>  install : $(TARGET)
> =20

--===============6571783047110576029==--