Lines Matching refs:pGroupBy

85     sqlite3ExprListDelete(db, p->pGroupBy);  in clearSelect()
127 ExprList *pGroupBy, /* the GROUP BY clause */ in sqlite3SelectNew() argument
156 pNew->pGroupBy = pGroupBy; in sqlite3SelectNew()
3896 substExprList(pSubst, p->pGroupBy); in substSelect()
5213 assert( !p->pGroupBy ); in isSimpleCount()
5332 pNew->pGroupBy = 0; in convertCompoundSelectToSubquery()
6425 if( sqlite3ExprIsConstantOrGroupBy(pWalker->pParse, pExpr, pS->pGroupBy) in havingToWhereExprCb()
6548 if( p->pGroupBy ) return 0; in countOfViewOptimization()
6657 ExprList *pGroupBy; /* The GROUP BY clause. May be NULL */ in sqlite3Select() local
6820 assert( pSub->pGroupBy==0 ); in sqlite3Select()
7122 pGroupBy = p->pGroupBy; in sqlite3Select()
7155 pGroupBy = p->pGroupBy = sqlite3ExprListDup(db, pEList, 0); in sqlite3Select()
7237 if( !isAgg && pGroupBy==0 ){ in sqlite3Select()
7329 if( pGroupBy ){ in sqlite3Select()
7336 for(k=pGroupBy->nExpr, pItem=pGroupBy->a; k>0; k--, pItem++){ in sqlite3Select()
7350 if( sSort.pOrderBy && pGroupBy->nExpr==sSort.pOrderBy->nExpr ){ in sqlite3Select()
7357 for(ii=0; ii<pGroupBy->nExpr; ii++){ in sqlite3Select()
7360 pGroupBy->a[ii].fg.sortFlags = sortFlags; in sqlite3Select()
7362 if( sqlite3ExprListCompare(pGroupBy, sSort.pOrderBy, -1)==0 ){ in sqlite3Select()
7394 pAggInfo->nSortingColumn = pGroupBy ? pGroupBy->nExpr : 0; in sqlite3Select()
7395 pAggInfo->pGroupBy = pGroupBy; in sqlite3Select()
7399 if( pGroupBy ){ in sqlite3Select()
7402 assert( pGroupBy==p->pGroupBy ); in sqlite3Select()
7409 if( p->pGroupBy==0 && p->pHaving==0 && pAggInfo->nFunc==1 ){ in sqlite3Select()
7460 if( pGroupBy ){ in sqlite3Select()
7482 pDistinct = sqlite3ExprListDup(db, pGroupBy, 0); in sqlite3Select()
7493 pKeyInfo = sqlite3KeyInfoFromExprList(pParse, pGroupBy, in sqlite3Select()
7508 pParse->nMem += pGroupBy->nExpr; in sqlite3Select()
7510 pParse->nMem += pGroupBy->nExpr; in sqlite3Select()
7513 sqlite3VdbeAddOp3(v, OP_Null, 0, iAMem, iAMem+pGroupBy->nExpr-1); in sqlite3Select()
7522 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, pDistinct, in sqlite3Select()
7532 if( sqlite3WhereIsOrdered(pWInfo)==pGroupBy->nExpr ){ in sqlite3Select()
7554 nGroupBy = pGroupBy->nExpr; in sqlite3Select()
7564 sqlite3ExprCodeExprList(pParse, pGroupBy, regBase, 0, 0); in sqlite3Select()
7614 for(j=0; j<pGroupBy->nExpr; j++){ in sqlite3Select()
7619 sqlite3ExprCode(pParse, pGroupBy->a[j].pExpr, iBMem+j); in sqlite3Select()
7622 sqlite3VdbeAddOp4(v, OP_Compare, iAMem, iBMem, pGroupBy->nExpr, in sqlite3Select()
7636 sqlite3ExprCodeMove(pParse, iBMem, iAMem, pGroupBy->nExpr); in sqlite3Select()
7809 assert( p->pGroupBy==0 ); in sqlite3Select()