2022-10-03 14:27:52 by Adam Ciarcinski | Files touched by this commit (6) | |
Log message: sqlite3: updated to 3.39.4 Changes in version 3.39.4 (2022-09-29): Fix the build on Windows so that it works with -DSQLITE_OMIT_AUTOINIT Fix a long-standing problem in the btree balancer that might, in rare cases, \ cause database corruption if the application uses an application-defined page \ cache. Enhance SQLITE_DBCONFIG_DEFENSIVE so that it disallows CREATE TRIGGER statements \ if one or more of the statements in the body of the trigger write into shadow \ tables. Fix a possible integer overflow in the size computation for a memory allocation \ in FTS3. Fix a misuse of the sqlite3_set_auxdata() interface in the ICU Extension. |
2022-09-06 20:59:11 by Adam Ciarcinski | Files touched by this commit (6) | |
Log message: sqlite3: updated to 3.39.3 Changes in version 3.39.3 (2022-09-05): Use a statement journal on DML statement affecting two or more database rows if \ the statement makes use of a SQL functions that might abort. See forum thread \ 9b9e4716c0d7bbd1. Use a mutex to protect the PRAGMA temp_store_directory and PRAGMA \ data_store_directory statements, even though they are deprecated and documented \ as not being threadsafe. See forum post 719a11e1314d1c70. Other bug and warning fixes. See the timeline for details. |
2022-07-22 09:05:56 by Adam Ciarcinski | Files touched by this commit (6) | |
Log message: sqlite3: updated to 3.39.2 changes in version 3.39.2 (2022-07-21): Fix a performance regression in the query planner associated with rearranging \ the order of FROM clause terms in the presences of a LEFT JOIN. Apply fixes for CVE-2022-35737, Chromium bugs 1343348 and 1345947, forum post \ 3607259d3c, and other minor problems discovered by internal testing. |
2022-07-14 10:05:51 by Adam Ciarcinski | Files touched by this commit (6) | |
Log message: sqlite3: updated to 3.39.1 Changes in version 3.39.1 (2022-07-13): Fix an incorrect result from a query that uses a view that contains a compound \ SELECT in which only one arm contains a RIGHT JOIN and where the view is not the \ first FROM clause term of the query that contains the view. forum post \ 174afeae5734d42d. Fix some harmless compiler warnings. Fix a long-standing problem with ALTER TABLE RENAME that can only arise if the \ sqlite3_limit(SQLITE_LIMIT_SQL_LENGTH) is set to a very small value. Fix a long-standing problem in FTS3 that can only arise when compiled with the \ SQLITE_ENABLE_FTS3_PARENTHESIS compile-time option. Fix the build so that is works when the SQLITE_DEBUG and SQLITE_OMIT_WINDOWFUNC \ compile-time options are both provided at the same time. Fix the initial-prefix optimization for the REGEXP extension so that it works \ correctly even if the prefix contains characters that require a 3-byte UTF8 \ encoding. Enhance the sqlite_stmt virtual table so that it buffers all of its output. |
2022-07-01 19:49:39 by Adam Ciarcinski | Files touched by this commit (7) | |
Log message: sqlite3: updated to 3.39.0 SQLite Release 3.39.0 On 2022-06-25 Add (long overdue) support for RIGHT and FULL OUTER JOIN. Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM \ that are equivalent to IS and IS NOT, respective, for compatibility with \ PostgreSQL and SQL standards. Add a new return code (value "3") from the sqlite3_vtab_distinct() \ interface that indicates a query that has both DISTINCT and ORDER BY clauses. Added the sqlite3_db_name() interface. The unix os interface resolves all symbolic links in database filenames to \ create a canonical name for the database before the file is opened. Defer materializing views until the materialization is actually needed, thus \ avoiding unnecessary work if the materialization turns out to never be used. The HAVING clause of a SELECT statement is now allowed on any aggregate query, \ even queries that do not have a GROUP BY clause. Many microoptimizations collectively reduce CPU cycles by about 2.3%. |
2022-05-08 10:10:27 by Adam Ciarcinski | Files touched by this commit (6) | |
Log message: sqlite3: updated to 3.38.5 3.38.5 (2022-05-06): Fix a blunder in the CLI of the 3.38.4 release. |
2022-05-05 19:26:42 by Adam Ciarcinski | Files touched by this commit (6) | |
Log message: sqlite3: updated to 3.38.4 3.38.4 (2022-05-04): Fix a byte-code problem in the Bloom filter pull-down optimization added by \ release 3.38.0 in which an error in the byte code causes the byte code engine to \ enter an infinite loop when the pull-down optimization encounters a NULL key. |
2022-04-27 19:12:18 by Adam Ciarcinski | Files touched by this commit (8) | |
Log message: sqlite3: updated to 3.38.3 changes in version 3.38.3 (2022-04-27): Fix a case of the query planner be overly aggressive with optimizing \ automatic-index and Bloom-filter construction, using inappropriate ON clause \ terms to restrict the size of the automatic-index or Bloom filter, and resulting \ in missing rows in the output. Forum thread 0d3200f4f3bcd3a3. Other minor patches. See the timeline for details. |
2022-04-18 21:12:27 by Adam Ciarcinski | Files touched by this commit (1798) | |
Log message: revbump for textproc/icu update |
2022-03-28 21:38:27 by Adam Ciarcinski | Files touched by this commit (6) | |
Log message: sqlite3: updated to 3.38.2 Additional changes in version 3.38.2 (2022-03-26): Fix another user-discovered problem with the new Bloom filter optimization that \ might cause an incorrect answer when doing a LEFT JOIN with a WHERE clause \ constraint that says that one of the columns on the right table of the LEFT JOIN \ is NULL. See forum thread 031e262a89b6a9d2. Other minor patches. See the timeline for details. |