From mboxrd@z Thu Jan 1 00:00:00 1970 From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sqlite: Update to version 3380000 Date: Sun, 27 Feb 2022 14:53:06 +0100 Message-ID: <20220227135306.3752-1-adolf.belka@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4721183588257079509==" List-Id: --===============4721183588257079509== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable - Update from version 3370200 to 3380000 - Update of rootfile not required - Changelog SQLite Release 3.38.0 On 2022-02-22 Added the -> and ->> operators for easier processing of JSON. The new ope= rators are compatible with MySQL and PostgreSQL. The JSON functions are now built-ins. It is no longer necessary to use the -DSQLITE_ENABLE_JSON1 compile-time option to enable JSON support. JSON i= s on by default. Disable the JSON interface using the new -DSQLITE_OMIT_JSON com= pile-time option. Enhancements to date and time functions: Added the unixepoch() function. Added the auto modifier and the julianday modifier. Rename the printf() SQL function to format() for better compatibility. Th= e original printf() name is retained as an alias for backwards compatibility. Added the sqlite3_error_offset() interface, which can sometimes help to l= ocalize an SQL error to a specific character in the input SQL text, so that applica= tions can provide better error messages. Enhanced the interface to virtual tables as follows: Added the sqlite3_vtab_distinct() interface. Added the sqlite3_vtab_rhs_value() interface. Added new operator types SQLITE_INDEX_CONSTRAINT_LIMIT and SQLITE_INDEX_CONSTRAINT_OFFSET. Added the sqlite3_vtab_in() interface (and related) to enable a virtu= al table to process IN operator constraints all at once, rather than processing = each value of the right-hand side of the IN operator separately. CLI enhancements: Columnar output modes are enhanced to correctly handle tabs and newli= nes embedded in text. Added options like "--wrap N", "--wordwrap on", and "--quote" to the = columnar output modes. Added the .mode qbox alias. The .import command automatically disambiguates column names. Use the new sqlite3_error_offset() interface to provide better error = messages. Query planner enhancements: Use a Bloom filter to speed up large analytic queries. Use a balanced merge tree to evaluate UNION or UNION ALL compound SEL= ECT statements that have an ORDER BY clause. The ALTER TABLE statement is changed to silently ignores entries in the s= qlite_schema table that do not parse when PRAGMA writable_schema=3DON. Signed-off-by: Adolf Belka --- lfs/sqlite | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lfs/sqlite b/lfs/sqlite index 86d25f3ed..3b19eb205 100644 --- a/lfs/sqlite +++ b/lfs/sqlite @@ -24,7 +24,7 @@ =20 include Config =20 -VER =3D 3370200 +VER =3D 3380000 =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 683cc5312ee74e71079c14d24b7a6d27 +$(DL_FILE)_MD5 =3D 26dabf36c49b63d88d8ade506a8c9daf =20 install : $(TARGET) =20 --=20 2.35.1 --===============4721183588257079509==--