- Update to version 3.21.0
  * Take advantage of the atomic-write capabilities in the F2FS
    filesystem when available, for greatly reduced transaction
    overhead. This currently requires the
    SQLITE_ENABLE_BATCH_ATOMIC_WRITE compile-time option.
  * Allow ATTACH and DETACH commands to work inside of a
    transaction.
  * Allow WITHOUT ROWID virtual tables to be writable if the
    PRIMARY KEY contains exactly one column.
  * The "fsync()" that occurs after the header is written in a
    WAL reset now uses the sync settings for checkpoints.
    This means it will use a "fullfsync" on macs if PRAGMA
    checkpoint_fullfsync set on.
  * The sqlite3_sourceid() function tries to detect if the source
    code has been modified from what is checked into version
    control and if there are modifications, the last four
    characters of the version hash are shown as "alt1" or
    "alt2". The objective is to detect accidental and/or
    careless edits. A forger can subvert this feature.
  * Improved de-quoting of column names for CREATE TABLE AS
    statements with an aggregate query on the right-hand side.
  * Fewer "stat()" system calls issued by the unix VFS.
  * Enhanced the LIKE optimization so that it works with an
    ESCAPE clause.
  * Enhanced PRAGMA integrity_check and PRAGMA quick_check
    to detect obscure row corruption that they were formerly
    missing. Also update both pragmas so that they return
    error text rather than SQLITE_CORRUPT when encountering
    corruption in records.
  * The query planner now prefers to implement FROM-clause

• Files Changed
• Browse Source