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_23_0.html | 224 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 224 insertions(+) create mode 100644 www/releaselog/3_23_0.html (limited to 'www/releaselog/3_23_0.html') diff --git a/www/releaselog/3_23_0.html b/www/releaselog/3_23_0.html new file mode 100644 index 0000000..6cf8a3e --- /dev/null +++ b/www/releaselog/3_23_0.html @@ -0,0 +1,224 @@ + + + + + +SQLite Release 3.23.0 On 2018-04-02 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.23.0 On 2018-04-02

    +
  1. Add the sqlite3_serialize() and sqlite3_deserialize() interfaces when + the SQLITE_ENABLE_DESERIALIZE compile-time option is used. +
  2. Recognize TRUE and FALSE as constants. (For compatibility, if there + exist columns named "true" or "false", then the identifiers refer to the + columns rather than Boolean constants.) +
  3. Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE. +
  4. Added the SQLITE_DBSTATUS_CACHE_SPILL option to sqlite3_db_status() for + reporting the number of cache spills that have occurred. +
  5. The "alternate-form-2" flag ("!") on the built-in printf implementation + now causes string substitutions to measure the width and precision in + characters instead of bytes. +
  6. If the xColumn method in a virtual table implementation returns + an error message using sqlite3_result_error() then give that error + message preference over internally-generated messages. +
  7. Added the -A command-line option to the CLI to make it easier to manage + SQLite Archive files. +
  8. Add support for INSERT OR REPLACE, INSERT OR IGNORE, and UPDATE OR REPLACE + in the Zipfile virtual table. +
  9. Enhance the sqlite3changeset_apply() interface so that it is hardened + against attacks from deliberately corrupted changeset objects. +
  10. Added the sqlite3_normalize() + extension function. +
  11. Query optimizer enhancements: +
      +
    1. Improve the omit-left-join optimization so that it works in cases where + the right-hand table is UNIQUE but not necessarily NOT NULL. +
    2. Improve the push-down optimization so that it works for many LEFT JOINs. +
    3. Add the LEFT JOIN strength reduction optimization that converts a LEFT + JOIN into an ordinary JOIN if there exist terms in the WHERE clause + that would prevent the extra all-NULL row of the LEFT JOIN from + appearing in the output set. +
    4. Avoid unnecessary writes to the sqlite_sequence table when an + AUTOINCREMENT table is updated with an rowid that is less than the + maximum. +
    +
  12. Bug fixes: +
      +
    1. Fix the parser to accept valid row value syntax. + Ticket 7310e2fb3d046a5 +
    2. Fix the query planner so that it takes into account dependencies in + the arguments to table-valued functions in subexpressions in + the WHERE clause. + Ticket 80177f0c226ff54 +
    3. Fix incorrect result with complex OR-connected WHERE and STAT4. + Ticket ec32177c99ccac2 +
    4. Fix potential corruption in indexes on expressions due to automatic + datatype conversions. + Ticket 343634942dd54ab +
    5. Assertion fault in FTS4. + Ticket d6ec09eccf68cfc +
    6. Incorrect result on the less-than operator in row values. + Ticket f484b65f3d62305 +
    7. Always interpret non-zero floating-point values as TRUE, even if + the integer part is zero. + Ticket 36fae083b450e3a +
    8. Fix an issue in the fsdir(PATH) table-valued function to the + fileio.c extension, + that caused a segfault if the fsdir() table was used as the inner table + of a join. Problem reported on the mailing list and fixed by check-in + 7ce4e71c1b7251be +
    9. Issue an error rather instead of an assertion-fault or null-pointer + dereference when the sqlite_master table is corrupted so that the + sqlite_sequence table root page is really a btree-index page. Check-in + 525deb7a67fbd647 +
    10. Fix the ANALYZE command so that it computes statistics on tables + whose names begin with "sqlite". Check-in + 0249d9aecf69948d +
    +
  13. Additional fixes for issues detected by + OSSFuzz: +
      +
    1. Fix a possible infinite loop on VACUUM for corrupt database files. + Check-in 27754b74ddf64 +
    2. Disallow parameters in the WITH clause of triggers and views. + Check-in b918d4b4e546d +
    3. Fix a potential memory leak in row value processing. + Check-in 2df6bbf1b8ca8 +
    4. Improve the performance of the replace() SQL function for cases where + there are many substitutions on megabyte-sized strings, in an attempt + to avoid OSSFuzz timeouts during testing. + Check-in fab2c2b07b5d3 +
    5. Provide an appropriate error message when the sqlite_master table + contains a CREATE TABLE AS statement. Formerly this caused either an + assertion fault or null pointer dereference. Problem found by OSSFuzz + on the GDAL project. Check-in + d75e67654aa96 +
    6. Incorrect assert() statement removed. Check-in + 823779d31eb09cda. +
    7. Fix a problem with using the LIKE optimization on an + INTEGER PRIMARY KEY. Check-in + b850dd159918af56. +
    +

    Hashes: +

  14. SQLITE_SOURCE_ID: "2018-04-02 11:04:16 736b53f57f70b23172c30880186dce7ad9baa3b74e3838cae5847cffb98f5cd2" +
  15. SHA3-256 for sqlite3.c: 4bed3dc2dc905ff55e2c21fd2725551fc0ca50912a9c96c6af712a4289cb24fa + +

+ +

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