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 */
76693 if( sqlite3WalkExprList(pWalker, p->pGroupBy) ) return WRC_Abort;
77898 ExprList *pGroupBy; /* The GROUP BY clause */
77990 pGroupBy = p->pGroupBy;
77991 if( pGroupBy || (sNC.ncFlags & NC_HasAgg)!=0 ){
77999 if( p->pHaving && !pGroupBy ){
78037 if( pGroupBy ){
78040 if( resolveOrderGroupBy(&sNC, p, pGroupBy, "GROUP") || db->mallocFailed ){
78043 for(i=0, pItem=pGroupBy->a; i<pGroupBy->nExpr; i++, pItem++){
78572 heightOfExprList(p->pGroupBy, pnHeight);
79282 pNew->pGroupBy = sqlite3ExprListDup(db, p->pGroupBy, flags);
79679 assert( p->pGroupBy==0 ); /* Has no GROUP BY clause */
82393 if( pAggInfo->pGroupBy ){
82395 ExprList *pGB = pAggInfo->pGroupBy;
85758 if( sqlite3FixExprList(pFix, pSelect->pGroupBy) ){
96601 if( pSelect->pGroupBy ){
101503 sqlite3ExprListDelete(db, p->pGroupBy);
101533 ExprList *pGroupBy, /* the GROUP BY clause */
101557 pNew->pGroupBy = pGroupBy;
104481 substExprList(db, p->pGroupBy, iTable, pEList);
104951 substExprList(db, pParent->pGroupBy, iParent, pSub->pEList);
104973 assert( pParent->pGroupBy==0 );
104974 pParent->pGroupBy = sqlite3ExprListDup(db, pSub->pGroupBy, 0);
105061 assert( !p->pGroupBy );
105161 pNew->pGroupBy = 0;
105986 ExprList *pGroupBy; /* The GROUP BY clause. May be NULL */
106152 pGroupBy = p->pGroupBy;
106185 p->pGroupBy = sqlite3ExprListDup(db, p->pEList, 0);
106186 pGroupBy = p->pGroupBy;
106243 if( !isAgg && pGroupBy==0 ){
106299 if( pGroupBy ){
106306 for(k=pGroupBy->nExpr, pItem=pGroupBy->a; k>0; k--, pItem++){
106323 if( sqlite3ExprListCompare(pGroupBy, sSort.pOrderBy, -1)==0 ){
106339 sAggInfo.nSortingColumn = pGroupBy ? pGroupBy->nExpr+1 : 0;
106340 sAggInfo.pGroupBy = pGroupBy;
106359 if( pGroupBy ){
106376 pKeyInfo = keyInfoFromExprList(pParse, pGroupBy, 0, 0);
106390 pParse->nMem += pGroupBy->nExpr;
106392 pParse->nMem += pGroupBy->nExpr;
106397 sqlite3VdbeAddOp3(v, OP_Null, 0, iAMem, iAMem+pGroupBy->nExpr-1);
106405 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, 0,
106409 if( sqlite3WhereIsOrdered(pWInfo)==pGroupBy->nExpr ){
106431 nGroupBy = pGroupBy->nExpr;
106442 sqlite3ExprCodeExprList(pParse, pGroupBy, regBase, 0);
106499 for(j=0; j<pGroupBy->nExpr; j++){
106505 sqlite3ExprCode(pParse, pGroupBy->a[j].pExpr, iBMem+j);
106508 sqlite3VdbeAddOp4(v, OP_Compare, iAMem, iBMem, pGroupBy->nExpr,
106522 sqlite3ExprCodeMove(pParse, iBMem, iAMem, pGroupBy->nExpr);
106587 } /* endif pGroupBy. Begin aggregate queries without GROUP BY: */
106679 assert( p->pGroupBy==0 );
106812 if( p->pGroupBy ){
106814 sqlite3ExplainExprList(pVdbe, p->pGroupBy);
111232 mask |= exprListTableUsage(pMaskSet, pS->pGroupBy);
