Lines Matching refs:pOrderBy
19969 ExprList *pOrderBy; /* The ORDER BY clause */ member
20135 ExprList *pOrderBy; /* Key columns for SRT_Queue and SRT_DistQueue */ member
20929 ExprList *pOrderBy; /* ORDER BY clause */ member
33451 if( p->pOrderBy ) n++; in sqlite3TreeViewSelect()
33502 if( p->pOrderBy ){ in sqlite3TreeViewSelect()
33503 sqlite3TreeViewExprList(pView, p->pOrderBy, (n--)>0, "ORDERBY"); in sqlite3TreeViewSelect()
33586 if( pWin->pOrderBy ) nElement++; in sqlite3TreeViewWindow()
33597 if( pWin->pOrderBy ){ in sqlite3TreeViewWindow()
33598 sqlite3TreeViewExprList(pView, pWin->pOrderBy, (--nElement)>0, "ORDER-BY"); in sqlite3TreeViewWindow()
34188 const ExprList *pOrderBy, in sqlite3TreeViewDelete() argument
34199 if( pOrderBy ) n++; in sqlite3TreeViewDelete()
34219 if( pOrderBy ){ in sqlite3TreeViewDelete()
34220 sqlite3TreeViewExprList(pView, pOrderBy, (--n)>0, "ORDER-BY"); in sqlite3TreeViewDelete()
34316 const ExprList *pOrderBy, in sqlite3TreeViewUpdate() argument
34337 if( pOrderBy ) n++; in sqlite3TreeViewUpdate()
34361 if( pOrderBy ){ in sqlite3TreeViewUpdate()
34362 sqlite3TreeViewExprList(pView, pOrderBy, (--n)>0, "ORDER-BY"); in sqlite3TreeViewUpdate()
107799 rc = sqlite3WalkExprList(pWalker, pWin->pOrderBy);
107908 if( sqlite3WalkExprList(pWalker, p->pOrderBy) ) return WRC_Abort;
109353 sqlite3WalkExprList(pWalker, pWin->pOrderBy);
109622 ExprList *pOrderBy;
109627 pOrderBy = pSelect->pOrderBy;
109628 if( pOrderBy==0 ) return 0;
109630 if( pOrderBy->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
109634 for(i=0; i<pOrderBy->nExpr; i++){
109635 pOrderBy->a[i].fg.done = 0;
109647 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
109710 for(i=0; i<pOrderBy->nExpr; i++){
109711 if( pOrderBy->a[i].fg.done==0 ){
109733 ExprList *pOrderBy, /* The ORDER BY or GROUP BY clause to be processed */
109741 if( pOrderBy==0 || pParse->db->mallocFailed || IN_RENAME_OBJECT ) return 0;
109742 if( pOrderBy->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
109748 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
109811 ExprList *pOrderBy, /* An ORDER BY or GROUP BY clause to resolve */
109820 assert( pOrderBy!=0 );
109823 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
109865 return sqlite3ResolveOrderGroupBy(pParse, pSelect, pOrderBy, zType);
109934 assert( p->pSrc->nSrc==1 && p->pOrderBy );
109935 assert( pSub->pPrior && pSub->pOrderBy==0 );
109936 pSub->pOrderBy = p->pOrderBy;
109937 p->pOrderBy = 0;
110035 if( sqlite3ResolveExprListNames(&sNC, pWin->pOrderBy)
110060 p->pOrderBy = pSub->pOrderBy;
110061 pSub->pOrderBy = 0;
110074 if( p->pOrderBy!=0
110076 && resolveOrderGroupBy(&sNC, p, p->pOrderBy, "ORDER")
111181 heightOfExprList(p->pOrderBy, pnHeight);
111561 ExprList *pOrderBy /* The ORDER BY clause to add */
111565 if( NEVER(pOrderBy==0) ){
111571 sqlite3ExprListDelete(db, pOrderBy);
111579 sqlite3ParserAddCleanup(pParse, sqlite3ExprListDeleteGeneric, pOrderBy);
111584 sqlite3ExprListDelete(db, pOrderBy);
111590 sqlite3ExprListDelete(db, pOrderBy);
111593 pOB->x.pList = pOrderBy;
112306 pNew->pOrderBy = sqlite3ExprListDup(db, p->pOrderBy, flags);
129492 ExprList *pOrderBy, /* Optional ORDER BY clause */
129511 pSel = sqlite3SelectNew(pParse, 0, pFrom, pWhere, 0, 0, pOrderBy,
129532 ExprList *pOrderBy, /* The ORDER BY clause. May be null */
129546 if( pOrderBy && pLimit==0 ) {
129549 sqlite3ExprListDelete(pParse->db, pOrderBy);
129616 pOrderBy,0,pLimit
129638 ExprList *pOrderBy, /* ORDER BY clause. May be null */
129714 pOrderBy, pLimit, pTrigger);
129721 pParse, pTabList, pWhere, pOrderBy, pLimit, "DELETE"
129723 pOrderBy = 0;
129776 pWhere, pOrderBy, pLimit, iTabCur
129779 pOrderBy = 0;
130034 sqlite3ExprListDelete(db, pOrderBy);
137872 if( pSelect->pOrderBy ){
144889 ExprList *pOrderBy; /* The ORDER BY (or GROUP BY clause) */
144930 sqlite3ExprListDelete(db, p->pOrderBy);
144972 ExprList *pOrderBy, /* the ORDER BY clause */
145001 pNew->pOrderBy = pOrderBy;
145578 int nExpr = pSort->pOrderBy->nExpr; /* No. of ORDER BY terms */
145618 sqlite3ExprCodeExprList(pParse, pSort->pOrderBy, regBase, regOrigData,
145652 pOp->p4.pKeyInfo = sqlite3KeyInfoFromExprList(pParse,pSort->pOrderBy,nOBSat,
146006 if( pSort && pSort->pOrderBy==0 ) pSort = 0;
146018 nPrefixReg = pSort->pOrderBy->nExpr;
146062 for(i=pSort->nOBSat; i<pSort->pOrderBy->nExpr; i++){
146064 if( (j = pSort->pOrderBy->a[i].u.x.iOrderByCol)>0 ){
146324 pSO = pDest->pOrderBy;
146538 ExprList *pOrderBy = pSort->pOrderBy;
146554 nKey = pOrderBy->nExpr - pSort->nOBSat;
147440 ExprList *pOrderBy = p->pOrderBy;
147441 int nOrderBy = ALWAYS(pOrderBy!=0) ? pOrderBy->nExpr : 0;
147447 struct ExprList_item *pItem = &pOrderBy->a[i];
147456 pOrderBy->a[i].pExpr =
147461 pRet->aSortFlags[i] = pOrderBy->a[i].fg.sortFlags;
147525 ExprList *pOrderBy; /* The ORDER BY clause */
147548 pOrderBy = p->pOrderBy;
147563 eDest = pOrderBy ? SRT_DistQueue : SRT_DistFifo;
147566 eDest = pOrderBy ? SRT_Queue : SRT_Fifo;
147573 if( pOrderBy ){
147575 sqlite3VdbeAddOp4(v, OP_OpenEphemeral, iQueue, pOrderBy->nExpr+2, 0,
147577 destQueue.pOrderBy = pOrderBy;
147588 p->pOrderBy = 0;
147619 if( pOrderBy ){
147620 sqlite3VdbeAddOp3(v, OP_Column, iQueue, pOrderBy->nExpr+1, regCurrent);
147651 sqlite3ExprListDelete(pParse->db, p->pOrderBy);
147652 p->pOrderBy = pOrderBy;
147775 assert( pPrior->pOrderBy==0 );
147811 if( p->pOrderBy ){
147890 assert( p->pOrderBy==0 );
147901 assert( !pPrior->pOrderBy );
147926 assert( p->pOrderBy==0 );
147929 p->pOrderBy = 0;
147973 assert( p->pOrderBy==0 );
148390 ExprList *pOrderBy; /* The ORDER BY clause */
148394 assert( p->pOrderBy!=0 );
148406 assert( p->pPrior->pOrderBy==0 );
148407 pOrderBy = p->pOrderBy;
148408 assert( pOrderBy );
148409 nOrderBy = pOrderBy->nExpr;
148418 for(j=0, pItem=pOrderBy->a; j<nOrderBy; j++, pItem++){
148428 p->pOrderBy = pOrderBy = sqlite3ExprListAppend(pParse, pOrderBy, pNew);
148429 if( pOrderBy ) pOrderBy->a[nOrderBy++].u.x.iOrderByCol = (u16)i;
148445 for(i=1, pItem=pOrderBy->a; i<=nOrderBy; i++, pItem++){
148499 assert( p->pOrderBy == pOrderBy );
148500 assert( pOrderBy!=0 || db->mallocFailed );
148501 pPrior->pOrderBy = sqlite3ExprListDup(pParse->db, pOrderBy, 0);
148502 sqlite3ResolveOrderGroupBy(pParse, p, p->pOrderBy, "ORDER");
148503 sqlite3ResolveOrderGroupBy(pParse, pPrior, pPrior->pOrderBy, "ORDER");
148659 sqlite3ExprListDelete(db, pPrior->pOrderBy);
148660 pPrior->pOrderBy = 0;
148829 substExprList(pSubst, pWin->pOrderBy);
148857 substExprList(pSubst, p->pOrderBy);
149275 if( p->pOrderBy && pSub->pOrderBy ){
149278 if( isAgg && pSub->pOrderBy ) return 0; /* Restriction (16) */
149328 if( pSub->pOrderBy ){
149359 if( p->pOrderBy ){
149360 for(ii=0; ii<p->pOrderBy->nExpr; ii++){
149361 if( p->pOrderBy->a[ii].u.x.iOrderByCol==0 ) return 0;
149439 ExprList *pOrderBy = p->pOrderBy;
149444 p->pOrderBy = 0;
149449 p->pOrderBy = pOrderBy;
149574 if( pSub->pOrderBy && (pParent->selFlags & SF_NoopOrderBy)==0 ){
149585 ExprList *pOrderBy = pSub->pOrderBy;
149586 for(i=0; i<pOrderBy->nExpr; i++){
149587 pOrderBy->a[i].u.x.iOrderByCol = 0;
149589 assert( pParent->pOrderBy==0 );
149590 pParent->pOrderBy = pOrderBy;
149591 pSub->pOrderBy = 0;
150265 if( pSub->pOrderBy ){
150266 ExprList *pList = pSub->pOrderBy;
150312 ExprList *pOrderBy;
150340 *ppMinMax = pOrderBy = sqlite3ExprListDup(db, pEList, 0);
150341 assert( pOrderBy!=0 || db->mallocFailed );
150342 if( pOrderBy ) pOrderBy->a[0].fg.sortFlags = sortFlags;
150455 if( p->pOrderBy==0 ) return WRC_Continue;
150458 a = p->pOrderBy->a;
150467 for(i=p->pOrderBy->nExpr-1; i>=0; i--){
150492 pNew->pOrderBy = 0;
152069 if( p->pOrderBy ) return 0;
152311 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistFifo );
152312 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Fifo );
152313 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistQueue );
152314 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Queue );
152320 if( p->pOrderBy ){
152324 sqlite3TreeViewExprList(0, p->pOrderBy, 0, "ORDERBY");
152328 p->pOrderBy);
152330 p->pOrderBy = 0;
152393 sSort.pOrderBy = p->pOrderBy;
152517 if( pSub->pOrderBy!=0
152518 && (p->pOrderBy!=0 || pTabList->nSrc>1) /* Condition (5) */
152527 pSub->pOrderBy);
152528 pSub->pOrderBy = 0;
152549 if( pSub->pOrderBy!=0
152567 sSort.pOrderBy = p->pOrderBy;
152854 && sqlite3ExprListCompare(sSort.pOrderBy, pEList, -1)==0
152890 if( sSort.pOrderBy ){
152893 pParse, sSort.pOrderBy, 0, pEList->nExpr);
152897 sSort.iECursor, sSort.pOrderBy->nExpr+1+pEList->nExpr, 0,
152964 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy,
152979 if( sSort.pOrderBy ){
152982 if( sSort.nOBSat==sSort.pOrderBy->nExpr ){
152983 sSort.pOrderBy = 0;
152992 if( sSort.addrSortIndex>=0 && sSort.pOrderBy==0 ){
153068 if( sSort.pOrderBy && pGroupBy->nExpr==sSort.pOrderBy->nExpr ){
153077 sortFlags = sSort.pOrderBy->a[ii].fg.sortFlags & KEYINFO_ORDER_DESC;
153080 if( sqlite3ExprListCompare(pGroupBy, sSort.pOrderBy, -1)==0 ){
153116 sqlite3ExprAnalyzeAggList(&sNC, sSort.pOrderBy);
153322 sSort.pOrderBy = 0;
153591 sSort.pOrderBy = 0;
153607 if( sSort.pOrderBy ){
155629 ExprList *pOrderBy, /* ORDER BY clause */
155646 if( pOrderBy && pLimit==0 ) {
155650 pOrderBy2 = sqlite3ExprListDup(db, pOrderBy, 0);
155653 UNUSED_PARAMETER(pOrderBy);
155726 ExprList *pOrderBy, /* ORDER BY clause. May be null */
155822 onError, pOrderBy, pLimit, pUpsert, pTrigger);
155836 pParse, pTabList, pWhere, pOrderBy, pLimit, "UPDATE"
155838 pOrderBy = 0;
156067 pWhere, pOrderBy, pLimit, iDataCur
156069 pOrderBy = 0;
156130 pParse, iEph, pPk, pChanges, pTabList, pWhere, pOrderBy, pLimit
156594 sqlite3ExprListDelete(db, pOrderBy);
159101 ExprList *pOrderBy; /* ORDER BY clause if this is really a subquery */
159426 ExprList *pOrderBy; /* The ORDER BY clause or NULL */
160124 static void adjustOrderByCol(ExprList *pOrderBy, ExprList *pEList){
160126 if( pOrderBy==0 ) return;
160127 for(i=0; i<pOrderBy->nExpr; i++){
160128 int t = pOrderBy->a[i].u.x.iOrderByCol;
160132 pOrderBy->a[i].u.x.iOrderByCol = j+1;
160137 pOrderBy->a[i].u.x.iOrderByCol = 0;
160238 adjustOrderByCol(pSelect->pOrderBy, pRhs);
163526 mask |= sqlite3WhereExprListUsage(pMaskSet, pS->pOrderBy);
164212 ExprList *pOrderBy = p->pOrderBy;
164237 if( pOrderBy ){
164238 for(ii=0; ii<pOrderBy->nExpr; ii++){
164239 Expr *pExpr = pOrderBy->a[ii].pExpr;
164242 if( pOrderBy->a[ii].fg.sortFlags & KEYINFO_ORDER_BIGNULL ) return;
164365 mask |= sqlite3WhereExprListUsage(pMaskSet, p->y.pWin->pOrderBy);
165896 ExprList *pOrderBy = pWInfo->pOrderBy;
165939 if( pOrderBy ){
165940 int n = pOrderBy->nExpr;
165942 Expr *pExpr = pOrderBy->a[i].pExpr;
165951 if( pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_BIGNULL ) break;
166073 Expr *pExpr = pOrderBy->a[i].pExpr;
166079 pIdxOrderBy[j].desc = pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_DESC;
168039 if( (pOB = pBuilder->pWInfo->pOrderBy)==0 ) return 0;
168509 pNew->u.btree.pOrderBy = 0;
168541 pNew->u.btree.pOrderBy = pSrc->u4.pSubq->pSelect->pOrderBy;
169421 ExprList *pOrderBy, /* The ORDER BY clause on the whole query */
169432 pSubOB = pLoop->u.btree.pOrderBy;
169435 for(jSub=0; jSub<pSubOB->nExpr && iOB<pOrderBy->nExpr; jSub++, iOB++){
169437 pOBExpr = pOrderBy->a[iOB].pExpr;
169442 u8 sfOB = pOrderBy->a[iOB].fg.sortFlags; /* sortFlags for iOB */
169487 ExprList *pOrderBy, /* ORDER BY or GROUP BY or DISTINCT clause to check */
169541 assert( pOrderBy!=0 );
169544 nOrderBy = pOrderBy->nExpr;
169580 pOBExpr = sqlite3ExprSkipCollateAndLikely(pOrderBy->a[i].pExpr);
169598 CollSeq *pColl1 = sqlite3ExprNNCollSeq(pParse, pOrderBy->a[i].pExpr);
169611 if( pLoop->u.btree.pOrderBy
169614 pOrderBy,pRevMask, &obSat)
169722 pOBExpr = sqlite3ExprSkipCollateAndLikely(pOrderBy->a[i].pExpr);
169738 pColl = sqlite3ExprNNCollSeq(pWInfo->pParse, pOrderBy->a[i].pExpr);
169752 != (pOrderBy->a[i].fg.sortFlags&KEYINFO_ORDER_DESC)
169757 rev = revIdx ^ (pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_DESC);
169762 if( isMatch && (pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_BIGNULL) ){
169797 p = pOrderBy->a[i].pExpr;
170196 if( pWInfo->pOrderBy==0 || nRowEst==0 ){
170199 nOrderBy = pWInfo->pOrderBy->nExpr;
170283 pWInfo->pOrderBy, pFrom, pWInfo->wctrlFlags,
170504 if( pWInfo->pOrderBy ){
170507 if( pFrom->isOrdered==pWInfo->pOrderBy->nExpr ){
170511 assert( pWInfo->pSelect->pOrderBy==0
170512 || pWInfo->nOBSat <= pWInfo->pSelect->pOrderBy->nExpr );
170523 int rc = wherePathSatisfiesOrderBy(pWInfo, pWInfo->pOrderBy, pFrom,
170527 if( rc==pWInfo->pOrderBy->nExpr ){
170541 && pWInfo->nOBSat==pWInfo->pOrderBy->nExpr && nLoop>0
170544 int nOrder = wherePathSatisfiesOrderBy(pWInfo, pWInfo->pOrderBy,
170548 if( nOrder==pWInfo->pOrderBy->nExpr ){
170727 if( pWInfo->pOrderBy ) pWInfo->nOBSat = pWInfo->pOrderBy->nExpr;
170851 if( pWInfo->pOrderBy ){
170852 tabUsed |= sqlite3WhereExprListUsage(&pWInfo->sMaskSet, pWInfo->pOrderBy);
171035 || pItem->u4.pSubq->pSelect->pOrderBy==0
171134 ExprList *pOrderBy, /* An ORDER BY (or GROUP BY) clause, or NULL */
171169 testcase( pOrderBy && pOrderBy->nExpr==BMS-1 );
171170 if( pOrderBy && pOrderBy->nExpr>=BMS ){
171171 pOrderBy = 0;
171208 pWInfo->pOrderBy = pOrderBy;
171247 if( pOrderBy ) pWInfo->nOBSat = pOrderBy->nExpr;
171349 }else if( pOrderBy==0 ){
171352 pWInfo->pOrderBy = pResultSet;
171370 sSelect.pOrderBy = pOrderBy;
171409 if( pWInfo->pOrderBy ){
171427 if( pWInfo->pOrderBy==0 && (db->flags & SQLITE_ReverseOrder)!=0 ){
172823 pWin->pOrderBy = sqlite3ExprListDup(pParse->db, p->pOrderBy, 0);
172835 && (pWin->pOrderBy==0 || pWin->pOrderBy->nExpr!=1)
173145 sqlite3WalkExprList(&w, p->pOrderBy);
173159 pSort = exprListAppendList(pParse, pSort, pMWin->pOrderBy, 1);
173160 if( pSort && p->pOrderBy && p->pOrderBy->nExpr<=pSort->nExpr ){
173162 pSort->nExpr = p->pOrderBy->nExpr;
173163 if( sqlite3ExprListCompare(pSort, p->pOrderBy, -1)==0 ){
173164 sqlite3ExprListDelete(db, p->pOrderBy);
173165 p->pOrderBy = 0;
173177 selectWindowRewriteEList(pParse, pMWin, pSrc, p->pOrderBy, pTab, &pSublist);
173184 pSublist = exprListAppendList(pParse, pSublist, pMWin->pOrderBy, 0);
173292 sqlite3ExprListDelete(db, p->pOrderBy);
173407 ExprList *pOrderBy,
173412 pWin->pOrderBy = pOrderBy;
173418 sqlite3ExprListDelete(pParse->db, pOrderBy);
173439 }else if( pExist->pOrderBy && pWin->pOrderBy ){
173450 if( pExist->pOrderBy ){
173451 assert( pWin->pOrderBy==0 );
173452 pWin->pOrderBy = sqlite3ExprListDup(db, pExist->pOrderBy, 0);
173527 if( (res = sqlite3ExprListCompare(p1->pOrderBy, p2->pOrderBy, -1)) ){
173781 ExprList *pOrderBy = pMWin->pOrderBy;
173782 if( pOrderBy ){
173787 for(i=0; i<pOrderBy->nExpr; i++){
173991 nPeer = (pMWin->pOrderBy ? pMWin->pOrderBy->nExpr : 0);
174025 if( pMWin->pOrderBy ){
174026 pKeyInfo = sqlite3KeyInfoFromExprList(pParse, pMWin->pOrderBy, 0, 0);
174213 ExprList *pOrderBy,
174219 if( pOrderBy ){
174220 int nVal = pOrderBy->nExpr;
174221 KeyInfo *pKeyInfo = sqlite3KeyInfoFromExprList(pParse, pOrderBy, 0, 0);
174267 ExprList *pOrderBy = p->pMWin->pOrderBy; /* ORDER BY clause for window */
174281 assert( pOrderBy && pOrderBy->nExpr==1 );
174282 if( pOrderBy->a[0].fg.sortFlags & KEYINFO_ORDER_DESC ){
174315 if( pOrderBy->a[0].fg.sortFlags & KEYINFO_ORDER_BIGNULL ){
174367 pColl = sqlite3ExprNNCollSeq(pParse, pOrderBy->a[0].pExpr);
174518 int nReg = (pMWin->pOrderBy ? pMWin->pOrderBy->nExpr : 0);
174521 windowIfNewPeer(pParse, pMWin->pOrderBy, regTmp, reg, addrContinue);
174548 pNew->pOrderBy = sqlite3ExprListDup(db, p->pOrderBy, 0);
174948 ExprList *pOrderBy = pMWin->pOrderBy;
175047 int nPeer = (pOrderBy ? pOrderBy->nExpr : 0);
175126 if( regPeer && pOrderBy ){
175127 sqlite3VdbeAddOp3(v, OP_Copy, regNewPeer, regPeer, pOrderBy->nExpr-1);
175128 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.start.reg, pOrderBy->nExpr-1);
175129 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.current.reg, pOrderBy->nExpr-1);
175130 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.end.reg, pOrderBy->nExpr-1);
175139 windowIfNewPeer(pParse, pOrderBy, regNewPeer, regPeer, lblWhereEnd);
175375 ExprList *pOrderBy,
175378 if( pOrderBy ){
175383 sqlite3ExprListDelete(pParse->db, pOrderBy);
175406 if( pLoop->pOrderBy || pLoop->pLimit ){
175408 pLoop->pOrderBy!=0 ? "ORDER BY" : "LIMIT",