sqlite-autoconf-3360000 (3.36.0)

[Bruce Dubbs]

New minor version.

[Douglas R. Reno]

SQLite Release 3.36.0 On 2021-06-18

    Improvement to the EXPLAIN QUERY PLAN output to make it easier to understand.
    Byte-order marks at the start of a token are skipped as if they were whitespace.
    An error is raised on any attempt to access the rowid of a VIEW or subquery. Formerly, the rowid of a VIEW would be indeterminate and often would be NULL. The -DSQLITE_ALLOW_ROWID_IN_VIEW compile-time option is available to restore the legacy behavior for applications that need it.
    The sqlite3_deserialize() and sqlite3_serialize() interfaces are now enabled by default. The -DSQLITE_ENABLE_DESERIALIZE compile-time option is no longer required. Instead, there is is a new -DSQLITE_OMIT_DESERIALIZE compile-time option to omit those interfaces.
    The "memdb" VFS now allows the same in-memory database to be shared among multiple database connections in the same process as long as the database name begins with "/".
    Back out the EXISTS-to-IN optimization (item 8b in the SQLite 3.35.0 change log) as it was found to slow down queries more often than speed them up.
    Improve the constant-propagation optimization so that it works on non-join queries.
    The REGEXP extension is now included in CLI builds. 

[Douglas R. Reno]

Fixed at aa5c3a7e74eb772d951d754fd0dfbb181b55638a

[Bruce Dubbs]

Milestone renamed