diff options
| author | drh <drh@noemail.net> | 2013-09-03 14:03:47 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2013-09-03 14:03:47 +0000 |
| commit | 67a5ec7b540ecadafb4595a62df3f03d6f544b80 (patch) | |
| tree | dc99f8c314f329bb205b699adb380c06816b8b4a /src | |
| parent | 05db3c774324a99946d867092c9af282fe177e69 (diff) | |
| download | sqlite-67a5ec7b540ecadafb4595a62df3f03d6f544b80.tar.gz sqlite-67a5ec7b540ecadafb4595a62df3f03d6f544b80.zip | |
Make sure the omit-noop-left-join optimization is not applied if columns
of the LEFT JOIN are used in the ORDER BY clause.
Ticket [be84e357c035]
FossilOrigin-Name: 0303d6bc7112e6f810ae1bd75cafc5ffc51f5212
Diffstat (limited to 'src')
| -rw-r--r-- | src/where.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/where.c b/src/where.c index 39650d62e..b633dfd57 100644 --- a/src/where.c +++ b/src/where.c @@ -5909,7 +5909,7 @@ WhereInfo *sqlite3WhereBegin( && OptimizationEnabled(db, SQLITE_OmitNoopJoin) ){ Bitmask tabUsed = exprListTableUsage(pMaskSet, pResultSet); - if( pOrderBy ) tabUsed |= exprListTableUsage(pMaskSet, pOrderBy); + if( sWLB.pOrderBy ) tabUsed |= exprListTableUsage(pMaskSet, sWLB.pOrderBy); while( pWInfo->nLevel>=2 ){ WhereTerm *pTerm, *pEnd; pLoop = pWInfo->a[pWInfo->nLevel-1].pWLoop; |