From mboxrd@z Thu Jan 1 00:00:00 1970 From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sqlite: Update to version 3430000 Date: Fri, 25 Aug 2023 13:00:43 +0200 Message-ID: <20230825110043.3421381-1-adolf.belka@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2988591554582380808==" List-Id: --===============2988591554582380808== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable - Update from version 3420000 to 3430000 - Update of rootfile not required. - Changelog 3430000 Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being = indexed while also allowing records to be deleted. Enhancements to the date and time functions: Added new time shift modifiers of the form =C2=B1YYYY-MM-DD HH:MM:SS.SSS. Added the timediff() SQL function. Added the octet_length(X) SQL function. Added the sqlite3_stmt_explain() API. Query planner enhancements: Generalize the LEFT JOIN strength reduction optimization so that it work= s for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength r= eduction. Enhance the theorem prover in the OUTER JOIN strength reduction optimiza= tion so that it returns fewer false-negatives. Enhancements to the decimal extension: New function decimal_pow2(N) returns the N-th power of 2 for integer N b= etween -20000 and +20000. New function decimal_exp(X) works like decimal(X) except that it returns= the result in exponential notation - with a "e+NN" at the end. If X is a floating-point value, then the decimal(X) function now does a = full expansion of that value into its exact decimal equivalent. Performance enhancements to JSON processing results in a 2x performance improvement for some kinds of processing on large JSON strings. New makefile target "verify-source" checks to ensure that there are no unintentional changes in the source tree. (Works for canonical sourc= e code only - not for precompiled amalgamation tarballs.) Added the SQLITE_USE_SEH compile-time option that enables Structured Excepti= on Handling on Windows while working with the memory-mapped shm file th= at is part of WAL mode processing. This option is enabled by default when building= on Windows using Makefile.msc. The VFS for unix now assumes that the nanosleep() system call is available u= nless compiled with -DHAVE_NANOSLEEP=3D0. Signed-off-by: Adolf Belka --- lfs/sqlite | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lfs/sqlite b/lfs/sqlite index d059bb068..01477e47d 100644 --- a/lfs/sqlite +++ b/lfs/sqlite @@ -24,7 +24,7 @@ =20 include Config =20 -VER =3D 3420000 +VER =3D 3430000 =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 3c4837952a3d9864f03d7a2c164b303f196ad1deeef2f96056509d= d808108655e1a2b2161b4bd614bd01feaec98bb9f8019237bfbd5901ec9ae06b442175d0f6 +$(DL_FILE)_BLAKE2 =3D dc5a5df76ffe86eb61438031ef3893fbe412f7c7607826dd032293= ced06b2f76dfb5f6b85ba80e857069ea4244a3ec222f3f247faec192778c3ecfcc810faa07 =20 install : $(TARGET) =20 --=20 2.41.0 --===============2988591554582380808==--