diff options
Diffstat (limited to 'src/select.c')
| -rw-r--r-- | src/select.c | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/src/select.c b/src/select.c index dc187dfa6..ae320b697 100644 --- a/src/select.c +++ b/src/select.c @@ -5253,10 +5253,15 @@ static int disableUnusedSubqueryResultColumns(SrcItem *pItem){ assert( pItem!=0 ); assert( pItem->pTab!=0 ); pTab = pItem->pTab; - if( pTab->tabFlags & TF_Ephemeral ) return 0; + if( pTab->tabFlags & TF_Ephemeral ){ + return 0; + } assert( pItem->pSelect!=0 ); pSub = pItem->pSelect; assert( pSub->pEList->nExpr==pTab->nCol ); + if( pSub->selFlags & SF_Distinct ){ + return 0; + } for(pX=pSub; pX; pX=pX->pPrior){ if( pX->pPrior && pX->op!=TK_ALL ){ /* This optimization does not work for compound subqueries that |