From 63847496f14c813a5d80efd5b7de0f1294ffe1e3 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 16:07:11 +0200 Subject: Adding upstream version 3.45.1. Signed-off-by: Daniel Baumann --- www/releaselog/3_35_2.html | 219 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 219 insertions(+) create mode 100644 www/releaselog/3_35_2.html (limited to 'www/releaselog/3_35_2.html') diff --git a/www/releaselog/3_35_2.html b/www/releaselog/3_35_2.html new file mode 100644 index 0000000..4ebab73 --- /dev/null +++ b/www/releaselog/3_35_2.html @@ -0,0 +1,219 @@ + + + + + +SQLite Release 3.35.2 On 2021-03-17 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.35.2 On 2021-03-17

Prior changes from version 3.35.0 (2021-03-12):

+

    +
  1. Added built-in SQL math functions(). (Requires the + -DSQLITE_ENABLE_MATH_FUNCTIONS compile-time option.) +
  2. Added support for ALTER TABLE DROP COLUMN. +
  3. Generalize UPSERT: +
      +
    1. Allow multiple ON CONFLICT clauses that are evaluated in order, +
    2. The final ON CONFLICT clause may omit the conflict target and + yet still use DO UPDATE. +
    +
  4. Add support for the RETURNING clause on DELETE, INSERT, and + UPDATE statements. +
  5. 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. +
  6. 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. +
  7. The SQLITE_DBCONFIG_ENABLE_TRIGGER and SQLITE_DBCONFIG_ENABLE_VIEW + settings are modified so that they only control triggers and views + in the main database schema or in attached database schemas and not in + the TEMP schema. TEMP triggers and views are always allowed. +
  8. Query planner/optimizer improvements: +
      +
    1. Enhancements to the min/max optimization so that it works better + with the IN operator and the OP_SeekScan optimization of the + previous release. +
    2. Attempt to process EXISTS operators in the WHERE clause as if + they were IN operators, in cases where this is a valid transformation + and seems likely to improve performance. +
    3. Allow UNION ALL sub-queries to be flattened even if the parent query is a join. +
    4. Use an index, if appropriate, on IS NOT NULL expressions in the WHERE clause, + even if STAT4 is disabled. +
    5. 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. +
    6. Avoid checking foreign key constraints on an UPDATE statement if the UPDATE does + not modify any columns associated with the foreign key. +
    7. 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 functions in the sub-query. +
    +
  9. CLI enhancements: +
      +
    1. 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. +
    2. Add the ".filectrl data_version" command. +
    3. Enhance the ".once" and ".output" commands so that if the destination argument + begins with "|" (indicating that output is redirected into a pipe) then the + argument does not need to be quoted. +
    +
  10. Bug fixes: +
      +
    1. Fix a potential NULL pointer dereference when processing a + syntactically incorrect SELECT statement with a correlated WHERE + clause and a "HAVING 0" clause. (Also fixed in the 3.34.1 patch release.) +
    2. Fix a bug in the IN-operator optimization + of version 3.33.0 that can cause an incorrect answer. +
    3. Fix incorrect answers from the LIKE operator if the pattern ends with "%" and there + is an "ESCAPE '_'" clause. +
    +
+

Prior changes from version 3.35.1 (2021-03-15):

+

    +
  1. Fix a bug in the new DROP COLUMN + feature when used on columns that are indexed and that are quoted in the index + definition. +
  2. Improve the built-in documentation for the .dump command in the CLI. +
+

Changes in this specific patch release, version 3.35.2 (2021-03-17):

+

    +
  1. Fix a problem in the + appendvfs.c + extension that was introduced into version 3.35.0. +
  2. 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 +
  3. Fix a problem in the sqldiff utility program having to do with + unusual whitespace characters in a virtual table definition. +
  4. Limit the new UNION ALL optimization described by item 8c in the + 3.35.0 release so that it does not try to make too many new subqueries. + See forum thread 140a67d3d2 + for details. +

    Hashes: +

  5. SQLITE_SOURCE_ID: 2021-03-17 19:07:21 ea80f3002f4120f5dcee76e8779dfdc88e1e096c5cdd06904c20fd26d50c3827 +
  6. SHA3-256 for sqlite3.c: e8edc7b1512a2e050d548d0840bec6eef83cc297af1426c34c0ee8720f378a11 + +

+ +

A complete list of SQLite releases + in a single page and a chronology are both also available. + A detailed history of every + check-in is available at + + SQLite version control site.

+ + -- cgit v1.2.3