Lines Matching defs:pGroupBy
18838 ** AggInfo.pGroupBy and AggInfo.aFunc.pExpr point to fields within the
18851 ExprList *pGroupBy; /* The group by clause */
19510 ExprList *pGroupBy; /* The GROUP BY clause */
20295 ExprList *pGroupBy; /* GROUP BY clause */
32875 if( p->pGroupBy ) n++;
32910 if( p->pGroupBy ){
32911 sqlite3TreeViewExprList(pView, p->pGroupBy, (n--)>0, "GROUPBY");
106598 if( sqlite3WalkExprList(pWalker, p->pGroupBy) ) return WRC_Abort;
108556 ExprList *pGroupBy; /* The GROUP BY clause */
108661 pGroupBy = p->pGroupBy;
108662 if( pGroupBy || (sNC.ncFlags & NC_HasAgg)!=0 ){
108756 if( pGroupBy ){
108759 if( resolveOrderGroupBy(&sNC, p, pGroupBy, "GROUP") || db->mallocFailed ){
108762 for(i=0, pItem=pGroupBy->a; i<pGroupBy->nExpr; i++, pItem++){
109840 heightOfExprList(p->pGroupBy, pnHeight);
110956 pNew->pGroupBy = sqlite3ExprListDup(db, p->pGroupBy, flags);
111700 ExprList *pGroupBy = pWalker->u.pGroupBy;
111705 for(i=0; i<pGroupBy->nExpr; i++){
111706 Expr *p = pGroupBy->a[i].pExpr;
111727 ** in pGroupBy that sort with the BINARY collation sequence.
111743 SQLITE_PRIVATE int sqlite3ExprIsConstantOrGroupBy(Parse *pParse, Expr *p, ExprList *pGroupBy){
111748 w.u.pGroupBy = pGroupBy;
111978 assert( p->pGroupBy==0 ); /* Has no GROUP BY clause */
115796 if( pAggInfo->pGroupBy && pExpr->op!=TK_IF_NULL_ROW ){
115798 ExprList *pGB = pAggInfo->pGroupBy;
135939 if( pSelect->pGroupBy ){
142980 sqlite3ExprListDelete(db, p->pGroupBy);
143022 ExprList *pGroupBy, /* the GROUP BY clause */
143051 pNew->pGroupBy = pGroupBy;
146859 substExprList(pSubst, p->pGroupBy);
148351 assert( !p->pGroupBy );
148470 pNew->pGroupBy = 0;
149456 assert( pSelect->pGroupBy!=0 );
149459 int mx = pSelect->pGroupBy->nExpr - 1;
149899 if( sqlite3ExprIsConstantOrGroupBy(pWalker->pParse, pExpr, pS->pGroupBy)
150028 if( p->pGroupBy ) return 0;
150202 ExprList *pGroupBy; /* The GROUP BY clause. May be NULL */
150408 assert( pSub->pGroupBy==0 );
150713 pGroupBy = p->pGroupBy;
150746 pGroupBy = p->pGroupBy = sqlite3ExprListDup(db, pEList, 0);
150828 if( !isAgg && pGroupBy==0 ){
150920 if( pGroupBy ){
150927 for(k=pGroupBy->nExpr, pItem=pGroupBy->a; k>0; k--, pItem++){
150941 if( sSort.pOrderBy && pGroupBy->nExpr==sSort.pOrderBy->nExpr ){
150948 for(ii=0; ii<pGroupBy->nExpr; ii++){
150951 pGroupBy->a[ii].fg.sortFlags = sortFlags;
150953 if( sqlite3ExprListCompare(pGroupBy, sSort.pOrderBy, -1)==0 ){
150986 pAggInfo->nSortingColumn = pGroupBy ? pGroupBy->nExpr : 0;
150987 pAggInfo->pGroupBy = pGroupBy;
150991 if( pGroupBy ){
150994 assert( pGroupBy==p->pGroupBy );
151001 if( p->pGroupBy==0 && p->pHaving==0 && pAggInfo->nFunc==1 ){
151024 if( pGroupBy ){
151046 pDistinct = sqlite3ExprListDup(db, pGroupBy, 0);
151057 pKeyInfo = sqlite3KeyInfoFromExprList(pParse, pGroupBy,
151072 pParse->nMem += pGroupBy->nExpr;
151074 pParse->nMem += pGroupBy->nExpr;
151077 sqlite3VdbeAddOp3(v, OP_Null, 0, iAMem, iAMem+pGroupBy->nExpr-1);
151086 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, pDistinct,
151100 if( sqlite3WhereIsOrdered(pWInfo)==pGroupBy->nExpr ){
151126 nGroupBy = pGroupBy->nExpr;
151136 sqlite3ExprCodeExprList(pParse, pGroupBy, regBase, 0, 0);
151208 for(j=0; j<pGroupBy->nExpr; j++){
151213 sqlite3ExprCode(pParse, pGroupBy->a[j].pExpr, iBMem+j);
151216 sqlite3VdbeAddOp4(v, OP_Compare, iAMem, iBMem, pGroupBy->nExpr,
151230 sqlite3ExprCodeMove(pParse, iBMem, iAMem, pGroupBy->nExpr);
151304 } /* endif pGroupBy. Begin aggregate queries without GROUP BY: */
151405 assert( p->pGroupBy==0 );
161182 mask |= sqlite3WhereExprListUsage(pMaskSet, pS->pGroupBy);
161857 if( p->pGroupBy==0
170317 ExprList *pGroupBy = p->pGroupBy;
170343 p->pGroupBy = 0;
170418 pParse, pSublist, pSrc, pWhere, pGroupBy, pHaving, pSort, 0, 0