Remove support for the non-standard ON CONFLICT clause on CREATE INDEX.
Ticket #1486. The ON CONFLICT clause has never worked on CREATE INDEX so
removing it should not break anything. (CVS 3042)
check-in: 669bcf5a user: drh tags: trunk

Add "#ifndef NDEBUG" around sqlite3pager_iswriteable() (only used in assert() expressions). Also set the internal page number of a page to zero if it fails to initialise. (CVS 3005)
check-in: 77969c67 user: danielk1977 tags: trunk

Do not flatten subqueries in a join where the subquery includes a LIMIT.
Ticket #1634. This is just an initial fix. Many test cases need to be
added prior to closing the ticket. (CVS 2987)
check-in: af18c0f4 user: drh tags: trunk

Modify the sqlite3OsInMutex os-layer interface to take a single parameter
to distinguish between mutexes held by the current thread and mutexes held
by any thread. Part of the fix for ticket #1630. (CVS 2973)
check-in: e1ad9df1 user: drh tags: trunk

Fix the script that cross-compiles the windows DLL so that it works
correctly with the latest interface. Ticket #1614. Do not strip
the windows DLL. Ticket #1474. (CVS 2954)
check-in: 6591d365 user: drh tags: trunk

Closing a file from the wrong thread is harmless on most systems.
(See ticket #1611)
But on systems like RedHat9 with broken fcntl() locks, it leaks file
descriptors. That is better than the alternative of prematurely breaking
locks and causing database corruption. Nevertheless, it would be good
if we could figure out a way to report errors when closing a file from
the wrong thread. (CVS 2946)
check-in: ad8f12ca user: drh tags: trunk

Add tests and fix bugs in the new cross-thread lock resolution code.
When an unlock fails, do not leak file descriptors (ticket #1611).
But we really ought to report SQLITE_MISUSE or some other error instead
of just returning SQLITE_OK. (CVS 2945)
check-in: f68e05cb user: drh tags: trunk

Documentation updates. Fix to date.c. But most importantly: database
connections are now allowed to change threads as long as they are not
holding a lock. (CVS 2944)
check-in: 03c422ec user: drh tags: trunk