Fully constraint the ORDER BY on the top-10 line of the --summary output
from the wordcount test program. Add the run-wordcount.bash script for
running wordcount in various configurations.
check-in: 7edf39eb user: drh tags: trunk

Improvements to the Expr comparison routine to make it more general.
Improvements to unary-minus code generation so that it can make use of
a global constant register with a zero value.
check-in: 835be656 user: drh tags: expr-codegen-enhancement

Add test cases for skip-scan. Enhance "do_test" so that if the expected result
is of the form "/*..*/" or "~/*..*/" it treats the expected result as a glob
pattern rather than as a regular expression. Fix a bug in ANALYZE result
loading associated with WITHOUT ROWID tables.
check-in: d3e6e9b2 user: drh tags: skip-scan

Add the ability to use an index even if the left-most columns of the index
are unconstrainted, provided that the left-most columns have few distinct
values.
check-in: 27dd5993 user: drh tags: skip-scan

Fix a problem in OP_IdxDelete as used by REPLACE conflict resolution that
comes up due to recent enhancements that reduce the work required for
UNIQUE NOT NULL indices.
check-in: 61d7d475 user: drh tags: trunk

Optimize out a NotExists/NotFound opcode that occurs in UPDATE processing
after constraint checks if there is no possiblity that the constraint checking
code might have moved the cursor.
check-in: 74e3ee2e user: drh tags: trunk