Lines Matching defs:pGroupBy
11235 ** AggInfo.pGroupBy and AggInfo.aFunc.pExpr point to fields within the
11248 ExprList *pGroupBy; /* The group by clause */
11698 ExprList *pGroupBy; /* The GROUP BY clause */
76713 if( sqlite3WalkExprList(pWalker, p->pGroupBy) ) return WRC_Abort;
77918 ExprList *pGroupBy; /* The GROUP BY clause */
78010 pGroupBy = p->pGroupBy;
78011 if( pGroupBy || (sNC.ncFlags & NC_HasAgg)!=0 ){
78019 if( p->pHaving && !pGroupBy ){
78057 if( pGroupBy ){
78060 if( resolveOrderGroupBy(&sNC, p, pGroupBy, "GROUP") || db->mallocFailed ){
78063 for(i=0, pItem=pGroupBy->a; i<pGroupBy->nExpr; i++, pItem++){
78592 heightOfExprList(p->pGroupBy, pnHeight);
79302 pNew->pGroupBy = sqlite3ExprListDup(db, p->pGroupBy, flags);
79699 assert( p->pGroupBy==0 ); /* Has no GROUP BY clause */
82413 if( pAggInfo->pGroupBy ){
82415 ExprList *pGB = pAggInfo->pGroupBy;
85778 if( sqlite3FixExprList(pFix, pSelect->pGroupBy) ){
96621 if( pSelect->pGroupBy ){
101523 sqlite3ExprListDelete(db, p->pGroupBy);
101553 ExprList *pGroupBy, /* the GROUP BY clause */
101577 pNew->pGroupBy = pGroupBy;
104501 substExprList(db, p->pGroupBy, iTable, pEList);
104971 substExprList(db, pParent->pGroupBy, iParent, pSub->pEList);
104993 assert( pParent->pGroupBy==0 );
104994 pParent->pGroupBy = sqlite3ExprListDup(db, pSub->pGroupBy, 0);
105081 assert( !p->pGroupBy );
105181 pNew->pGroupBy = 0;
106006 ExprList *pGroupBy; /* The GROUP BY clause. May be NULL */
106172 pGroupBy = p->pGroupBy;
106205 p->pGroupBy = sqlite3ExprListDup(db, p->pEList, 0);
106206 pGroupBy = p->pGroupBy;
106263 if( !isAgg && pGroupBy==0 ){
106319 if( pGroupBy ){
106326 for(k=pGroupBy->nExpr, pItem=pGroupBy->a; k>0; k--, pItem++){
106343 if( sqlite3ExprListCompare(pGroupBy, sSort.pOrderBy, -1)==0 ){
106359 sAggInfo.nSortingColumn = pGroupBy ? pGroupBy->nExpr+1 : 0;
106360 sAggInfo.pGroupBy = pGroupBy;
106379 if( pGroupBy ){
106396 pKeyInfo = keyInfoFromExprList(pParse, pGroupBy, 0, 0);
106410 pParse->nMem += pGroupBy->nExpr;
106412 pParse->nMem += pGroupBy->nExpr;
106417 sqlite3VdbeAddOp3(v, OP_Null, 0, iAMem, iAMem+pGroupBy->nExpr-1);
106425 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, 0,
106429 if( sqlite3WhereIsOrdered(pWInfo)==pGroupBy->nExpr ){
106451 nGroupBy = pGroupBy->nExpr;
106462 sqlite3ExprCodeExprList(pParse, pGroupBy, regBase, 0);
106519 for(j=0; j<pGroupBy->nExpr; j++){
106525 sqlite3ExprCode(pParse, pGroupBy->a[j].pExpr, iBMem+j);
106528 sqlite3VdbeAddOp4(v, OP_Compare, iAMem, iBMem, pGroupBy->nExpr,
106542 sqlite3ExprCodeMove(pParse, iBMem, iAMem, pGroupBy->nExpr);
106607 } /* endif pGroupBy. Begin aggregate queries without GROUP BY: */
106699 assert( p->pGroupBy==0 );
106832 if( p->pGroupBy ){
106834 sqlite3ExplainExprList(pVdbe, p->pGroupBy);
111252 mask |= exprListTableUsage(pMaskSet, pS->pGroupBy);
