Lines Matching refs:pOrderBy
50 ExprList *pOrderBy; /* The ORDER BY (or GROUP BY clause) */ member
87 sqlite3ExprListDelete(db, p->pOrderBy); in clearSelect()
129 ExprList *pOrderBy, /* the ORDER BY clause */ in sqlite3SelectNew() argument
158 pNew->pOrderBy = pOrderBy; in sqlite3SelectNew()
698 int nExpr = pSort->pOrderBy->nExpr; /* No. of ORDER BY terms */ in pushOntoSorter()
734 sqlite3ExprCodeExprList(pParse, pSort->pOrderBy, regBase, regOrigData, in pushOntoSorter()
768 pOp->p4.pKeyInfo = sqlite3KeyInfoFromExprList(pParse,pSort->pOrderBy,nOBSat, in pushOntoSorter()
1119 if( pSort && pSort->pOrderBy==0 ) pSort = 0; in selectInnerLoop()
1131 nPrefixReg = pSort->pOrderBy->nExpr; in selectInnerLoop()
1175 for(i=pSort->nOBSat; i<pSort->pOrderBy->nExpr; i++){ in selectInnerLoop()
1177 if( (j = pSort->pOrderBy->a[i].u.x.iOrderByCol)>0 ){ in selectInnerLoop()
1424 pSO = pDest->pOrderBy; in selectInnerLoop()
1638 ExprList *pOrderBy = pSort->pOrderBy; in generateSortTail() local
1684 nKey = pOrderBy->nExpr - pSort->nOBSat; in generateSortTail()
2488 ExprList *pOrderBy = p->pOrderBy; in multiSelectOrderByKeyInfo() local
2489 int nOrderBy = ALWAYS(pOrderBy!=0) ? pOrderBy->nExpr : 0; in multiSelectOrderByKeyInfo()
2495 struct ExprList_item *pItem = &pOrderBy->a[i]; in multiSelectOrderByKeyInfo()
2504 pOrderBy->a[i].pExpr = in multiSelectOrderByKeyInfo()
2509 pRet->aSortFlags[i] = pOrderBy->a[i].fg.sortFlags; in multiSelectOrderByKeyInfo()
2573 ExprList *pOrderBy; /* The ORDER BY clause */ in generateWithRecursiveQuery() local
2596 pOrderBy = p->pOrderBy; in generateWithRecursiveQuery()
2611 eDest = pOrderBy ? SRT_DistQueue : SRT_DistFifo; in generateWithRecursiveQuery()
2614 eDest = pOrderBy ? SRT_Queue : SRT_Fifo; in generateWithRecursiveQuery()
2621 if( pOrderBy ){ in generateWithRecursiveQuery()
2623 sqlite3VdbeAddOp4(v, OP_OpenEphemeral, iQueue, pOrderBy->nExpr+2, 0, in generateWithRecursiveQuery()
2625 destQueue.pOrderBy = pOrderBy; in generateWithRecursiveQuery()
2636 p->pOrderBy = 0; in generateWithRecursiveQuery()
2667 if( pOrderBy ){ in generateWithRecursiveQuery()
2668 sqlite3VdbeAddOp3(v, OP_Column, iQueue, pOrderBy->nExpr+1, regCurrent); in generateWithRecursiveQuery()
2699 sqlite3ExprListDelete(pParse->db, p->pOrderBy); in generateWithRecursiveQuery()
2700 p->pOrderBy = pOrderBy; in generateWithRecursiveQuery()
2823 assert( pPrior->pOrderBy==0 ); in multiSelect()
2859 if( p->pOrderBy ){ in multiSelect()
2938 assert( p->pOrderBy==0 ); in multiSelect()
2949 assert( !pPrior->pOrderBy ); in multiSelect()
2974 assert( p->pOrderBy==0 ); in multiSelect()
2977 p->pOrderBy = 0; in multiSelect()
3021 assert( p->pOrderBy==0 ); in multiSelect()
3434 ExprList *pOrderBy; /* The ORDER BY clause */ in multiSelectOrderBy() local
3438 assert( p->pOrderBy!=0 ); in multiSelectOrderBy()
3450 assert( p->pPrior->pOrderBy==0 ); in multiSelectOrderBy()
3451 pOrderBy = p->pOrderBy; in multiSelectOrderBy()
3452 assert( pOrderBy ); in multiSelectOrderBy()
3453 nOrderBy = pOrderBy->nExpr; in multiSelectOrderBy()
3462 for(j=0, pItem=pOrderBy->a; j<nOrderBy; j++, pItem++){ in multiSelectOrderBy()
3472 p->pOrderBy = pOrderBy = sqlite3ExprListAppend(pParse, pOrderBy, pNew); in multiSelectOrderBy()
3473 if( pOrderBy ) pOrderBy->a[nOrderBy++].u.x.iOrderByCol = (u16)i; in multiSelectOrderBy()
3489 for(i=1, pItem=pOrderBy->a; i<=nOrderBy; i++, pItem++){ in multiSelectOrderBy()
3543 assert( p->pOrderBy == pOrderBy ); in multiSelectOrderBy()
3544 assert( pOrderBy!=0 || db->mallocFailed ); in multiSelectOrderBy()
3545 pPrior->pOrderBy = sqlite3ExprListDup(pParse->db, pOrderBy, 0); in multiSelectOrderBy()
3546 sqlite3ResolveOrderGroupBy(pParse, p, p->pOrderBy, "ORDER"); in multiSelectOrderBy()
3547 sqlite3ResolveOrderGroupBy(pParse, pPrior, pPrior->pOrderBy, "ORDER"); in multiSelectOrderBy()
3704 sqlite3ExprListDelete(db, pPrior->pOrderBy); in multiSelectOrderBy()
3705 pPrior->pOrderBy = 0; in multiSelectOrderBy()
3869 substExprList(pSubst, pWin->pOrderBy); in substExpr()
3897 substExprList(pSubst, p->pOrderBy); in substSelect()
4281 if( p->pOrderBy && pSub->pOrderBy ){ in flattenSubquery()
4284 if( isAgg && pSub->pOrderBy ) return 0; /* Restriction (16) */ in flattenSubquery()
4334 if( pSub->pOrderBy ){ in flattenSubquery()
4365 if( p->pOrderBy ){ in flattenSubquery()
4366 for(ii=0; ii<p->pOrderBy->nExpr; ii++){ in flattenSubquery()
4367 if( p->pOrderBy->a[ii].u.x.iOrderByCol==0 ) return 0; in flattenSubquery()
4453 ExprList *pOrderBy = p->pOrderBy; in flattenSubquery() local
4458 p->pOrderBy = 0; in flattenSubquery()
4463 p->pOrderBy = pOrderBy; in flattenSubquery()
4584 if( pSub->pOrderBy && (pParent->selFlags & SF_NoopOrderBy)==0 ){ in flattenSubquery()
4595 ExprList *pOrderBy = pSub->pOrderBy; in flattenSubquery() local
4596 for(i=0; i<pOrderBy->nExpr; i++){ in flattenSubquery()
4597 pOrderBy->a[i].u.x.iOrderByCol = 0; in flattenSubquery()
4599 assert( pParent->pOrderBy==0 ); in flattenSubquery()
4600 pParent->pOrderBy = pOrderBy; in flattenSubquery()
4601 pSub->pOrderBy = 0; in flattenSubquery()
5158 ExprList *pOrderBy; in minMaxQuery() local
5186 *ppMinMax = pOrderBy = sqlite3ExprListDup(db, pEList, 0); in minMaxQuery()
5187 assert( pOrderBy!=0 || db->mallocFailed ); in minMaxQuery()
5188 if( pOrderBy ) pOrderBy->a[0].fg.sortFlags = sortFlags; in minMaxQuery()
5301 if( p->pOrderBy==0 ) return WRC_Continue; in convertCompoundSelectToSubquery()
5304 a = p->pOrderBy->a; in convertCompoundSelectToSubquery()
5313 for(i=p->pOrderBy->nExpr-1; i>=0; i--){ in convertCompoundSelectToSubquery()
5334 pNew->pOrderBy = 0; in convertCompoundSelectToSubquery()
6687 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistFifo ); in sqlite3Select()
6688 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Fifo ); in sqlite3Select()
6689 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistQueue ); in sqlite3Select()
6690 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Queue ); in sqlite3Select()
6696 if( p->pOrderBy ){ in sqlite3Select()
6700 sqlite3TreeViewExprList(0, p->pOrderBy, 0, "ORDERBY"); in sqlite3Select()
6705 p->pOrderBy); in sqlite3Select()
6707 p->pOrderBy = 0; in sqlite3Select()
6770 sSort.pOrderBy = p->pOrderBy; in sqlite3Select()
6842 if( pSub->pOrderBy!=0 in sqlite3Select()
6843 && (p->pOrderBy!=0 || pTabList->nSrc>1) /* Condition (5) */ in sqlite3Select()
6853 pSub->pOrderBy); in sqlite3Select()
6854 pSub->pOrderBy = 0; in sqlite3Select()
6875 if( pSub->pOrderBy!=0 in sqlite3Select()
6892 sSort.pOrderBy = p->pOrderBy; in sqlite3Select()
7149 && sqlite3ExprListCompare(sSort.pOrderBy, pEList, -1)==0 in sqlite3Select()
7179 if( sSort.pOrderBy ){ in sqlite3Select()
7182 pParse, sSort.pOrderBy, 0, pEList->nExpr); in sqlite3Select()
7186 sSort.iECursor, sSort.pOrderBy->nExpr+1+pEList->nExpr, 0, in sqlite3Select()
7252 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy, in sqlite3Select()
7261 if( sSort.pOrderBy ){ in sqlite3Select()
7264 if( sSort.nOBSat==sSort.pOrderBy->nExpr ){ in sqlite3Select()
7265 sSort.pOrderBy = 0; in sqlite3Select()
7274 if( sSort.addrSortIndex>=0 && sSort.pOrderBy==0 ){ in sqlite3Select()
7350 if( sSort.pOrderBy && pGroupBy->nExpr==sSort.pOrderBy->nExpr ){ in sqlite3Select()
7359 sortFlags = sSort.pOrderBy->a[ii].fg.sortFlags & KEYINFO_ORDER_DESC; in sqlite3Select()
7362 if( sqlite3ExprListCompare(pGroupBy, sSort.pOrderBy, -1)==0 ){ in sqlite3Select()
7397 sqlite3ExprAnalyzeAggList(&sNC, sSort.pOrderBy); in sqlite3Select()
7600 sSort.pOrderBy = 0; in sqlite3Select()
7845 sSort.pOrderBy = 0; in sqlite3Select()
7861 if( sSort.pOrderBy ){ in sqlite3Select()