diff options
| author | drh <> | 2024-08-15 23:38:52 +0000 |
|---|---|---|
| committer | drh <> | 2024-08-15 23:38:52 +0000 |
| commit | 235b5d0ac57950437262c40bb92624670dd02a90 (patch) | |
| tree | 0974601a3d8e1d77f8ac06bb48c0dc5f08134e2d /src/sqliteInt.h | |
| parent | 7c5a829025914550de138aab2a8cf3f8090b7c3e (diff) | |
| download | sqlite-235b5d0ac57950437262c40bb92624670dd02a90.tar.gz sqlite-235b5d0ac57950437262c40bb92624670dd02a90.zip | |
If a subquery is materialized due to an ORDER BY and that ordering is useful
in helping to satisfy the ORDER BY or GROUP BY in the order query without
doing an extra sort, then omit the extra sort.
FossilOrigin-Name: 2fbb4dc2327ee435cb2b7a4adcddf5a9cee6dff7de96e2ecb761166427b5ddea
Diffstat (limited to 'src/sqliteInt.h')
| -rw-r--r-- | src/sqliteInt.h | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/sqliteInt.h b/src/sqliteInt.h index dca5bb150..ebd0f01b2 100644 --- a/src/sqliteInt.h +++ b/src/sqliteInt.h @@ -1927,6 +1927,7 @@ struct sqlite3 { #define SQLITE_Coroutines 0x02000000 /* Co-routines for subqueries */ #define SQLITE_NullUnusedCols 0x04000000 /* NULL unused columns in subqueries */ #define SQLITE_OnePass 0x08000000 /* Single-pass DELETE and UPDATE */ +#define SQLITE_OrderBySubq 0x10000000 /* ORDER BY in subquery helps outer */ #define SQLITE_AllOpts 0xffffffff /* All optimizations */ /* |