diff options
author | drh <drh@noemail.net> | 2013-06-26 11:49:45 +0000 |
---|---|---|
committer | drh <drh@noemail.net> | 2013-06-26 11:49:45 +0000 |
commit | 692b9a43dd2663da1eb04980083c70a8320d4025 (patch) | |
tree | 78641e39600c587be03e0ee65875c7c2b80400eb /src/sqliteInt.h | |
parent | 4580cfb93ea377f5bae4a182cf6d1e15deade81e (diff) | |
parent | 1031bd99581c1c3d7da99eb1c9a74a4cf053e0da (diff) | |
download | sqlite-692b9a43dd2663da1eb04980083c70a8320d4025.tar.gz sqlite-692b9a43dd2663da1eb04980083c70a8320d4025.zip |
Omit tables from the FROM clause of a join if their presence makes no difference
in the final output.
FossilOrigin-Name: 6505e2ab0200736c525b5cfcf1cb62c0bd4d18ee
Diffstat (limited to 'src/sqliteInt.h')
-rw-r--r-- | src/sqliteInt.h | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/sqliteInt.h b/src/sqliteInt.h index b2cab7a7a..0a661937f 100644 --- a/src/sqliteInt.h +++ b/src/sqliteInt.h @@ -1024,6 +1024,7 @@ struct sqlite3 { #define SQLITE_OrderByIdxJoin 0x0080 /* ORDER BY of joins via index */ #define SQLITE_SubqCoroutine 0x0100 /* Evaluate subqueries as coroutines */ #define SQLITE_Transitive 0x0200 /* Transitive constraints */ +#define SQLITE_OmitNoopJoin 0x0400 /* Omit unused tables in joins */ #define SQLITE_AllOpts 0xffff /* All optimizations */ /* @@ -1974,6 +1975,7 @@ struct SrcList { #define WHERE_AND_ONLY 0x0080 /* Don't use indices for OR terms */ #define WHERE_GROUPBY 0x0100 /* pOrderBy is really a GROUP BY */ #define WHERE_DISTINCTBY 0x0200 /* pOrderby is really a DISTINCT clause */ +#define WHERE_WANT_DISTINCT 0x0400 /* All output needs to be distinct */ /* Allowed return values from sqlite3WhereIsDistinct() */ |