diff options
| author | drh <> | 2021-05-04 12:07:16 +0000 |
|---|---|---|
| committer | drh <> | 2021-05-04 12:07:16 +0000 |
| commit | 433a3e935de3d4dbfe81e7626e7d511ae3700e1b (patch) | |
| tree | 64dba3b597679260e81c8c6bfa182870dc78d0a4 /src/sqliteInt.h | |
| parent | f83d501c6dd1e7a5f41c698576e21fb3a15bf454 (diff) | |
| download | sqlite-433a3e935de3d4dbfe81e7626e7d511ae3700e1b.tar.gz sqlite-433a3e935de3d4dbfe81e7626e7d511ae3700e1b.zip | |
Back out the EXISTS-to-IN optimization. It slows things down rather than
speeds them up depending on the query. And (see
[forum:/forumpost/8692d94725|forum post 8692d94725]) it sometimes results in
an incorrect answer. We may come back and revisit this optimization later,
but for now it seems best just to disable it.
FossilOrigin-Name: 16252d73fa73569fd7506676f6ffbbcd43addfb105384fb74449d30ca720904a
Diffstat (limited to 'src/sqliteInt.h')
| -rw-r--r-- | src/sqliteInt.h | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/src/sqliteInt.h b/src/sqliteInt.h index b8b6b340d..54880ab02 100644 --- a/src/sqliteInt.h +++ b/src/sqliteInt.h @@ -1731,7 +1731,6 @@ struct sqlite3 { #define SQLITE_SkipScan 0x00004000 /* Skip-scans */ #define SQLITE_PropagateConst 0x00008000 /* The constant propagation opt */ #define SQLITE_MinMaxOpt 0x00010000 /* The min/max optimization */ -#define SQLITE_ExistsToIN 0x00020000 /* The EXISTS-to-IN optimization */ #define SQLITE_AllOpts 0xffffffff /* All optimizations */ /* |