Lines Matching refs:pOrderBy
19444 ExprList *pOrderBy; /* The ORDER BY clause */ member
19603 ExprList *pOrderBy; /* Key columns for SRT_Queue and SRT_DistQueue */ member
20379 ExprList *pOrderBy; /* ORDER BY clause */ member
32568 if( p->pOrderBy ) n++; in sqlite3TreeViewSelect()
32619 if( p->pOrderBy ){ in sqlite3TreeViewSelect()
32620 sqlite3TreeViewExprList(pView, p->pOrderBy, (n--)>0, "ORDERBY"); in sqlite3TreeViewSelect()
32703 if( pWin->pOrderBy ) nElement++; in sqlite3TreeViewWindow()
32714 if( pWin->pOrderBy ){ in sqlite3TreeViewWindow()
32715 sqlite3TreeViewExprList(pView, pWin->pOrderBy, (--nElement)>0, "ORDER-BY"); in sqlite3TreeViewWindow()
33312 const ExprList *pOrderBy, in sqlite3TreeViewDelete() argument
33323 if( pOrderBy ) n++; in sqlite3TreeViewDelete()
33343 if( pOrderBy ){ in sqlite3TreeViewDelete()
33344 sqlite3TreeViewExprList(pView, pOrderBy, (--n)>0, "ORDER-BY"); in sqlite3TreeViewDelete()
33440 const ExprList *pOrderBy, in sqlite3TreeViewUpdate() argument
33461 if( pOrderBy ) n++; in sqlite3TreeViewUpdate()
33485 if( pOrderBy ){ in sqlite3TreeViewUpdate()
33486 sqlite3TreeViewExprList(pView, pOrderBy, (--n)>0, "ORDER-BY"); in sqlite3TreeViewUpdate()
105951 rc = sqlite3WalkExprList(pWalker, pWin->pOrderBy);
106060 if( sqlite3WalkExprList(pWalker, p->pOrderBy) ) return WRC_Abort;
107419 sqlite3WalkExprList(pWalker, pWin->pOrderBy);
107686 ExprList *pOrderBy;
107691 pOrderBy = pSelect->pOrderBy;
107692 if( pOrderBy==0 ) return 0;
107694 if( pOrderBy->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
107698 for(i=0; i<pOrderBy->nExpr; i++){
107699 pOrderBy->a[i].fg.done = 0;
107711 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
107774 for(i=0; i<pOrderBy->nExpr; i++){
107775 if( pOrderBy->a[i].fg.done==0 ){
107797 ExprList *pOrderBy, /* The ORDER BY or GROUP BY clause to be processed */
107805 if( pOrderBy==0 || pParse->db->mallocFailed || IN_RENAME_OBJECT ) return 0;
107806 if( pOrderBy->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
107812 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
107875 ExprList *pOrderBy, /* An ORDER BY or GROUP BY clause to resolve */
107884 assert( pOrderBy!=0 );
107887 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
107929 return sqlite3ResolveOrderGroupBy(pParse, pSelect, pOrderBy, zType);
107994 assert( p->pSrc->nSrc==1 && p->pOrderBy );
107995 assert( pSub->pPrior && pSub->pOrderBy==0 );
107996 pSub->pOrderBy = p->pOrderBy;
107997 p->pOrderBy = 0;
108089 if( sqlite3ResolveExprListNames(&sNC, pWin->pOrderBy)
108111 p->pOrderBy = pSub->pOrderBy;
108112 pSub->pOrderBy = 0;
108125 if( p->pOrderBy!=0
108127 && resolveOrderGroupBy(&sNC, p, p->pOrderBy, "ORDER")
109220 heightOfExprList(p->pOrderBy, pnHeight);
109599 ExprList *pOrderBy /* The ORDER BY clause to add */
109603 if( NEVER(pOrderBy==0) ){
109609 sqlite3ExprListDelete(db, pOrderBy);
109617 sqlite3ParserAddCleanup(pParse, sqlite3ExprListDeleteGeneric, pOrderBy);
109622 sqlite3ExprListDelete(db, pOrderBy);
109628 sqlite3ExprListDelete(db, pOrderBy);
109631 pOB->x.pList = pOrderBy;
110321 pNew->pOrderBy = sqlite3ExprListDup(db, p->pOrderBy, flags);
127011 ExprList *pOrderBy, /* Optional ORDER BY clause */
127029 pSel = sqlite3SelectNew(pParse, 0, pFrom, pWhere, 0, 0, pOrderBy,
127050 ExprList *pOrderBy, /* The ORDER BY clause. May be null */
127064 if( pOrderBy && pLimit==0 ) {
127067 sqlite3ExprListDelete(pParse->db, pOrderBy);
127134 pOrderBy,0,pLimit
127156 ExprList *pOrderBy, /* ORDER BY clause. May be null */
127232 pOrderBy, pLimit, pTrigger);
127239 pParse, pTabList, pWhere, pOrderBy, pLimit, "DELETE"
127241 pOrderBy = 0;
127294 pWhere, pOrderBy, pLimit, iTabCur
127297 pOrderBy = 0;
127552 sqlite3ExprListDelete(db, pOrderBy);
134976 if( pSelect->pOrderBy ){
141834 ExprList *pOrderBy; /* The ORDER BY (or GROUP BY clause) */
141875 sqlite3ExprListDelete(db, p->pOrderBy);
141917 ExprList *pOrderBy, /* the ORDER BY clause */
141946 pNew->pOrderBy = pOrderBy;
142490 int nExpr = pSort->pOrderBy->nExpr; /* No. of ORDER BY terms */
142530 sqlite3ExprCodeExprList(pParse, pSort->pOrderBy, regBase, regOrigData,
142564 pOp->p4.pKeyInfo = sqlite3KeyInfoFromExprList(pParse,pSort->pOrderBy,nOBSat,
142918 if( pSort && pSort->pOrderBy==0 ) pSort = 0;
142930 nPrefixReg = pSort->pOrderBy->nExpr;
142974 for(i=pSort->nOBSat; i<pSort->pOrderBy->nExpr; i++){
142976 if( (j = pSort->pOrderBy->a[i].u.x.iOrderByCol)>0 ){
143230 pSO = pDest->pOrderBy;
143444 ExprList *pOrderBy = pSort->pOrderBy;
143500 nKey = pOrderBy->nExpr - pSort->nOBSat;
144336 ExprList *pOrderBy = p->pOrderBy;
144337 int nOrderBy = ALWAYS(pOrderBy!=0) ? pOrderBy->nExpr : 0;
144343 struct ExprList_item *pItem = &pOrderBy->a[i];
144352 pOrderBy->a[i].pExpr =
144357 pRet->aSortFlags[i] = pOrderBy->a[i].fg.sortFlags;
144421 ExprList *pOrderBy; /* The ORDER BY clause */
144444 pOrderBy = p->pOrderBy;
144459 eDest = pOrderBy ? SRT_DistQueue : SRT_DistFifo;
144462 eDest = pOrderBy ? SRT_Queue : SRT_Fifo;
144469 if( pOrderBy ){
144471 sqlite3VdbeAddOp4(v, OP_OpenEphemeral, iQueue, pOrderBy->nExpr+2, 0,
144473 destQueue.pOrderBy = pOrderBy;
144484 p->pOrderBy = 0;
144515 if( pOrderBy ){
144516 sqlite3VdbeAddOp3(v, OP_Column, iQueue, pOrderBy->nExpr+1, regCurrent);
144547 sqlite3ExprListDelete(pParse->db, p->pOrderBy);
144548 p->pOrderBy = pOrderBy;
144671 assert( pPrior->pOrderBy==0 );
144707 if( p->pOrderBy ){
144786 assert( p->pOrderBy==0 );
144797 assert( !pPrior->pOrderBy );
144822 assert( p->pOrderBy==0 );
144825 p->pOrderBy = 0;
144869 assert( p->pOrderBy==0 );
145280 ExprList *pOrderBy; /* The ORDER BY clause */
145284 assert( p->pOrderBy!=0 );
145296 assert( p->pPrior->pOrderBy==0 );
145297 pOrderBy = p->pOrderBy;
145298 assert( pOrderBy );
145299 nOrderBy = pOrderBy->nExpr;
145308 for(j=0, pItem=pOrderBy->a; j<nOrderBy; j++, pItem++){
145318 p->pOrderBy = pOrderBy = sqlite3ExprListAppend(pParse, pOrderBy, pNew);
145319 if( pOrderBy ) pOrderBy->a[nOrderBy++].u.x.iOrderByCol = (u16)i;
145335 for(i=1, pItem=pOrderBy->a; i<=nOrderBy; i++, pItem++){
145389 assert( p->pOrderBy == pOrderBy );
145390 assert( pOrderBy!=0 || db->mallocFailed );
145391 pPrior->pOrderBy = sqlite3ExprListDup(pParse->db, pOrderBy, 0);
145392 sqlite3ResolveOrderGroupBy(pParse, p, p->pOrderBy, "ORDER");
145393 sqlite3ResolveOrderGroupBy(pParse, pPrior, pPrior->pOrderBy, "ORDER");
145549 sqlite3ExprListDelete(db, pPrior->pOrderBy);
145550 pPrior->pOrderBy = 0;
145719 substExprList(pSubst, pWin->pOrderBy);
145747 substExprList(pSubst, p->pOrderBy);
146160 if( p->pOrderBy && pSub->pOrderBy ){
146163 if( isAgg && pSub->pOrderBy ) return 0; /* Restriction (16) */
146213 if( pSub->pOrderBy ){
146244 if( p->pOrderBy ){
146245 for(ii=0; ii<p->pOrderBy->nExpr; ii++){
146246 if( p->pOrderBy->a[ii].u.x.iOrderByCol==0 ) return 0;
146320 ExprList *pOrderBy = p->pOrderBy;
146325 p->pOrderBy = 0;
146330 p->pOrderBy = pOrderBy;
146449 if( pSub->pOrderBy && (pParent->selFlags & SF_NoopOrderBy)==0 ){
146460 ExprList *pOrderBy = pSub->pOrderBy;
146461 for(i=0; i<pOrderBy->nExpr; i++){
146462 pOrderBy->a[i].u.x.iOrderByCol = 0;
146464 assert( pParent->pOrderBy==0 );
146465 pParent->pOrderBy = pOrderBy;
146466 pSub->pOrderBy = 0;
147108 if( pSub->pOrderBy ){
147109 ExprList *pList = pSub->pOrderBy;
147155 ExprList *pOrderBy;
147183 *ppMinMax = pOrderBy = sqlite3ExprListDup(db, pEList, 0);
147184 assert( pOrderBy!=0 || db->mallocFailed );
147185 if( pOrderBy ) pOrderBy->a[0].fg.sortFlags = sortFlags;
147298 if( p->pOrderBy==0 ) return WRC_Continue;
147301 a = p->pOrderBy->a;
147310 for(i=p->pOrderBy->nExpr-1; i>=0; i--){
147331 pNew->pOrderBy = 0;
148883 if( p->pOrderBy ) return 0;
149086 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistFifo );
149087 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Fifo );
149088 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistQueue );
149089 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Queue );
149095 if( p->pOrderBy ){
149099 sqlite3TreeViewExprList(0, p->pOrderBy, 0, "ORDERBY");
149103 p->pOrderBy);
149105 p->pOrderBy = 0;
149168 sSort.pOrderBy = p->pOrderBy;
149286 if( pSub->pOrderBy!=0
149287 && (p->pOrderBy!=0 || pTabList->nSrc>1) /* Condition (5) */
149296 pSub->pOrderBy);
149297 pSub->pOrderBy = 0;
149318 if( pSub->pOrderBy!=0
149335 sSort.pOrderBy = p->pOrderBy;
149594 && sqlite3ExprListCompare(sSort.pOrderBy, pEList, -1)==0
149624 if( sSort.pOrderBy ){
149627 pParse, sSort.pOrderBy, 0, pEList->nExpr);
149631 sSort.iECursor, sSort.pOrderBy->nExpr+1+pEList->nExpr, 0,
149697 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy,
149706 if( sSort.pOrderBy ){
149709 if( sSort.nOBSat==sSort.pOrderBy->nExpr ){
149710 sSort.pOrderBy = 0;
149719 if( sSort.addrSortIndex>=0 && sSort.pOrderBy==0 ){
149795 if( sSort.pOrderBy && pGroupBy->nExpr==sSort.pOrderBy->nExpr ){
149804 sortFlags = sSort.pOrderBy->a[ii].fg.sortFlags & KEYINFO_ORDER_DESC;
149807 if( sqlite3ExprListCompare(pGroupBy, sSort.pOrderBy, -1)==0 ){
149843 sqlite3ExprAnalyzeAggList(&sNC, sSort.pOrderBy);
150048 sSort.pOrderBy = 0;
150295 sSort.pOrderBy = 0;
150311 if( sSort.pOrderBy ){
152247 ExprList *pOrderBy, /* ORDER BY clause */
152264 if( pOrderBy && pLimit==0 ) {
152268 pOrderBy2 = sqlite3ExprListDup(db, pOrderBy, 0);
152271 UNUSED_PARAMETER(pOrderBy);
152344 ExprList *pOrderBy, /* ORDER BY clause. May be null */
152440 onError, pOrderBy, pLimit, pUpsert, pTrigger);
152454 pParse, pTabList, pWhere, pOrderBy, pLimit, "UPDATE"
152456 pOrderBy = 0;
152691 pWhere, pOrderBy, pLimit, iDataCur
152693 pOrderBy = 0;
152754 pParse, iEph, pPk, pChanges, pTabList, pWhere, pOrderBy, pLimit
153215 sqlite3ExprListDelete(db, pOrderBy);
155999 ExprList *pOrderBy; /* The ORDER BY clause or NULL */
156703 if( pSelect->pOrderBy ){
156711 ExprList *pOrderBy = pSelect->pOrderBy;
156712 for(i=0; i<pOrderBy->nExpr; i++){
156713 pOrderBy->a[i].u.x.iOrderByCol = 0;
159889 mask |= sqlite3WhereExprListUsage(pMaskSet, pS->pOrderBy);
160567 ExprList *pOrderBy = p->pOrderBy;
160591 if( pOrderBy ){
160592 for(ii=0; ii<pOrderBy->nExpr; ii++){
160593 Expr *pExpr = pOrderBy->a[ii].pExpr;
160596 if( pOrderBy->a[ii].fg.sortFlags & KEYINFO_ORDER_BIGNULL ) return;
160717 mask |= sqlite3WhereExprListUsage(pMaskSet, p->y.pWin->pOrderBy);
162105 ExprList *pOrderBy = pWInfo->pOrderBy;
162145 if( pOrderBy ){
162146 int n = pOrderBy->nExpr;
162148 Expr *pExpr = pOrderBy->a[i].pExpr;
162157 if( pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_BIGNULL ) break;
162263 Expr *pExpr = pOrderBy->a[i].pExpr;
162269 pIdxOrderBy[j].desc = pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_DESC;
164181 if( (pOB = pBuilder->pWInfo->pOrderBy)==0 ) return 0;
165511 ExprList *pOrderBy, /* ORDER BY or GROUP BY or DISTINCT clause to check */
165565 assert( pOrderBy!=0 );
165568 nOrderBy = pOrderBy->nExpr;
165606 pOBExpr = sqlite3ExprSkipCollateAndLikely(pOrderBy->a[i].pExpr);
165624 CollSeq *pColl1 = sqlite3ExprNNCollSeq(pParse, pOrderBy->a[i].pExpr);
165739 pOBExpr = sqlite3ExprSkipCollateAndLikely(pOrderBy->a[i].pExpr);
165755 pColl = sqlite3ExprNNCollSeq(pWInfo->pParse, pOrderBy->a[i].pExpr);
165769 != (pOrderBy->a[i].fg.sortFlags&KEYINFO_ORDER_DESC)
165774 rev = revIdx ^ (pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_DESC);
165779 if( isMatch && (pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_BIGNULL) ){
165814 p = pOrderBy->a[i].pExpr;
165989 if( pWInfo->pOrderBy==0 || nRowEst==0 ){
165992 nOrderBy = pWInfo->pOrderBy->nExpr;
166073 pWInfo->pOrderBy, pFrom, pWInfo->wctrlFlags,
166279 if( pWInfo->pOrderBy ){
166282 if( pFrom->isOrdered==pWInfo->pOrderBy->nExpr ){
166285 if( pWInfo->pSelect->pOrderBy
166286 && pWInfo->nOBSat > pWInfo->pSelect->pOrderBy->nExpr ){
166287 pWInfo->nOBSat = pWInfo->pSelect->pOrderBy->nExpr;
166299 int rc = wherePathSatisfiesOrderBy(pWInfo, pWInfo->pOrderBy, pFrom,
166303 if( rc==pWInfo->pOrderBy->nExpr ){
166317 && pWInfo->nOBSat==pWInfo->pOrderBy->nExpr && nLoop>0
166320 int nOrder = wherePathSatisfiesOrderBy(pWInfo, pWInfo->pOrderBy,
166324 if( nOrder==pWInfo->pOrderBy->nExpr ){
166424 if( pWInfo->pOrderBy ) pWInfo->nOBSat = pWInfo->pOrderBy->nExpr;
166544 if( pWInfo->pOrderBy ){
166545 tabUsed |= sqlite3WhereExprListUsage(&pWInfo->sMaskSet, pWInfo->pOrderBy);
166744 || pItem->pSelect->pOrderBy==0
166843 ExprList *pOrderBy, /* An ORDER BY (or GROUP BY) clause, or NULL */
166878 testcase( pOrderBy && pOrderBy->nExpr==BMS-1 );
166879 if( pOrderBy && pOrderBy->nExpr>=BMS ){
166880 pOrderBy = 0;
166919 pWInfo->pOrderBy = pOrderBy;
166958 if( pOrderBy ) pWInfo->nOBSat = pOrderBy->nExpr;
167056 }else if( pOrderBy==0 ){
167059 pWInfo->pOrderBy = pResultSet;
167077 sSelect.pOrderBy = pOrderBy;
167116 if( pWInfo->pOrderBy ){
167132 if( pWInfo->pOrderBy==0 && (db->flags & SQLITE_ReverseOrder)!=0 ){
168522 pWin->pOrderBy = sqlite3ExprListDup(pParse->db, p->pOrderBy, 0);
168534 && (pWin->pOrderBy==0 || pWin->pOrderBy->nExpr!=1)
168844 sqlite3WalkExprList(&w, p->pOrderBy);
168858 pSort = exprListAppendList(pParse, pSort, pMWin->pOrderBy, 1);
168859 if( pSort && p->pOrderBy && p->pOrderBy->nExpr<=pSort->nExpr ){
168861 pSort->nExpr = p->pOrderBy->nExpr;
168862 if( sqlite3ExprListCompare(pSort, p->pOrderBy, -1)==0 ){
168863 sqlite3ExprListDelete(db, p->pOrderBy);
168864 p->pOrderBy = 0;
168876 selectWindowRewriteEList(pParse, pMWin, pSrc, p->pOrderBy, pTab, &pSublist);
168883 pSublist = exprListAppendList(pParse, pSublist, pMWin->pOrderBy, 0);
168992 sqlite3ExprListDelete(db, p->pOrderBy);
169107 ExprList *pOrderBy,
169112 pWin->pOrderBy = pOrderBy;
169118 sqlite3ExprListDelete(pParse->db, pOrderBy);
169139 }else if( pExist->pOrderBy && pWin->pOrderBy ){
169150 if( pExist->pOrderBy ){
169151 assert( pWin->pOrderBy==0 );
169152 pWin->pOrderBy = sqlite3ExprListDup(db, pExist->pOrderBy, 0);
169227 if( (res = sqlite3ExprListCompare(p1->pOrderBy, p2->pOrderBy, -1)) ){
169476 ExprList *pOrderBy = pMWin->pOrderBy;
169477 if( pOrderBy ){
169482 for(i=0; i<pOrderBy->nExpr; i++){
169684 nPeer = (pMWin->pOrderBy ? pMWin->pOrderBy->nExpr : 0);
169718 if( pMWin->pOrderBy ){
169719 pKeyInfo = sqlite3KeyInfoFromExprList(pParse, pMWin->pOrderBy, 0, 0);
169906 ExprList *pOrderBy,
169912 if( pOrderBy ){
169913 int nVal = pOrderBy->nExpr;
169914 KeyInfo *pKeyInfo = sqlite3KeyInfoFromExprList(pParse, pOrderBy, 0, 0);
169960 ExprList *pOrderBy = p->pMWin->pOrderBy; /* ORDER BY clause for window */
169974 assert( pOrderBy && pOrderBy->nExpr==1 );
169975 if( pOrderBy->a[0].fg.sortFlags & KEYINFO_ORDER_DESC ){
170008 if( pOrderBy->a[0].fg.sortFlags & KEYINFO_ORDER_BIGNULL ){
170060 pColl = sqlite3ExprNNCollSeq(pParse, pOrderBy->a[0].pExpr);
170211 int nReg = (pMWin->pOrderBy ? pMWin->pOrderBy->nExpr : 0);
170214 windowIfNewPeer(pParse, pMWin->pOrderBy, regTmp, reg, addrContinue);
170241 pNew->pOrderBy = sqlite3ExprListDup(db, p->pOrderBy, 0);
170641 ExprList *pOrderBy = pMWin->pOrderBy;
170740 int nPeer = (pOrderBy ? pOrderBy->nExpr : 0);
170819 if( regPeer && pOrderBy ){
170820 sqlite3VdbeAddOp3(v, OP_Copy, regNewPeer, regPeer, pOrderBy->nExpr-1);
170821 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.start.reg, pOrderBy->nExpr-1);
170822 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.current.reg, pOrderBy->nExpr-1);
170823 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.end.reg, pOrderBy->nExpr-1);
170832 windowIfNewPeer(pParse, pOrderBy, regNewPeer, regPeer, lblWhereEnd);
171052 ExprList *pOrderBy,
171055 if( pOrderBy ){
171060 sqlite3ExprListDelete(pParse->db, pOrderBy);
171083 if( pLoop->pOrderBy || pLoop->pLimit ){
171085 pLoop->pOrderBy!=0 ? "ORDER BY" : "LIMIT",