For DELETE operations, make sure that seeks on the main table are not
deferred, since if they are and none of the indexes reference columns of
the table, the seek might never occur until the OP_Delete opcode, which is
too late. Fix for ticket [16c9801ceba49].
check-in: 93a2bace user: drh tags: trunk

In the WHERE generator, when building code for a DELETE operation, make sure
that seeks to the main table are not deferred.
This is a better fix for the [16c9801ceba49] bug than the previous.
Closed-Leaf
check-in: 150dd09e user: drh tags: ticket-16c9801ce

Do not scan indexes that have the integer primary key as their left-most
column. This fixes the crash of ticket [16c9801ceba] but it seems like
the wrong fix. More investigation needed.
check-in: 50312273 user: drh tags: ticket-16c9801ce

Only disable the one-pass DELETE optimization if the WHERE clause contains
a correlated subquery. Uncorrelated subqueries are allowed. This is a
refinement of check-in [3f221f592a9a1] that is the fix for
ticket [dc6ebeda9396087].
check-in: aae38969 user: drh tags: trunk

Disable the PagerDontWrite() optimization for temp tables. It can cause database corruption if a page passed to PagerDontWrite() is dirty at the start of a transaction that is subsequently rolled back.
check-in: 6341ab2f user: dan tags: trunk

The session extension is disabled by default. To enable it using
--enable-session on ./configure on unix and add SESSION=1 to the nmake
on Windows. Or add -DSQLITE_ENABLE_SESSION and
-DSQLITE_ENABLE_PREUPDATE_HOOK to build manually.
check-in: bcaa650e user: drh tags: trunk

Turn the session extension off by default. Enable using --enable-session on
configure scripts, or using the SESSION=1 argument to nmake on Windows.
Closed-Leaf
check-in: e462cde2 user: drh tags: session-make

Fix a test case in temptable2.test so that it works on systems that
lack a coherient cache (ex: OpenBSD) and thus do not support the
"PRAGMA mmap_size" command.
check-in: 088cf838 user: drh tags: trunk

Fix the temporary directory search algorithm for unix so that it fails
gracefully even if all candidate directories are inaccessible. This fixes
a bug that was introduced by check-in [9b8fec60d8e].
check-in: 614bb709 user: drh tags: trunk

Change the sqlite3Atoi64() routine so that it returns failure if not all of
the input characters are consumed, even if it consumed all characters up to
the first 0x00. This has no impact on external APIs as far as I can tell.
check-in: 46d4ffff user: drh tags: trunk

More simplification of the sqlite3AtoF() routine. Add special comments
to indicate branches that are for optimization purposes only and that give
the correct answer even if always or never taken.
check-in: 0065fe97 user: drh tags: trunk

Fix a couple of test script problems on this branch. Both related to the fact that temp database page sizes can no longer be changed by VACUUM or the backup API after the temp db is populated.
check-in: 6bb5aa2b user: dan tags: tempfiles-25

When checking for the WHERE-clause push-down optimization, verify that
all terms of the compound inner SELECT are non-aggregate, not just the
last term. Fix for ticket [f7f8c97e97597].
check-in: ec215f94 user: drh tags: trunk

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