From mboxrd@z Thu Jan 1 00:00:00 1970 From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sqlite: Update to version 3390000 Date: Sun, 10 Jul 2022 15:10:36 +0200 Message-ID: <20220710131036.3611221-1-adolf.belka@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2470476561784482697==" List-Id: --===============2470476561784482697== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable - 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 DISTINCT = FROM that are equivalent to IS and IS NOT, respective, for compatibility with PostgreS= QL and SQL standards. Add a new return code (value "3") from the sqlite3_vtab_distinct() interf= ace 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 t= o create a canonical name for the database before the file is opened. Defer materializing views until the materialization is actually needed, t= hus 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 q= uery, even queries that do not have a GROUP BY clause. Many microoptimizations collectively reduce CPU cycles by about 2.3%. Signed-off-by: Adolf Belka --- lfs/sqlite | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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 546db2fddfc065ddb5d0f232456a79d6a582cd98acfe7c1c8e0f53= 311906f70d47d89dfabfdb52c9c261202931b97d84b5fd238f70e6539522e56a57c03036b3 +$(DL_FILE)_BLAKE2 =3D 5621aee0468184599f5fea172699ce4db969edb794704c6038009c= 6fe9fda3613f53de5307e1a5077ca790640f0d7fe82fd7f110c7e1acb0553490da5a5c13f6 =20 install : $(TARGET) =20 --=20 2.37.0 --===============2470476561784482697==--