From mboxrd@z Thu Jan 1 00:00:00 1970 From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sqlite: Update to version 3360000 Date: Thu, 01 Jul 2021 23:25:32 +0200 Message-ID: <20210701212532.282447-1-adolf.belka@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3330901564414968755==" List-Id: --===============3330901564414968755== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable - Update from 3350500 to 3360000 - Update of rootfile not required - Changelog Improvement to the EXPLAIN QUERY PLAN output to make it easier to understa= nd. Byte-order marks at the start of a token are skipped as if they were white= space. An error is raised on any attempt to access the rowid of a VIEW or subquer= y. Formerly, the rowid of a VIEW would be indeterminate and often would be NU= LL. The -DSQLITE_ALLOW_ROWID_IN_VIEW compile-time option is available to rest= ore the legacy behavior for applications that need it. The sqlite3_deserialize() and sqlite3_serialize() interfaces are now enabl= ed by default. The -DSQLITE_ENABLE_DESERIALIZE compile-time option is no long= er required. Instead, there is is a new -DSQLITE_OMIT_DESERIALIZE compile-tim= e option to omit those interfaces. The "memdb" VFS now allows the same in-memory database to be shared among = multiple database connections in the same process as long as the database nam= e begins with "/". Back out the EXISTS-to-IN optimization (item 8b in the SQLite 3.35.0 chang= e log) as it was found to slow down queries more often than speed them up. Improve the constant-propagation optimization so that it works on non-join= queries. The REGEXP extension is now included in CLI builds. Signed-off-by: Adolf Belka --- lfs/sqlite | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lfs/sqlite b/lfs/sqlite index a68bf462b..04eada9d8 100644 --- a/lfs/sqlite +++ b/lfs/sqlite @@ -24,7 +24,7 @@ =20 include Config =20 -VER =3D 3350500 +VER =3D 3360000 =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 d1d1aba394c8e0443077dc9f1a681bb8 +$(DL_FILE)_MD5 =3D f5752052fc5b8e1b539af86a3671eac7 =20 install : $(TARGET) =20 --=20 2.32.0 --===============3330901564414968755==--