Lines Matching refs:pGroupBy
16125 ** AggInfo.pGroupBy and AggInfo.aFunc.pExpr point to fields within the
16138 ExprList *pGroupBy; /* The group by clause */
16621 ExprList *pGroupBy; /* The GROUP BY clause */
17242 ExprList *pGroupBy; /* GROUP BY clause */
27130 if( p->pGroupBy ) n++;
27177 if( p->pGroupBy ){
27178 sqlite3TreeViewExprList(pView, p->pGroupBy, (n--)>0, "GROUPBY");
91081 if( sqlite3WalkExprList(pWalker, p->pGroupBy) ) return WRC_Abort;
92313 ExprList *pGroupBy; /* The GROUP BY clause */
92411 pGroupBy = p->pGroupBy;
92412 if( pGroupBy || (sNC.ncFlags & NC_HasAgg)!=0 ){
92421 if( p->pHaving && !pGroupBy ){
92487 if( pGroupBy ){
92490 if( resolveOrderGroupBy(&sNC, p, pGroupBy, "GROUP") || db->mallocFailed ){
92493 for(i=0, pItem=pGroupBy->a; i<pGroupBy->nExpr; i++, pItem++){
93355 heightOfExprList(p->pGroupBy, pnHeight);
94144 pNew->pGroupBy = sqlite3ExprListDup(db, p->pGroupBy, flags);
94553 ExprList *pGroupBy = pWalker->u.pGroupBy;
94558 for(i=0; i<pGroupBy->nExpr; i++){
94559 Expr *p = pGroupBy->a[i].pExpr;
94580 ** in pGroupBy that sort with the BINARY collation sequence.
94596 SQLITE_PRIVATE int sqlite3ExprIsConstantOrGroupBy(Parse *pParse, Expr *p, ExprList *pGroupBy){
94601 w.u.pGroupBy = pGroupBy;
94784 assert( p->pGroupBy==0 ); /* Has no GROUP BY clause */
97798 if( pAggInfo->pGroupBy ){
97800 ExprList *pGB = pAggInfo->pGroupBy;
101264 if( sqlite3FixExprList(pFix, pSelect->pGroupBy) ){
112843 if( pSelect->pGroupBy ){
118759 sqlite3ExprListDelete(db, p->pGroupBy);
118791 ExprList *pGroupBy, /* the GROUP BY clause */
118822 pNew->pGroupBy = pGroupBy;
121929 substExprList(pSubst, p->pGroupBy);
122643 assert( !p->pGroupBy );
122743 pNew->pGroupBy = 0;
123604 ExprList *pGroupBy;
123621 if( sqlite3ExprIsConstantOrGroupBy(pWalker->pParse, pExpr, p->pGroupBy) ){
123653 ExprList *pGroupBy,
123661 sCtx.pGroupBy = pGroupBy;
123805 ExprList *pGroupBy; /* The GROUP BY clause. May be NULL */
123899 assert( pSub->pGroupBy==0 );
124119 pGroupBy = p->pGroupBy;
124159 pGroupBy = p->pGroupBy = sqlite3ExprListDup(db, pEList, 0);
124226 if( !isAgg && pGroupBy==0 ){
124286 if( pGroupBy ){
124293 for(k=pGroupBy->nExpr, pItem=pGroupBy->a; k>0; k--, pItem++){
124311 if( sqlite3ExprListCompare(pGroupBy, sSort.pOrderBy, -1)==0 ){
124327 sAggInfo.nSortingColumn = pGroupBy ? pGroupBy->nExpr : 0;
124328 sAggInfo.pGroupBy = pGroupBy;
124332 if( pGroupBy ){
124334 havingToWhere(pParse, pGroupBy, pHaving, &p->pWhere);
124340 if( p->pGroupBy==0 && p->pHaving==0 && sAggInfo.nFunc==1 ){
124375 if( pGroupBy ){
124392 pKeyInfo = keyInfoFromExprList(pParse, pGroupBy, 0, sAggInfo.nColumn);
124406 pParse->nMem += pGroupBy->nExpr;
124408 pParse->nMem += pGroupBy->nExpr;
124413 sqlite3VdbeAddOp3(v, OP_Null, 0, iAMem, iAMem+pGroupBy->nExpr-1);
124421 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, 0,
124425 if( sqlite3WhereIsOrdered(pWInfo)==pGroupBy->nExpr ){
124447 nGroupBy = pGroupBy->nExpr;
124458 sqlite3ExprCodeExprList(pParse, pGroupBy, regBase, 0, 0);
124510 for(j=0; j<pGroupBy->nExpr; j++){
124515 sqlite3ExprCode(pParse, pGroupBy->a[j].pExpr, iBMem+j);
124518 sqlite3VdbeAddOp4(v, OP_Compare, iAMem, iBMem, pGroupBy->nExpr,
124532 sqlite3ExprCodeMove(pParse, iBMem, iAMem, pGroupBy->nExpr);
124598 } /* endif pGroupBy. Begin aggregate queries without GROUP BY: */
124665 assert( p->pGroupBy==0 );
132246 mask |= sqlite3WhereExprListUsage(pMaskSet, pS->pGroupBy);
