diff options
| author | drh <drh@noemail.net> | 2012-09-28 00:44:28 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2012-09-28 00:44:28 +0000 |
| commit | f784c1ede942139d136f7c00a1d8fb30a4a31f18 (patch) | |
| tree | ccdfa605d3e6889f40d2af087b833a9eec956584 /src/delete.c | |
| parent | 8ccc6d4076631f3fd97751ce1451453e70c6e329 (diff) | |
| parent | a9e3fc05f58a055ffdb67dca2a8215efb698a955 (diff) | |
| download | sqlite-f784c1ede942139d136f7c00a1d8fb30a4a31f18.tar.gz sqlite-f784c1ede942139d136f7c00a1d8fb30a4a31f18.zip | |
Query planner enhancements to be more agressive about optimizing out ORDER BY
clauses - in particular the query planner now has the ability to omit ORDER BY
clauses that span multiple tables in a join.
FossilOrigin-Name: 1e874629d7cf568368b912b295bd3001147d0b52
Diffstat (limited to 'src/delete.c')
| -rw-r--r-- | src/delete.c | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/delete.c b/src/delete.c index 44e5995a6..f7f52865e 100644 --- a/src/delete.c +++ b/src/delete.c @@ -638,7 +638,9 @@ int sqlite3GenerateIndexKey( } if( doMakeRec ){ const char *zAff; - if( pTab->pSelect || (pParse->db->flags & SQLITE_IdxRealAsInt)!=0 ){ + if( pTab->pSelect + || OptimizationDisabled(pParse->db, SQLITE_IdxRealAsInt) + ){ zAff = 0; }else{ zAff = sqlite3IndexAffinityStr(v, pIdx); |