The default schema format number is changed from 1 to 4.
+ This means that, unless
+ the PRAGMA legacy_file_format=ON statement is
+ run, newly created database files will be unreadable by version of SQLite
+ prior to 3.3.0 (2006-01-10). It also means that the descending indices
+ are enabled by default.
+
If the argument to PRAGMA cache_size is negative N, that means to use
+ approximately -1024*N bytes of memory for the page cache regardless of
+ the page size.
+
Enhanced the default memory allocator to make use of _msize() on windows,
+ malloc_size() on Mac, and malloc_usable_size() on Linux.
+
Enhanced the query planner to support index queries with range constraints
+ on the rowid.
+
Enhanced the query planner flattening logic to allow UNION ALL compounds
+ to be promoted upwards to replace a simple wrapper SELECT even if the
+ compounds are joins.
+
Enhanced the query planner so that the xfer optimization can be used with
+ INTEGER PRIMARY KEY ON CONFLICT as long as the destination table is
+ initially empty.
+
Enhanced the windows VFS so that all system calls can be overridden
+ using the xSetSystemCall interface.
+
Updated the "unix-dotfile" VFS to use locking directories with mkdir()
+ and rmdir() instead of locking files with open() and unlink().
+
Enhancements to the test_quota.c extension to support stdio-like interfaces
+ with quotas.
+
Change the unix VFS to be tolerant of read() system calls that return
+ less then the full number of requested bytes.
+
Change both unix and windows VFSes to report a sector size of 4096
+ instead of the old default of 512.
+
In the TCL Interface, add the -uri option to the "sqlite3" TCL command
+ used for creating new database connection objects.
+
Bug fix:
+ Add an additional xSync when restarting a WAL in order to prevent an
+ exceedingly unlikely but theoretically possible
+ database corruption following power-loss.
+ Ticket ff5be73dee.
+
Bug fix:
+ Change the VDBE so that all registers are initialized to Invalid
+ instead of NULL.
+ Ticket 7bbfb7d442
+
Bug fix:
+ Fix problems that can result from 32-bit integer overflow.
+ Ticket ac00f496b7e2
+