Lines Matching defs:pOrderBy
11615 #define WHERE_GROUPBY 0x0100 /* pOrderBy is really a GROUP BY */
11616 #define WHERE_DISTINCTBY 0x0200 /* pOrderby is really a DISTINCT clause */
11700 pOrderBy; /* The ORDER BY clause */
11820 ExprList *pOrderBy; /* Key columns for SRT_Queue and SRT_DistQueue */
76695 if( sqlite3WalkExprList(pWalker, p->pOrderBy) ) return WRC_Abort;
77691 ExprList *pOrderBy;
77696 pOrderBy = pSelect->pOrderBy;
77697 if( pOrderBy==0 ) return 0;
77700 if( pOrderBy->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
77705 for(i=0; i<pOrderBy->nExpr; i++){
77706 pOrderBy->a[i].done = 0;
77718 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
77762 for(i=0; i<pOrderBy->nExpr; i++){
77763 if( pOrderBy->a[i].done==0 ){
77773 ** Check every term in the ORDER BY or GROUP BY clause pOrderBy of
77785 ExprList *pOrderBy, /* The ORDER BY or GROUP BY clause to be processed */
77793 if( pOrderBy==0 || pParse->db->mallocFailed ) return 0;
77795 if( pOrderBy->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
77802 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
77815 ** pOrderBy is an ORDER BY or GROUP BY clause in SELECT statement pSelect.
77817 ** "ORDER" or "GROUP" depending on which type of clause pOrderBy is.
77834 Select *pSelect, /* The SELECT statement holding pOrderBy */
77835 ExprList *pOrderBy, /* An ORDER BY or GROUP BY clause to resolve */
77844 if( pOrderBy==0 ) return 0;
77847 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
77884 return sqlite3ResolveOrderGroupBy(pParse, pSelect, pOrderBy, zType);
78027 if( !isCompound && resolveOrderGroupBy(&sNC, p, p->pOrderBy, "ORDER") ){
78573 heightOfExprList(p->pOrderBy, pnHeight);
79284 pNew->pOrderBy = sqlite3ExprListDup(db, p->pOrderBy, flags);
85764 if( sqlite3FixExprList(pFix, pSelect->pOrderBy) ){
90961 ExprList *pOrderBy, /* The ORDER BY clause. May be null */
90975 if( pOrderBy && (pLimit == 0) ) {
91013 pOrderBy,0,pLimit,pOffset);
91034 sqlite3ExprListDelete(pParse->db, pOrderBy);
96596 if( pSelect->pOrderBy ){
101485 ExprList *pOrderBy; /* The ORDER BY (or GROUP BY clause) */
101505 sqlite3ExprListDelete(db, p->pOrderBy);
101535 ExprList *pOrderBy, /* the ORDER BY clause */
101559 pNew->pOrderBy = pOrderBy;
101917 int nExpr = pSort->pOrderBy->nExpr;
101925 sqlite3ExprCodeExprList(pParse, pSort->pOrderBy, regBase, 0);
101948 pOp->p4.pKeyInfo = keyInfoFromExprList(pParse, pSort->pOrderBy, nOBSat, 1);
102082 if( pSort && pSort->pOrderBy==0 ) pSort = 0;
102308 ** pDest->pOrderBy (in pSO). pDest->iSDParm (in iParm) is the cursor for an
102319 pSO = pDest->pOrderBy;
102558 ** If the inner loop was generated using a non-null pOrderBy argument,
102577 ExprList *pOrderBy = pSort->pOrderBy;
102599 nKey = pOrderBy->nExpr - pSort->nOBSat;
103274 ExprList *pOrderBy = p->pOrderBy;
103275 int nOrderBy = p->pOrderBy->nExpr;
103281 struct ExprList_item *pItem = &pOrderBy->a[i];
103290 pOrderBy->a[i].pExpr =
103295 pRet->aSortOrder[i] = pOrderBy->a[i].sortOrder;
103358 ExprList *pOrderBy; /* The ORDER BY clause */
103374 pOrderBy = p->pOrderBy;
103389 eDest = pOrderBy ? SRT_DistQueue : SRT_DistFifo;
103392 eDest = pOrderBy ? SRT_Queue : SRT_Fifo;
103399 if( pOrderBy ){
103401 sqlite3VdbeAddOp4(v, OP_OpenEphemeral, iQueue, pOrderBy->nExpr+2, 0,
103403 destQueue.pOrderBy = pOrderBy;
103414 p->pOrderBy = 0;
103427 if( pOrderBy ){
103428 sqlite3VdbeAddOp3(v, OP_Column, iQueue, pOrderBy->nExpr+1, regCurrent);
103458 sqlite3ExprListDelete(pParse->db, p->pOrderBy);
103459 p->pOrderBy = pOrderBy;
103529 if( pPrior->pOrderBy ){
103577 if( p->pOrderBy ){
103647 assert( p->pOrderBy==0 );
103657 assert( !pPrior->pOrderBy );
103682 /* Query flattening in sqlite3Select() might refill p->pOrderBy.
103683 ** Be sure to delete p->pOrderBy, therefore, to avoid a memory leak. */
103684 sqlite3ExprListDelete(db, p->pOrderBy);
103687 p->pOrderBy = 0;
103735 assert( p->pOrderBy==0 );
104137 ExprList *pOrderBy; /* The ORDER BY clause */
104145 assert( p->pOrderBy!=0 );
104158 assert( pPrior->pOrderBy==0 );
104159 pOrderBy = p->pOrderBy;
104160 assert( pOrderBy );
104161 nOrderBy = pOrderBy->nExpr;
104170 for(j=0, pItem=pOrderBy->a; j<nOrderBy; j++, pItem++){
104179 pOrderBy = sqlite3ExprListAppend(pParse, pOrderBy, pNew);
104180 if( pOrderBy ) pOrderBy->a[nOrderBy++].u.x.iOrderByCol = (u16)i;
104195 for(i=0, pItem=pOrderBy->a; i<nOrderBy; i++, pItem++){
104207 p->pOrderBy = pOrderBy;
104208 pPrior->pOrderBy = sqlite3ExprListDup(pParse->db, pOrderBy, 0);
104236 sqlite3ResolveOrderGroupBy(pParse, p, p->pOrderBy, "ORDER");
104238 sqlite3ResolveOrderGroupBy(pParse, pPrior, pPrior->pOrderBy, "ORDER");
104482 substExprList(db, p->pOrderBy, iTable, pEList);
104679 if( p->pOrderBy && pSub->pOrderBy ){
104682 if( isAgg && pSub->pOrderBy ) return 0; /* Restriction (16) */
104732 if( pSub->pOrderBy ){
104753 if( p->pOrderBy ){
104755 for(ii=0; ii<p->pOrderBy->nExpr; ii++){
104756 if( p->pOrderBy->a[ii].u.x.iOrderByCol==0 ) return 0;
104804 ExprList *pOrderBy = p->pOrderBy;
104808 p->pOrderBy = 0;
104816 p->pOrderBy = pOrderBy;
104954 if( pSub->pOrderBy ){
104955 assert( pParent->pOrderBy==0 );
104956 pParent->pOrderBy = pSub->pOrderBy;
104957 pSub->pOrderBy = 0;
104958 }else if( pParent->pOrderBy ){
104959 substExprList(db, pParent->pOrderBy, iParent, pSub->pEList);
105138 if( p->pOrderBy==0 ) return WRC_Continue;
105141 a = p->pOrderBy->a;
105142 for(i=p->pOrderBy->nExpr-1; i>=0; i--){
105163 pNew->pOrderBy = 0;
106007 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistFifo );
106008 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Fifo );
106009 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistQueue );
106010 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Queue );
106018 sqlite3ExprListDelete(db, p->pOrderBy);
106019 p->pOrderBy = 0;
106024 sSort.pOrderBy = p->pOrderBy;
106146 sSort.pOrderBy = p->pOrderBy;
106182 && sqlite3ExprListCompare(sSort.pOrderBy, p->pEList, -1)==0
106187 sSort.pOrderBy = 0;
106201 if( sSort.pOrderBy ){
106203 pKeyInfo = keyInfoFromExprList(pParse, sSort.pOrderBy, 0, 0);
106207 sSort.iECursor, sSort.pOrderBy->nExpr+2, 0,
106248 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy,
106257 if( sSort.pOrderBy ){
106259 if( sSort.nOBSat==sSort.pOrderBy->nExpr ){
106260 sSort.pOrderBy = 0;
106268 if( sSort.addrSortIndex>=0 && sSort.pOrderBy==0 ){
106323 if( sqlite3ExprListCompare(pGroupBy, sSort.pOrderBy, -1)==0 ){
106342 sqlite3ExprAnalyzeAggList(&sNC, sSort.pOrderBy);
106485 sSort.pOrderBy = 0;
106716 sSort.pOrderBy = 0;
106733 if( sSort.pOrderBy ){
106822 if( p->pOrderBy ){
106824 pOrderBy);
110823 ExprList *pOrderBy; /* ORDER BY clause */
110845 ExprList *pOrderBy; /* The ORDER BY clause or NULL */
111233 mask |= exprListTableUsage(pMaskSet, pS->pOrderBy);
112630 ExprList *pOrderBy
112659 if( pOrderBy ){
112660 int n = pOrderBy->nExpr;
112662 Expr *pExpr = pOrderBy->a[i].pExpr;
112722 Expr *pExpr = pOrderBy->a[i].pExpr;
112724 pIdxOrderBy[i].desc = pOrderBy->a[i].sortOrder;
114072 /* If this loop satisfies a sort order (pOrderBy) request that
114080 assert( pWInfo->pOrderBy==0
114081 || pWInfo->pOrderBy->nExpr==1
115415 if( (pOB = pBuilder->pWInfo->pOrderBy)==0 ) return 0;
115716 pIdxInfo = allocateIndexInfo(pParse, pWC, pSrc, pBuilder->pOrderBy);
115884 sSubBuild.pOrderBy = 0;
116013 ** the pOrderBy terms can be matched in any order. With ORDER BY, the
116014 ** pOrderBy terms must be matched in strict left-to-right order.
116018 ExprList *pOrderBy, /* ORDER BY or GROUP BY or DISTINCT clause to check */
116071 assert( pOrderBy!=0 );
116074 nOrderBy = pOrderBy->nExpr;
116097 pOBExpr = sqlite3ExprSkipCollate(pOrderBy->a[i].pExpr);
116105 pColl = sqlite3ExprCollSeq(pWInfo->pParse, pOrderBy->a[i].pExpr);
116181 pOBExpr = sqlite3ExprSkipCollate(pOrderBy->a[i].pExpr);
116189 pColl = sqlite3ExprCollSeq(pWInfo->pParse, pOrderBy->a[i].pExpr);
116200 if( (rev ^ revIdx)!=pOrderBy->a[i].sortOrder ) isMatch = 0;
116202 rev = revIdx ^ pOrderBy->a[i].sortOrder;
116235 p = pOrderBy->a[i].pExpr;
116258 ** the planner assumes that the specified pOrderBy list is actually a GROUP
116385 if( pWInfo->pOrderBy==0 || nRowEst==0 ){
116388 nOrderBy = pWInfo->pOrderBy->nExpr;
116458 pWInfo->pOrderBy, pFrom, pWInfo->wctrlFlags,
116648 if( pWInfo->pOrderBy ){
116650 if( pFrom->isOrdered==pWInfo->pOrderBy->nExpr ){
116659 && pWInfo->nOBSat==pWInfo->pOrderBy->nExpr
116662 int nOrder = wherePathSatisfiesOrderBy(pWInfo, pWInfo->pOrderBy,
116666 pWInfo->sorted = (nOrder==pWInfo->pOrderBy->nExpr);
116752 if( pWInfo->pOrderBy ) pWInfo->nOBSat = pWInfo->pOrderBy->nExpr;
116839 ** pOrderBy is a pointer to the ORDER BY clause (or the GROUP BY clause
116842 ** is called from an UPDATE or DELETE statement, then pOrderBy is NULL.
116856 ExprList *pOrderBy, /* An ORDER BY (or GROUP BY) clause, or NULL */
116880 testcase( pOrderBy && pOrderBy->nExpr==BMS-1 );
116881 if( pOrderBy && pOrderBy->nExpr>=BMS ) pOrderBy = 0;
116882 sWLB.pOrderBy = pOrderBy;
116924 pWInfo->pOrderBy = pOrderBy;
116960 if( pOrderBy ) pWInfo->nOBSat = pOrderBy->nExpr;
117010 }else if( pOrderBy==0 ){
117013 pWInfo->pOrderBy = pResultSet;
117056 if( pWInfo->pOrderBy ){
117061 if( pWInfo->pOrderBy==0 && (db->flags & SQLITE_ReverseOrder)!=0 ){
117100 if( sWLB.pOrderBy ) tabUsed |= exprListTableUsage(pMaskSet, sWLB.pOrderBy);
