Backport check-ins [0900e35348f4b9bf3] and [4fead8e714c7e50] to the 3.7.2
branch. These check-ins provide hints to the btree layer for when it is
possible to use a hash table rather than a btree to implement an index.
The SQLite BTree layer does not use these hints, but alternative btree layers
might.
check-in: 7155e6f3 user: drh tags: branch-3.7.2

Add documentation for the newly introduced sqlite3_vtab_config() and on_conflict() API functions. Test that encountering an SQLITE_MISMATCH in fts3 does not corrupt the full text index.
check-in: abdd70ae user: dan tags: vtab-conflict

Change the prototype for the open() system call to agree with Posix.
Though a faulty function prototype in a pointer cast is a seemingly innocuous
error, the correct prototype is necessary for pthreads to work correctly
on NetBSD.
check-in: 986f2f25 user: drh tags: branch-3.7.6

Change the prototype for the open() system call to agree with Posix. Though
a faulty function prototype in a pointer cast is a seemingly innocuous error,
the correct prototype is necessary for pthreads to work correctly on NetBSD.
check-in: 3e135748 user: drh tags: trunk

Backport check-in [9f9f32882501ac9] to provide EXPLAIN QUERY PLAN output for
the count(*) optimization. Also backport check-in [a8761a9128de945aa] to
prevent unordered indices from being used on a full table scan. The first
backport was necessary in order to test the second.
check-in: 8d924e16 user: drh tags: branch-3.7.2

Add an OP_VerifyCookie instruction to "CREATE XXX IF NOT EXISTS" commands. This way, if the specified database object existed when the statement was compiled but removed from the database before sqlite3_step() was called, the statement still works as expected (and creates the object).
check-in: b9dbd993 user: dan tags: trunk

If the keyword "unordered" appears at the end of the SQLITE_STAT1.STAT
column for an index, then use that index for equality lookups only, never
for range queries or sorting. This feature is currently undocumented and
my change or be removed in a future release.
check-in: 8a42e236 user: drh tags: trunk

When ATTACH-ing a new database to an existing database with a codec, do
not enable the codec in the attached database if it is not enabled in the
existing database and it is not requested by the USING clause.
check-in: 4caa5fc8 user: drh tags: trunk

Make sure the query planner is able to correctly analyze NULL value
samples in the sqlite_stat2 table. This is a backport of changes
from check-in [f73a167b434f]
check-in: 1d637889 user: drh tags: branch-3.7.2

Make sure the left-hand side of the IS NOT NULL operator is a simple column
and not a general expression before applying the IS NOT NULL
optimization. This is a backport of check-in [543f75a6abe3].
check-in: e8177e01 user: drh tags: branch-3.7.2

Always make sure the left-hand side of the IS NOT NULL operator is a
simple column, not a general expression, before applying the IS NOT NULL
query optimization.
check-in: 543f75a6 user: drh tags: trunk

Fix a performance regression: Keep two btree masks in each prepared
statement; one for btrees used and another for btrees that require locks.
Only try to lock the btrees identified by the second mask.
check-in: 614de91a user: drh tags: trunk

This page was generated in about
0.008s by
Fossil 2.10 [b94e15cff7] 2019-09-13 13:54:36