Enhance sqlite3_randomness(N,P) such that it resets the internal PRNG
if N is less than 1.  Subsequent calls to sqlite3_randomness() will reinitialize
the internal PRNG by calling the xRandomness() method of the default VFS.
Try to detect process ID changes due to fork() calls in os_unix.c and
reset the PRNG when a process ID change is detected.
Be more aggressive in optimizing constant conditional expressions.
Avoid unnecessary affinity transformations when building indices using
data from a table.
Try to factor constant subcomponents of the WHERE clause out of the loop.
Avoid some unnecessary OP_SCopy operations when inserting into a table
with multiple indices.
Have the planner detect cases where a MATCH constraint is applied to a virtual table, and ignore any plans that do not allow the virtual table implementation to implement the MATCH filtering.
Instead of having the planner ignore plans with unusable MATCH constraints, have FTS assign extremely high costs to such plans in order to discourage the planner from using them.
Have FTS assign extremely high costs to plans that feature unusable MATCH constraints. This discourages the planner from choosing such plans, which lead to "unable to use function MATCH in the requested context" errors.
Improvements to the column-cache for nested AND/OR operators.
Omit OP_Close operations that occur immediately prior to OP_Halt and which
cannot be jumped over.
Avoid redundant register loads during index key generation when doing a
DELETE or INTEGRITY_CHECK on a table with multiple indices.
Add the usual "fts3" prefix to new static method setEstimatedRows() in fts3.c. This fixes a problem when compiling the amalgamation, as the r-tree module also contains a static method named setEstimatedRows.
Fix an typo that breaks the build when SQLITE_ENABLE_TREE_EXPLAIN is defined.
Fix harmless compiler warning in unixUnfetch().
Fix another harmless compiler warning in unixUnfetch().
Fix CREATE TABLE ... AS so that it works with column names that are empty
strings.
Allow a VALUES clause to be used any place that a SELECT statement can be
used.
Remove unused structure definition from parse.y.
Do not use sprintf(), strcpy() or strcat() in the implementation of the
lemon parser generator tool, to avoid compiler warnings in OpenBSD.