Fix some problems in os_unix.c when compiled with ENABLE_LOCKING_STYLE on OSX. Also some minor issues with test scripts.

FossilOrigin-Name: 8088031bc949bd4efb5edf33bbd1bce5700fca56

Fix a compiler warning and an unreachable branch. Restore 100% branch test
coverage.

FossilOrigin-Name: 4dc148bb4cec5ecba167cdcb4959a4f0fa05a96f

Fix a problem whereby following an IO error in CommitPhaseTwo() of a multi-file transaction the b-tree layer could be left in TRANS_WRITE state, causing problems later on.

FossilOrigin-Name: dbe569a

Fix a problem whereby following an IO error in CommitPhaseTwo() of a multi-file transaction the b-tree layer could be left in TRANS_WRITE state, causing problems later on.

FossilOrigin-Name: dbe569a099c2855480e35c0cc4d9332821ad80da

show more ...

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.

FossilOrigin-Name: 3b96

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.

FossilOrigin-Name: 3b964155f611c437d53d44feafa22f531942b1b4

show more ...

Further improvements to the fuzzer. It still is not quite working. Pausing
to work on other things....

FossilOrigin-Name: 5f2f2fce40f43debeb0492c9b460b85c7dad2bde

Fix a problem in the unix VFS implementation of xNextSystemCall(). Also some typos that prevent compilation when HAVE_POSIX_FALLOCATE is defined.

FossilOrigin-Name: bc6cce81565b17f886478bd51500bba2e

Fix a problem in the unix VFS implementation of xNextSystemCall(). Also some typos that prevent compilation when HAVE_POSIX_FALLOCATE is defined.

FossilOrigin-Name: bc6cce81565b17f886478bd51500bba2ed11ec1d

show more ...

Fix the documentation for the sqlite3_column_*_name() functions to describe
that the information can be invalidated when a prepared statement is
reprepared by the first invocation of an sqlite3_step

Fix the documentation for the sqlite3_column_*_name() functions to describe
that the information can be invalidated when a prepared statement is
reprepared by the first invocation of an sqlite3_step() for a particular
execution cycle.

FossilOrigin-Name: 7270f80ac5dd17b979f1f790b2dfcf811866c1dc

show more ...

Add the ability to enable and disable foreign key constraints and triggers
using calls to sqlite3_db_config().

FossilOrigin-Name: 09e167f9c14625924b17bbb1f292f89ac9ddc93a

Fix a problem with INTEGER PRIMARY KEY columns and the pre-update hook.

FossilOrigin-Name: 24d4d5dd007197a141555bcca6f2ac9ab47cde80

Hold the database mutex for the duration of an sqlite3changeset_apply() call. Also for the duration of all sqlite3session_xxx() calls.

FossilOrigin-Name: c615c38c3283e21c33550c093099a793761123a7

Fixes for compiler warnings. Minor code cleanup.

FossilOrigin-Name: 9604d13001e0a195718c7f03fc0e73e352226caa

Further improvements to documentation in sqlite3session.h.

FossilOrigin-Name: 07019bb9e8d8f2445d1e0342f74ab520e9804cb5

Fix a memory allocation issues in the preupdate hook so that the hook.test
script runs clean in valgrind.

FossilOrigin-Name: bd94f4c8b1c4590c437030f0122015f1a37e2582

Update comments in sqlite3session.h. More to come.

FossilOrigin-Name: e73e9082f3b14088752717193a10dd7657deb8af

Enhances to the query planner such that "x IS NULL" constraints take the
STAT2 statistics into account, just like "x=VALUE" constraints.

FossilOrigin-Name: 2353176811f752a16c1f2351a3d3431919b062a9

Fix an instance of signed arithmetic overflow and an one bit-shift overflow.
Mark six other signed arithmetic overflow locations that need fixing.

FossilOrigin-Name: 04abab71ecd52f6070b9f84781a3df3d

Fix an instance of signed arithmetic overflow and an one bit-shift overflow.
Mark six other signed arithmetic overflow locations that need fixing.

FossilOrigin-Name: 04abab71ecd52f6070b9f84781a3df3d6dba7722

show more ...

Add the experimental sqlite3_preupdate_hook() API.

FossilOrigin-Name: 6145d7b89f83500318713779c60f79a7ab2098ba

When a stale schema-cookie is seen, expire only the one statement that
encountered the bad cookie, not every statement on the database
connection. Ticket [b72787b1a7cea1f]

FossilOrigin-Name: 1bca0

When a stale schema-cookie is seen, expire only the one statement that
encountered the bad cookie, not every statement on the database
connection. Ticket [b72787b1a7cea1f]

FossilOrigin-Name: 1bca0a7e198391202fd2bc1650c0a62028a9aaa5

show more ...

Fix a problem with "EXPLAIN QUERY PLAN SELECT count(*) FROM tbl".

FossilOrigin-Name: 9f9f32882501ac9b6e60f81195a64bdbf6e4497b

Fix harmless compiler warnings in the query planner.

FossilOrigin-Name: 31fc4ba66e76876b2e7b6b2b74c07f47571938ce

Skip some tests in capi3e.test when compiled with SQLITE_OMIT_UTF16.

FossilOrigin-Name: b04304b9677b84c4bfca011bf7fa0488e7d56d08

Add a NEVER() around a test that is believed to always be false.

FossilOrigin-Name: f7e2ea33d5b37e5b133d96e96a11d2842504355c

Skip flattening if subquery has LIMIT and outer query is DISTINCT. Fix for ticket 752e1646fc.

FossilOrigin-Name: 559739998833643f589fa76d8360080691f83c18

Disable unused NULL tests when SQLITE_ENABLE_STAT2 is not in use.

FossilOrigin-Name: 5ecd11788269e78dc26639b2503a10b7e25b2483

Add .testctrl option to CLI.

FossilOrigin-Name: f85afa0ecc7b31d32659ae53e70771cd42abda38