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 3390000
Date: Mon, 11 Jul 2022 10:16:51 +0000
Message-ID: <a896e4c0-86ae-1929-ce3f-b1bbbd339a75@ipfire.org>
In-Reply-To: <20220710131036.3611221-1-adolf.belka@ipfire.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6584845898272225906=="
List-Id: <development.lists.ipfire.org>

--===============6584845898272225906==
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 3380500 to 3890000
> - Update of rootfile not required
> - Changelog
>    Release 3.39.0 On 2022-06-25
>     Add (long overdue) support for RIGHT and FULL OUTER JOIN.
>     Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINC=
T FROM that are
>      equivalent to IS and IS NOT, respective, for compatibility with Postgr=
eSQL and SQL
>      standards.
>     Add a new return code (value "3") from the sqlite3_vtab_distinct() inte=
rface that
>      indicates a query that has both DISTINCT and ORDER BY clauses.
>     Added the sqlite3_db_name() interface.
>     The unix os interface resolves all symbolic links in database filenames=
 to create a
>      canonical name for the database before the file is opened.
>     Defer materializing views until the materialization is actually needed,=
 thus avoiding
>      unnecessary work if the materialization turns out to never be used.
>     The HAVING clause of a SELECT statement is now allowed on any aggregate=
 query, even
>      queries that do not have a GROUP BY clause.
>     Many microoptimizations collectively reduce CPU cycles by about 2.3%.
>=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 4f6d5ad06..a7aa0b499 100644
> --- a/lfs/sqlite
> +++ b/lfs/sqlite
> @@ -24,7 +24,7 @@
> =20
>  include Config
> =20
> -VER        =3D 3380500
> +VER        =3D 3390000
> =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 546db2fddfc065ddb5d0f232456a79d6a582cd98acfe7c1c8e0f=
53311906f70d47d89dfabfdb52c9c261202931b97d84b5fd238f70e6539522e56a57c03036b3
> +$(DL_FILE)_BLAKE2 =3D 5621aee0468184599f5fea172699ce4db969edb794704c603800=
9c6fe9fda3613f53de5307e1a5077ca790640f0d7fe82fd7f110c7e1acb0553490da5a5c13f6
> =20
>  install : $(TARGET)
> =20

--===============6584845898272225906==--