Lines Matching refs:pOrderBy
19512 ExprList *pOrderBy; /* The ORDER BY clause */ member
19672 ExprList *pOrderBy; /* Key columns for SRT_Queue and SRT_DistQueue */ member
20454 ExprList *pOrderBy; /* ORDER BY clause */ member
32877 if( p->pOrderBy ) n++; in sqlite3TreeViewSelect()
32928 if( p->pOrderBy ){ in sqlite3TreeViewSelect()
32929 sqlite3TreeViewExprList(pView, p->pOrderBy, (n--)>0, "ORDERBY"); in sqlite3TreeViewSelect()
33012 if( pWin->pOrderBy ) nElement++; in sqlite3TreeViewWindow()
33023 if( pWin->pOrderBy ){ in sqlite3TreeViewWindow()
33024 sqlite3TreeViewExprList(pView, pWin->pOrderBy, (--nElement)>0, "ORDER-BY"); in sqlite3TreeViewWindow()
33621 const ExprList *pOrderBy, in sqlite3TreeViewDelete() argument
33632 if( pOrderBy ) n++; in sqlite3TreeViewDelete()
33652 if( pOrderBy ){ in sqlite3TreeViewDelete()
33653 sqlite3TreeViewExprList(pView, pOrderBy, (--n)>0, "ORDER-BY"); in sqlite3TreeViewDelete()
33749 const ExprList *pOrderBy, in sqlite3TreeViewUpdate() argument
33770 if( pOrderBy ) n++; in sqlite3TreeViewUpdate()
33794 if( pOrderBy ){ in sqlite3TreeViewUpdate()
33795 sqlite3TreeViewExprList(pView, pOrderBy, (--n)>0, "ORDER-BY"); in sqlite3TreeViewUpdate()
106491 rc = sqlite3WalkExprList(pWalker, pWin->pOrderBy);
106600 if( sqlite3WalkExprList(pWalker, p->pOrderBy) ) return WRC_Abort;
108031 sqlite3WalkExprList(pWalker, pWin->pOrderBy);
108300 ExprList *pOrderBy;
108305 pOrderBy = pSelect->pOrderBy;
108306 if( pOrderBy==0 ) return 0;
108308 if( pOrderBy->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
108312 for(i=0; i<pOrderBy->nExpr; i++){
108313 pOrderBy->a[i].fg.done = 0;
108325 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
108388 for(i=0; i<pOrderBy->nExpr; i++){
108389 if( pOrderBy->a[i].fg.done==0 ){
108411 ExprList *pOrderBy, /* The ORDER BY or GROUP BY clause to be processed */
108419 if( pOrderBy==0 || pParse->db->mallocFailed || IN_RENAME_OBJECT ) return 0;
108420 if( pOrderBy->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
108426 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
108489 ExprList *pOrderBy, /* An ORDER BY or GROUP BY clause to resolve */
108498 assert( pOrderBy!=0 );
108501 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
108543 return sqlite3ResolveOrderGroupBy(pParse, pSelect, pOrderBy, zType);
108608 assert( p->pSrc->nSrc==1 && p->pOrderBy );
108609 assert( pSub->pPrior && pSub->pOrderBy==0 );
108610 pSub->pOrderBy = p->pOrderBy;
108611 p->pOrderBy = 0;
108706 if( sqlite3ResolveExprListNames(&sNC, pWin->pOrderBy)
108728 p->pOrderBy = pSub->pOrderBy;
108729 pSub->pOrderBy = 0;
108742 if( p->pOrderBy!=0
108744 && resolveOrderGroupBy(&sNC, p, p->pOrderBy, "ORDER")
109841 heightOfExprList(p->pOrderBy, pnHeight);
110221 ExprList *pOrderBy /* The ORDER BY clause to add */
110225 if( NEVER(pOrderBy==0) ){
110231 sqlite3ExprListDelete(db, pOrderBy);
110239 sqlite3ParserAddCleanup(pParse, sqlite3ExprListDeleteGeneric, pOrderBy);
110244 sqlite3ExprListDelete(db, pOrderBy);
110250 sqlite3ExprListDelete(db, pOrderBy);
110253 pOB->x.pList = pOrderBy;
110958 pNew->pOrderBy = sqlite3ExprListDup(db, p->pOrderBy, flags);
127762 ExprList *pOrderBy, /* Optional ORDER BY clause */
127780 pSel = sqlite3SelectNew(pParse, 0, pFrom, pWhere, 0, 0, pOrderBy,
127801 ExprList *pOrderBy, /* The ORDER BY clause. May be null */
127815 if( pOrderBy && pLimit==0 ) {
127818 sqlite3ExprListDelete(pParse->db, pOrderBy);
127885 pOrderBy,0,pLimit
127907 ExprList *pOrderBy, /* ORDER BY clause. May be null */
127983 pOrderBy, pLimit, pTrigger);
127990 pParse, pTabList, pWhere, pOrderBy, pLimit, "DELETE"
127992 pOrderBy = 0;
128045 pWhere, pOrderBy, pLimit, iTabCur
128048 pOrderBy = 0;
128303 sqlite3ExprListDelete(db, pOrderBy);
135934 if( pSelect->pOrderBy ){
142941 ExprList *pOrderBy; /* The ORDER BY (or GROUP BY clause) */
142982 sqlite3ExprListDelete(db, p->pOrderBy);
143024 ExprList *pOrderBy, /* the ORDER BY clause */
143053 pNew->pOrderBy = pOrderBy;
143597 int nExpr = pSort->pOrderBy->nExpr; /* No. of ORDER BY terms */
143637 sqlite3ExprCodeExprList(pParse, pSort->pOrderBy, regBase, regOrigData,
143671 pOp->p4.pKeyInfo = sqlite3KeyInfoFromExprList(pParse,pSort->pOrderBy,nOBSat,
144025 if( pSort && pSort->pOrderBy==0 ) pSort = 0;
144037 nPrefixReg = pSort->pOrderBy->nExpr;
144081 for(i=pSort->nOBSat; i<pSort->pOrderBy->nExpr; i++){
144083 if( (j = pSort->pOrderBy->a[i].u.x.iOrderByCol)>0 ){
144337 pSO = pDest->pOrderBy;
144551 ExprList *pOrderBy = pSort->pOrderBy;
144567 nKey = pOrderBy->nExpr - pSort->nOBSat;
145449 ExprList *pOrderBy = p->pOrderBy;
145450 int nOrderBy = ALWAYS(pOrderBy!=0) ? pOrderBy->nExpr : 0;
145456 struct ExprList_item *pItem = &pOrderBy->a[i];
145465 pOrderBy->a[i].pExpr =
145470 pRet->aSortFlags[i] = pOrderBy->a[i].fg.sortFlags;
145534 ExprList *pOrderBy; /* The ORDER BY clause */
145557 pOrderBy = p->pOrderBy;
145572 eDest = pOrderBy ? SRT_DistQueue : SRT_DistFifo;
145575 eDest = pOrderBy ? SRT_Queue : SRT_Fifo;
145582 if( pOrderBy ){
145584 sqlite3VdbeAddOp4(v, OP_OpenEphemeral, iQueue, pOrderBy->nExpr+2, 0,
145586 destQueue.pOrderBy = pOrderBy;
145597 p->pOrderBy = 0;
145628 if( pOrderBy ){
145629 sqlite3VdbeAddOp3(v, OP_Column, iQueue, pOrderBy->nExpr+1, regCurrent);
145660 sqlite3ExprListDelete(pParse->db, p->pOrderBy);
145661 p->pOrderBy = pOrderBy;
145784 assert( pPrior->pOrderBy==0 );
145820 if( p->pOrderBy ){
145899 assert( p->pOrderBy==0 );
145910 assert( !pPrior->pOrderBy );
145935 assert( p->pOrderBy==0 );
145938 p->pOrderBy = 0;
145982 assert( p->pOrderBy==0 );
146393 ExprList *pOrderBy; /* The ORDER BY clause */
146397 assert( p->pOrderBy!=0 );
146409 assert( p->pPrior->pOrderBy==0 );
146410 pOrderBy = p->pOrderBy;
146411 assert( pOrderBy );
146412 nOrderBy = pOrderBy->nExpr;
146421 for(j=0, pItem=pOrderBy->a; j<nOrderBy; j++, pItem++){
146431 p->pOrderBy = pOrderBy = sqlite3ExprListAppend(pParse, pOrderBy, pNew);
146432 if( pOrderBy ) pOrderBy->a[nOrderBy++].u.x.iOrderByCol = (u16)i;
146448 for(i=1, pItem=pOrderBy->a; i<=nOrderBy; i++, pItem++){
146502 assert( p->pOrderBy == pOrderBy );
146503 assert( pOrderBy!=0 || db->mallocFailed );
146504 pPrior->pOrderBy = sqlite3ExprListDup(pParse->db, pOrderBy, 0);
146505 sqlite3ResolveOrderGroupBy(pParse, p, p->pOrderBy, "ORDER");
146506 sqlite3ResolveOrderGroupBy(pParse, pPrior, pPrior->pOrderBy, "ORDER");
146662 sqlite3ExprListDelete(db, pPrior->pOrderBy);
146663 pPrior->pOrderBy = 0;
146832 substExprList(pSubst, pWin->pOrderBy);
146860 substExprList(pSubst, p->pOrderBy);
147273 if( p->pOrderBy && pSub->pOrderBy ){
147276 if( isAgg && pSub->pOrderBy ) return 0; /* Restriction (16) */
147326 if( pSub->pOrderBy ){
147357 if( p->pOrderBy ){
147358 for(ii=0; ii<p->pOrderBy->nExpr; ii++){
147359 if( p->pOrderBy->a[ii].u.x.iOrderByCol==0 ) return 0;
147433 ExprList *pOrderBy = p->pOrderBy;
147438 p->pOrderBy = 0;
147443 p->pOrderBy = pOrderBy;
147562 if( pSub->pOrderBy && (pParent->selFlags & SF_NoopOrderBy)==0 ){
147573 ExprList *pOrderBy = pSub->pOrderBy;
147574 for(i=0; i<pOrderBy->nExpr; i++){
147575 pOrderBy->a[i].u.x.iOrderByCol = 0;
147577 assert( pParent->pOrderBy==0 );
147578 pParent->pOrderBy = pOrderBy;
147579 pSub->pOrderBy = 0;
148249 if( pSub->pOrderBy ){
148250 ExprList *pList = pSub->pOrderBy;
148296 ExprList *pOrderBy;
148324 *ppMinMax = pOrderBy = sqlite3ExprListDup(db, pEList, 0);
148325 assert( pOrderBy!=0 || db->mallocFailed );
148326 if( pOrderBy ) pOrderBy->a[0].fg.sortFlags = sortFlags;
148439 if( p->pOrderBy==0 ) return WRC_Continue;
148442 a = p->pOrderBy->a;
148451 for(i=p->pOrderBy->nExpr-1; i>=0; i--){
148472 pNew->pOrderBy = 0;
150029 if( p->pOrderBy ) return 0;
150232 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistFifo );
150233 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Fifo );
150234 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistQueue );
150235 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Queue );
150241 if( p->pOrderBy ){
150245 sqlite3TreeViewExprList(0, p->pOrderBy, 0, "ORDERBY");
150249 p->pOrderBy);
150251 p->pOrderBy = 0;
150314 sSort.pOrderBy = p->pOrderBy;
150432 if( pSub->pOrderBy!=0
150433 && (p->pOrderBy!=0 || pTabList->nSrc>1) /* Condition (5) */
150442 pSub->pOrderBy);
150443 pSub->pOrderBy = 0;
150464 if( pSub->pOrderBy!=0
150481 sSort.pOrderBy = p->pOrderBy;
150740 && sqlite3ExprListCompare(sSort.pOrderBy, pEList, -1)==0
150770 if( sSort.pOrderBy ){
150773 pParse, sSort.pOrderBy, 0, pEList->nExpr);
150777 sSort.iECursor, sSort.pOrderBy->nExpr+1+pEList->nExpr, 0,
150843 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy,
150852 if( sSort.pOrderBy ){
150855 if( sSort.nOBSat==sSort.pOrderBy->nExpr ){
150856 sSort.pOrderBy = 0;
150865 if( sSort.addrSortIndex>=0 && sSort.pOrderBy==0 ){
150941 if( sSort.pOrderBy && pGroupBy->nExpr==sSort.pOrderBy->nExpr ){
150950 sortFlags = sSort.pOrderBy->a[ii].fg.sortFlags & KEYINFO_ORDER_DESC;
150953 if( sqlite3ExprListCompare(pGroupBy, sSort.pOrderBy, -1)==0 ){
150989 sqlite3ExprAnalyzeAggList(&sNC, sSort.pOrderBy);
151194 sSort.pOrderBy = 0;
151441 sSort.pOrderBy = 0;
151457 if( sSort.pOrderBy ){
153467 ExprList *pOrderBy, /* ORDER BY clause */
153484 if( pOrderBy && pLimit==0 ) {
153488 pOrderBy2 = sqlite3ExprListDup(db, pOrderBy, 0);
153491 UNUSED_PARAMETER(pOrderBy);
153564 ExprList *pOrderBy, /* ORDER BY clause. May be null */
153660 onError, pOrderBy, pLimit, pUpsert, pTrigger);
153674 pParse, pTabList, pWhere, pOrderBy, pLimit, "UPDATE"
153676 pOrderBy = 0;
153911 pWhere, pOrderBy, pLimit, iDataCur
153913 pOrderBy = 0;
153974 pParse, iEph, pPk, pChanges, pTabList, pWhere, pOrderBy, pLimit
154438 sqlite3ExprListDelete(db, pOrderBy);
157255 ExprList *pOrderBy; /* The ORDER BY clause or NULL */
157959 if( pSelect->pOrderBy ){
157967 ExprList *pOrderBy = pSelect->pOrderBy;
157968 for(i=0; i<pOrderBy->nExpr; i++){
157969 pOrderBy->a[i].u.x.iOrderByCol = 0;
161183 mask |= sqlite3WhereExprListUsage(pMaskSet, pS->pOrderBy);
161861 ExprList *pOrderBy = p->pOrderBy;
161886 if( pOrderBy ){
161887 for(ii=0; ii<pOrderBy->nExpr; ii++){
161888 Expr *pExpr = pOrderBy->a[ii].pExpr;
161891 if( pOrderBy->a[ii].fg.sortFlags & KEYINFO_ORDER_BIGNULL ) return;
162014 mask |= sqlite3WhereExprListUsage(pMaskSet, p->y.pWin->pOrderBy);
163454 ExprList *pOrderBy = pWInfo->pOrderBy;
163494 if( pOrderBy ){
163495 int n = pOrderBy->nExpr;
163497 Expr *pExpr = pOrderBy->a[i].pExpr;
163506 if( pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_BIGNULL ) break;
163612 Expr *pExpr = pOrderBy->a[i].pExpr;
163618 pIdxOrderBy[j].desc = pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_DESC;
165543 if( (pOB = pBuilder->pWInfo->pOrderBy)==0 ) return 0;
166899 ExprList *pOrderBy, /* ORDER BY or GROUP BY or DISTINCT clause to check */
166953 assert( pOrderBy!=0 );
166956 nOrderBy = pOrderBy->nExpr;
166994 pOBExpr = sqlite3ExprSkipCollateAndLikely(pOrderBy->a[i].pExpr);
167012 CollSeq *pColl1 = sqlite3ExprNNCollSeq(pParse, pOrderBy->a[i].pExpr);
167127 pOBExpr = sqlite3ExprSkipCollateAndLikely(pOrderBy->a[i].pExpr);
167143 pColl = sqlite3ExprNNCollSeq(pWInfo->pParse, pOrderBy->a[i].pExpr);
167157 != (pOrderBy->a[i].fg.sortFlags&KEYINFO_ORDER_DESC)
167162 rev = revIdx ^ (pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_DESC);
167167 if( isMatch && (pOrderBy->a[i].fg.sortFlags & KEYINFO_ORDER_BIGNULL) ){
167202 p = pOrderBy->a[i].pExpr;
167377 if( pWInfo->pOrderBy==0 || nRowEst==0 ){
167380 nOrderBy = pWInfo->pOrderBy->nExpr;
167461 pWInfo->pOrderBy, pFrom, pWInfo->wctrlFlags,
167667 if( pWInfo->pOrderBy ){
167670 if( pFrom->isOrdered==pWInfo->pOrderBy->nExpr ){
167674 assert( pWInfo->pSelect->pOrderBy==0
167675 || pWInfo->nOBSat <= pWInfo->pSelect->pOrderBy->nExpr );
167686 int rc = wherePathSatisfiesOrderBy(pWInfo, pWInfo->pOrderBy, pFrom,
167690 if( rc==pWInfo->pOrderBy->nExpr ){
167704 && pWInfo->nOBSat==pWInfo->pOrderBy->nExpr && nLoop>0
167707 int nOrder = wherePathSatisfiesOrderBy(pWInfo, pWInfo->pOrderBy,
167711 if( nOrder==pWInfo->pOrderBy->nExpr ){
167887 if( pWInfo->pOrderBy ) pWInfo->nOBSat = pWInfo->pOrderBy->nExpr;
168011 if( pWInfo->pOrderBy ){
168012 tabUsed |= sqlite3WhereExprListUsage(&pWInfo->sMaskSet, pWInfo->pOrderBy);
168249 || pItem->pSelect->pOrderBy==0
168348 ExprList *pOrderBy, /* An ORDER BY (or GROUP BY) clause, or NULL */
168383 testcase( pOrderBy && pOrderBy->nExpr==BMS-1 );
168384 if( pOrderBy && pOrderBy->nExpr>=BMS ){
168385 pOrderBy = 0;
168425 pWInfo->pOrderBy = pOrderBy;
168464 if( pOrderBy ) pWInfo->nOBSat = pOrderBy->nExpr;
168566 }else if( pOrderBy==0 ){
168569 pWInfo->pOrderBy = pResultSet;
168587 sSelect.pOrderBy = pOrderBy;
168626 if( pWInfo->pOrderBy ){
168643 if( pWInfo->pOrderBy==0 && (db->flags & SQLITE_ReverseOrder)!=0 ){
170016 pWin->pOrderBy = sqlite3ExprListDup(pParse->db, p->pOrderBy, 0);
170028 && (pWin->pOrderBy==0 || pWin->pOrderBy->nExpr!=1)
170338 sqlite3WalkExprList(&w, p->pOrderBy);
170352 pSort = exprListAppendList(pParse, pSort, pMWin->pOrderBy, 1);
170353 if( pSort && p->pOrderBy && p->pOrderBy->nExpr<=pSort->nExpr ){
170355 pSort->nExpr = p->pOrderBy->nExpr;
170356 if( sqlite3ExprListCompare(pSort, p->pOrderBy, -1)==0 ){
170357 sqlite3ExprListDelete(db, p->pOrderBy);
170358 p->pOrderBy = 0;
170370 selectWindowRewriteEList(pParse, pMWin, pSrc, p->pOrderBy, pTab, &pSublist);
170377 pSublist = exprListAppendList(pParse, pSublist, pMWin->pOrderBy, 0);
170486 sqlite3ExprListDelete(db, p->pOrderBy);
170601 ExprList *pOrderBy,
170606 pWin->pOrderBy = pOrderBy;
170612 sqlite3ExprListDelete(pParse->db, pOrderBy);
170633 }else if( pExist->pOrderBy && pWin->pOrderBy ){
170644 if( pExist->pOrderBy ){
170645 assert( pWin->pOrderBy==0 );
170646 pWin->pOrderBy = sqlite3ExprListDup(db, pExist->pOrderBy, 0);
170721 if( (res = sqlite3ExprListCompare(p1->pOrderBy, p2->pOrderBy, -1)) ){
170970 ExprList *pOrderBy = pMWin->pOrderBy;
170971 if( pOrderBy ){
170976 for(i=0; i<pOrderBy->nExpr; i++){
171178 nPeer = (pMWin->pOrderBy ? pMWin->pOrderBy->nExpr : 0);
171212 if( pMWin->pOrderBy ){
171213 pKeyInfo = sqlite3KeyInfoFromExprList(pParse, pMWin->pOrderBy, 0, 0);
171400 ExprList *pOrderBy,
171406 if( pOrderBy ){
171407 int nVal = pOrderBy->nExpr;
171408 KeyInfo *pKeyInfo = sqlite3KeyInfoFromExprList(pParse, pOrderBy, 0, 0);
171454 ExprList *pOrderBy = p->pMWin->pOrderBy; /* ORDER BY clause for window */
171468 assert( pOrderBy && pOrderBy->nExpr==1 );
171469 if( pOrderBy->a[0].fg.sortFlags & KEYINFO_ORDER_DESC ){
171502 if( pOrderBy->a[0].fg.sortFlags & KEYINFO_ORDER_BIGNULL ){
171554 pColl = sqlite3ExprNNCollSeq(pParse, pOrderBy->a[0].pExpr);
171705 int nReg = (pMWin->pOrderBy ? pMWin->pOrderBy->nExpr : 0);
171708 windowIfNewPeer(pParse, pMWin->pOrderBy, regTmp, reg, addrContinue);
171735 pNew->pOrderBy = sqlite3ExprListDup(db, p->pOrderBy, 0);
172135 ExprList *pOrderBy = pMWin->pOrderBy;
172234 int nPeer = (pOrderBy ? pOrderBy->nExpr : 0);
172313 if( regPeer && pOrderBy ){
172314 sqlite3VdbeAddOp3(v, OP_Copy, regNewPeer, regPeer, pOrderBy->nExpr-1);
172315 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.start.reg, pOrderBy->nExpr-1);
172316 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.current.reg, pOrderBy->nExpr-1);
172317 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.end.reg, pOrderBy->nExpr-1);
172326 windowIfNewPeer(pParse, pOrderBy, regNewPeer, regPeer, lblWhereEnd);
172546 ExprList *pOrderBy,
172549 if( pOrderBy ){
172554 sqlite3ExprListDelete(pParse->db, pOrderBy);
172577 if( pLoop->pOrderBy || pLoop->pLimit ){
172579 pLoop->pOrderBy!=0 ? "ORDER BY" : "LIMIT",