157039     u16 wctrlFlags = (sDistinct.isTnct ? WHERE_WANT_DISTINCT : 0)  local
157053                                p->pEList, p, wctrlFlags, p->nSelectRow);
163523   u16 wctrlFlags;           /* Flags originally passed to sqlite3WhereBegin() */  member
163582   u16 wctrlFlags                  /* Flags passed to sqlite3WhereBegin() */
163594   u16 wctrlFlags                  /* Flags passed to sqlite3WhereBegin() */
163810   u16 wctrlFlags                  /* Flags passed to sqlite3WhereBegin() */  argument
163835             || (wctrlFlags&(WHERE_ORDERBY_MIN|WHERE_ORDERBY_MAX));
163937   u16 wctrlFlags                  /* Flags passed to sqlite3WhereBegin() */  argument
163945      && (wctrlFlags & WHERE_OR_SUBCLAUSE)==0
163952       sqlite3WhereAddExplainText(pParse, addr, pTabList, pLevel, wctrlFlags);
164978   if( (pWInfo->wctrlFlags & (WHERE_OR_SUBCLAUSE|WHERE_RIGHT_JOIN))
165222   assert( (pWInfo->wctrlFlags & (WHERE_OR_SUBCLAUSE|WHERE_RIGHT_JOIN))
165860            && (pWInfo->wctrlFlags & (WHERE_OR_SUBCLAUSE|WHERE_RIGHT_JOIN))==0;
165893       assert( (pWInfo->wctrlFlags & (WHERE_OR_SUBCLAUSE|WHERE_RIGHT_JOIN))==0 );
166024     if( (pWInfo->wctrlFlags & WHERE_DUPLICATES_OK)==0 ){
166134           if( (pWInfo->wctrlFlags & WHERE_DUPLICATES_OK)==0 ){
166313             && (pWInfo->wctrlFlags & WHERE_OR_SUBCLAUSE)!=0 );
170107       int bSortByGroup = (pWInfo->wctrlFlags & WHERE_SORTBYGROUP)!=0;
170109       if( (pWInfo->wctrlFlags & WHERE_DISTINCTBY) && !pSrc->fg.rowidUsed ){
170111       }else if( pWInfo->wctrlFlags & WHERE_GROUPBY ){
170113       }else if( pWInfo->wctrlFlags & WHERE_WANT_DISTINCT ){
172656    && (pWInfo->wctrlFlags & (WHERE_RIGHT_JOIN|WHERE_OR_SUBCLAUSE))==0
172737     assert( (pWInfo->wctrlFlags & WHERE_ONEPASS_DESIRED)==0 || b==0 );
172829          && (pWInfo->wctrlFlags & WHERE_ONEPASS_DESIRED)==0
173692     if( (pWInfo->wctrlFlags & WHERE_GROUPBY)==0 ){
173740   u16 wctrlFlags,       /* WHERE_GROUPBY or _DISTINCTBY or _ORDERBY_LIMIT */  argument
173803   if( wctrlFlags & (WHERE_ORDERBY_LIMIT|WHERE_ORDERBY_MAX|WHERE_ORDERBY_MIN) ){
173810       if( wctrlFlags & WHERE_ORDERBY_LIMIT ) continue;
173844         assert( wctrlFlags &
173976           testcase( wctrlFlags & WHERE_GROUPBY );
173977           testcase( wctrlFlags & WHERE_DISTINCTBY );
173979           if( (wctrlFlags & (WHERE_GROUPBY|WHERE_DISTINCTBY))==0 ) bOnce = 0;
173994           if( wctrlFlags & WHERE_DISTINCTBY ){
174000         if( isMatch && (wctrlFlags & WHERE_GROUPBY)==0 ){
174095   assert( pWInfo->wctrlFlags & (WHERE_GROUPBY|WHERE_DISTINCTBY) );
174096   assert( pWInfo->wctrlFlags & WHERE_SORTBYGROUP );
174160   if( (pWInfo->wctrlFlags & WHERE_USE_LIMIT)!=0 ){
174168   }else if( (pWInfo->wctrlFlags & WHERE_WANT_DISTINCT) ){
174561                        pWInfo->pOrderBy, pFrom, pWInfo->wctrlFlags,
174775   if( (pWInfo->wctrlFlags & WHERE_WANT_DISTINCT)!=0
174776    && (pWInfo->wctrlFlags & WHERE_DISTINCTBY)==0
174790     if( pWInfo->wctrlFlags & WHERE_DISTINCTBY ){
174819             && (pWInfo->wctrlFlags & (WHERE_ORDERBY_MIN|WHERE_ORDERBY_MAX))!=0
174824     if( (pWInfo->wctrlFlags & WHERE_SORTBYGROUP)
174953   if( pWInfo->wctrlFlags & WHERE_OR_SUBCLAUSE ) return 0;
175015     if( pWInfo->wctrlFlags & WHERE_WANT_DISTINCT ){
175135   assert( 0==(pWInfo->wctrlFlags & WHERE_AGG_DISTINCT) );
175150     if( (pWInfo->wctrlFlags & WHERE_WANT_DISTINCT)==0
175425   u16 wctrlFlags,         /* The WHERE_* flags defined in sqliteInt.h */  argument
175443   assert( (wctrlFlags & WHERE_ONEPASS_MULTIROW)==0 || (
175444         (wctrlFlags & WHERE_ONEPASS_DESIRED)!=0
175445      && (wctrlFlags & WHERE_OR_SUBCLAUSE)==0
175449   assert( (wctrlFlags & WHERE_OR_SUBCLAUSE)==0
175450             || (wctrlFlags & WHERE_USE_LIMIT)==0 );
175460     wctrlFlags &= ~WHERE_WANT_DISTINCT;
175461     wctrlFlags |= WHERE_KEEP_ALL_JOINS; /* Disable omit-noop-join opt */
175478   nTabList = (wctrlFlags & WHERE_OR_SUBCLAUSE) ? 1 : pTabList->nSrc;
175504   pWInfo->wctrlFlags = wctrlFlags;
175536     if( (wctrlFlags & WHERE_WANT_DISTINCT)!=0
175628   if( wctrlFlags & WHERE_WANT_DISTINCT ){
175632       wctrlFlags &= ~WHERE_WANT_DISTINCT;
175633       pWInfo->wctrlFlags &= ~WHERE_WANT_DISTINCT;
175639       pWInfo->wctrlFlags |= WHERE_DISTINCTBY;
175647     sqlite3DebugPrintf("*** Optimizer Start *** (wctrlFlags: 0x%x",wctrlFlags);
175648     if( wctrlFlags & WHERE_USE_LIMIT ){
175707     if( (pWInfo->wctrlFlags & WHERE_WANT_DISTINCT)!=0 ){
175763    && 0==(wctrlFlags & (WHERE_AGG_DISTINCT|WHERE_KEEP_ALL_JOINS)) /* (1),(6) */
175808   assert( (wctrlFlags & WHERE_ONEPASS_DESIRED)==0 || pWInfo->nLevel==1 );
175809   if( (wctrlFlags & WHERE_ONEPASS_DESIRED)!=0 ){
175814         0!=(wctrlFlags & WHERE_ONEPASS_MULTIROW)
175816      && (0==(wsFlags & WHERE_MULTI_OR) || (wctrlFlags & WHERE_DUPLICATES_OK))
175821         if( wctrlFlags & WHERE_ONEPASS_MULTIROW ){
175862          && (wctrlFlags & WHERE_OR_SUBCLAUSE)==0)
175915       assert( iAuxArg!=0 || (pWInfo->wctrlFlags & WHERE_ONEPASS_DESIRED)==0 );
175917        && (wctrlFlags & WHERE_OR_SUBCLAUSE)!=0
175926         assert( wctrlFlags & WHERE_ONEPASS_DESIRED );
175933       }else if( iAuxArg && (wctrlFlags & WHERE_OR_SUBCLAUSE)!=0 ){
175958          && (pWInfo->wctrlFlags&WHERE_ORDERBY_MIN)==0
176055         pParse, pTabList, pLevel, wctrlFlags
176060     if( (wsFlags&WHERE_MULTI_OR)==0 && (wctrlFlags&WHERE_OR_SUBCLAUSE)==0 ){
176441                   pWInfo->wctrlFlags