From mboxrd@z Thu Jan 1 00:00:00 1970 From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sqlite: Update to 3.35.4 Date: Thu, 08 Apr 2021 22:38:08 +0200 Message-ID: <20210408203808.1735238-1-adolf.belka@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============8370363048174494319==" List-Id: --===============8370363048174494319== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable - Update from 3.34.1 to 3.35.4 - Update of rootfile not required - Changelog 3.35.0 Added built-in SQL math functions(). (Requires the -DSQLITE_ENABLE_MATH_FUN= CTIONS compile-time option.) Added support for ALTER TABLE DROP COLUMN. Generalize UPSERT: Allow multiple ON CONFLICT clauses that are evaluated in order, The final ON CONFLICT clause may omit the conflict target and yet still u= se DO UPDATE. Add support for the RETURNING clause on DELETE, INSERT, and UPDATE statemen= ts. Use less memory when running VACUUM on databases containing very large TEXT= or BLOB values. It is no longer necessary to hold the entire TEXT or BLOB in= memory all at once. Add support for the MATERIALIZED and NOT MATERIALIZED hints when specifying= common table expressions. The default behavior was formerly NOT MATERIALIZED= , but is now changed to MATERIALIZED for CTEs that are used more than once. The SQLITE_DBCONFIG_ENABLE_TRIGGER and SQLITE_DBCONFIG_ENABLE_VIEW settings= are modified so that they only control triggers and views in the main databa= se schema or in attached database schemas and not in the TEMP schema. TEMP tr= iggers and views are always allowed. Query planner/optimizer improvements: Enhancements to the min/max optimization so that it works better with the= IN operator and the OP_SeekScan optimization of the previous release. Attempt to process EXISTS operators in the WHERE clause as if they were I= N operators, in cases where this is a valid transformation and seems likely t= o improve performance. Allow UNION ALL sub-queries to be flattened even if the parent query is a= join. Use an index, if appropriate, on IS NOT NULL expressions in the WHERE cla= use, even if STAT4 is disabled. Expressions of the form "x IS NULL" or "x IS NOT NULL" might be converted= to simply FALSE or TRUE, if "x" is a column that has a "NOT NULL" constraint= and is not involved in an outer join. Avoid checking foreign key constraints on an UPDATE statement if the UPDA= TE does not modify any columns associated with the foreign key. Allow WHERE terms to be pushed down into sub-queries that contain window = functions, as long as the WHERE term is made up of entirely of constants and = copies of expressions found in the PARTITION BY clauses of all window functio= ns in the sub-query. CLI enhancements: Enhance the ".stats" command to accept new arguments "stmt" and "vmstep",= causing prepare statement statistics and only the virtual-machine step count= to be shown, respectively. Add the ".filectrl data_version" command. Enhance the ".once" and ".output" commands so that if the destination arg= ument begins with "|" (indicating that output is redirected into a pipe) then= the argument does not need to be quoted. Bug fixes: Fix a potential NULL pointer dereference when processing a syntactically = incorrect SELECT statement with a correlated WHERE clause and a "HAVING 0" cl= ause. (Also fixed in the 3.34.1 patch release.) Fix a bug in the IN-operator optimization of version 3.33.0 that can caus= e an incorrect answer. Fix incorrect answers from the LIKE operator if the pattern ends with "%"= and there is an "ESCAPE '_'" clause. 3.35.1 Fix a bug in the new DROP COLUMN feature when used on columns that are inde= xed and that are quoted in the index definition. Improve the built-in documentation for the .dump command in the CLI. 3.35.2 Fix a problem in the appendvfs.c extension that was introduced into version= 3.35.0. Ensure that date/time functions with no arguments (which generate responses= that depend on the current time) are treated as non-deterministic functions.= Ticket 2c6c8689fb5f3d2f Fix a problem in the sqldiff utility program having to do with unusual whit= espace characters in a virtual table definition. Limit the new UNION ALL optimization described by item 8c in the 3.35.0 rel= ease so that it does not try to make too many new subqueries. See forum threa= d 140a67d3d2 for details. 3.35.3 Enhance the OP_OpenDup opcode of the bytecode engine so that it works even = if the cursor being duplicated itself came from OP_OpenDup. Fix for ticket bb= 8a9fd4a9b7fce5. This problem only came to light due to the recent MATERIALIZE= D hint enhancement. When materializing correlated common table expressions, do so separately fo= r each use case, as that is required for correctness. This fixes a problem th= at was introduced by the MATERIALIZED hint enhancement. Fix a problem in the filename normalizer of the unix VFS. Fix the "box" output mode in the CLI so that it works with statements that = returns one or more rows of zero columns (such as PRAGMA incremental_vacuum).= Forum post afbbcb5b72. Improvements to error messages generated by faulty common table expressions= . Forum post aa5a0431c99e. Fix some incorrect assert() statements. Fix to the SELECT statement syntax diagram so that the FROM clause syntax i= s shown correctly. Forum post 9ed02582fe. Fix the EBCDIC character classifier so that it understands newlines as whit= espace. Forum post 58540ce22dcd. Improvements the xBestIndex method in the implementation of the (unsupporte= d) wholenumber virtual table extension so that it does a better job of convin= cing the query planner to avoid trying to materialize a table with an infinit= e number of rows. Forum post b52a020ce4. 3.35.4 Fix a defect in the query planner optimization identified by item 8b above.= Ticket de7db14784a08053. Fix a defect in the new RETURNING syntax. Ticket 132994c8b1063bfb. Fix the new RETURNING feature so that it raises an error if one of the term= s in the RETURNING clause references a unknown table, instead of silently ign= oring that error. Fix an assertion associated with aggregate function processing that was inc= orrectly triggered by the push-down optimization. Signed-off-by: Adolf Belka --- lfs/sqlite | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lfs/sqlite b/lfs/sqlite index ab7d79920..7aada7585 100644 --- a/lfs/sqlite +++ b/lfs/sqlite @@ -24,7 +24,7 @@ =20 include Config =20 -VER =3D 3340100 +VER =3D 3350400 =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 14dca9d44fb6a57f6521c1ace4be5a68 +$(DL_FILE)_MD5 =3D 9cf453a9cd0e40cdbc8e6f008acfc4fb =20 install : $(TARGET) =20 --=20 2.31.1 --===============8370363048174494319==--