From mboxrd@z Thu Jan 1 00:00:00 1970 From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sqlite: Update to version 3420000 Date: Thu, 18 May 2023 20:43:26 +0200 Message-ID: <20230518184328.172754-9-adolf.belka@ipfire.org> In-Reply-To: <20230518184328.172754-1-adolf.belka@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4209500215991552105==" List-Id: --===============4209500215991552105== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable - Update from version 3410200 to 3420000 - Update of rootfile not required - Changelog is mostly new functions but there are also a range of unnamed bug= fixes and performance improvements version 3420000 Add the FTS5 secure-delete command. This option causes all forensic traces t= o be removed from the FTS5 inverted index when content is deleted. Enhance the JSON SQL functions to support JSON5 extensions. The SQLITE_CONFIG_LOG and SQLITE_CONFIG_PCACHE_HDRSZ calls to sqlite3_config= () are now allowed to occur after sqlite3_initialize(). New sqlite3_db_config() options: SQLITE_DBCONFIG_STMT_SCANSTATUS and SQLITE_= DBCONFIG_REVERSE_SCANORDER. Query planner improvements: Enable the "count-of-view" optimization by default. Avoid computing unused columns in subqueries. Improvements to the push-down optimization. Enhancements to the CLI: Add the --unsafe-testing command-line option. Without this option, some = dot-commands (ex: ".testctrl") are now disabled because those commands that a= re intended for testing only and can cause malfunctions misused. Allow commands ".log on" and ".log off", even in --safe mode. "--" as a command-line argument means all subsequent arguments that star= t with "-" are interpreted as normal non-option argument. Magic parameters ":inf" and ":nan" bind to floating point literals Infin= ity and NaN, respectively. The --utf8 command-line option omits all translation to or from MBCS on = the Windows console for interactive sessions, and sets the console code page = for UTF-8 I/O during such sessions. The --utf8 option is a no-op on all other= platforms. Add the ability for application-defined SQL functions to have the same name = as join keywords: CROSS, FULL, INNER, LEFT, NATURAL, OUTER, or RIGHT. Enhancements to PRAGMA integrity_check: Detect and raise an error when a NaN value is stored in a NOT NULL colum= n. Improved error message output identifies the root page of a b-tree when = an error is found within a b-tree. Allow the session extension to be configured to capture changes from tables = that lack an explicit ROWID. Added the subsecond modifier to the date and time functions. Negative values passed into sqlite3_sleep() are henceforth interpreted as 0. The maximum recursion depth for JSON arrays and objects is lowered from 2000= to 1000. Extended the built-in printf() function so the comma option now works with f= loating-point conversions in addition to integer conversions. Miscellaneous bug fixes and performance optimizations Signed-off-by: Adolf Belka --- lfs/sqlite | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lfs/sqlite b/lfs/sqlite index 40e7672cb..d059bb068 100644 --- a/lfs/sqlite +++ b/lfs/sqlite @@ -24,7 +24,7 @@ =20 include Config =20 -VER =3D 3410200 +VER =3D 3420000 =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 928134ec28c349bf984705b6296fc01f31028aee17035d38b2c0db= b020ab1a8c431fe29092f3742ac68bdd0d3146a42b72404da9a7744209f4ea1f20312cf8c3 +$(DL_FILE)_BLAKE2 =3D 3c4837952a3d9864f03d7a2c164b303f196ad1deeef2f96056509d= d808108655e1a2b2161b4bd614bd01feaec98bb9f8019237bfbd5901ec9ae06b442175d0f6 =20 install : $(TARGET) =20 --=20 2.40.1 --===============4209500215991552105==--