Do not journal the locking page which doing an autovacuum. Similar to the
problem of #1432 except that this one occurs on autovacuum instead of vacuum.
An assert() has been added to catch any future incidents of this type. (CVS 2704)
check-in: 5b6dc12b user: drh tags: trunk

The shell does not output the sqlite_stat1 table on .dump or .schema.
The ANALYZE command now gathers statistics on tables that have only
a single index because this sometimes helps when reordering tables
in a join. (CVS 2686)
check-in: 26565b89 user: drh tags: trunk

A SUM() of all NULLs returns NULL. A SUM() of nothing return 0.
A SUM() of a mixture of NULLs and numbers returns the sum of the
numbers. Ticket #1413. (CVS 2677)
check-in: 2e6230ed user: drh tags: trunk

The SUM() aggregate function returns an integer result if all inputs are
integers. Any single non-integer input causes the result to be a floating
point value. (CVS 2669)
check-in: 21adf4bd user: drh tags: trunk

Sorting is now done using a sorting index rather than loading the entire
result set into memory and doing a merge sort. The old merge sort technique
was a carry-over from SQLite version 1. The new method uses a bounded amount
of memory and scales to much larger result sets. There are still errors:
some 39 regression tests fail. (CVS 2653)
check-in: 09db0a24 user: drh tags: trunk

The LIKE optimization does the right thing when collating sequences are
present. LIKE expressions where the left-hand side has COLLATE NOCASE
are optimized in the default case. (CVS 2637)
check-in: ef84ff79 user: drh tags: trunk

When the left-hand side of an IN operator is constant and the right-hand
side is a SELECT, recognize that the IN operator is not constant.
Ticket #1380. (CVS 2624)
check-in: fc9e0460 user: drh tags: trunk