Home
last modified time | relevance | path

Searched refs:pOrderBy (Results 1 – 15 of 15) sorted by relevance

/sqlite-3.40.0/src/
H A Dwindow.c681 && (pWin->pOrderBy==0 || pWin->pOrderBy->nExpr!=1) in sqlite3WindowUpdate()
1257 pWin->pOrderBy = pOrderBy; in sqlite3WindowAssemble()
1284 }else if( pExist->pOrderBy && pWin->pOrderBy ){ in sqlite3WindowChain()
1620 ExprList *pOrderBy = pMWin->pOrderBy; in windowReadPeerValues() local
1621 if( pOrderBy ){ in windowReadPeerValues()
1828 nPeer = (pMWin->pOrderBy ? pMWin->pOrderBy->nExpr : 0); in windowFullScan()
2118 assert( pOrderBy && pOrderBy->nExpr==1 ); in windowCodeRangeTest()
2355 int nReg = (pMWin->pOrderBy ? pMWin->pOrderBy->nExpr : 0); in windowCodeOp()
2385 pNew->pOrderBy = sqlite3ExprListDup(db, p->pOrderBy, 0); in sqlite3WindowDup()
2785 ExprList *pOrderBy = pMWin->pOrderBy; in sqlite3WindowCodeStep() local
[all …]
H A Dselect.c158 pNew->pOrderBy = pOrderBy; in sqlite3SelectNew()
2488 ExprList *pOrderBy = p->pOrderBy; in multiSelectOrderByKeyInfo() local
2596 pOrderBy = p->pOrderBy; in generateWithRecursiveQuery()
2625 destQueue.pOrderBy = pOrderBy; in generateWithRecursiveQuery()
2700 p->pOrderBy = pOrderBy; in generateWithRecursiveQuery()
3451 pOrderBy = p->pOrderBy; in multiSelectOrderBy()
3543 assert( p->pOrderBy == pOrderBy ); in multiSelectOrderBy()
4463 p->pOrderBy = pOrderBy; in flattenSubquery()
4600 pParent->pOrderBy = pOrderBy; in flattenSubquery()
6770 sSort.pOrderBy = p->pOrderBy; in sqlite3Select()
[all …]
H A Dresolve.c1436 ExprList *pOrderBy; in resolveCompoundOrderBy() local
1441 pOrderBy = pSelect->pOrderBy; in resolveCompoundOrderBy()
1461 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){ in resolveCompoundOrderBy()
1562 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){ in sqlite3ResolveOrderGroupBy()
1634 assert( pOrderBy!=0 ); in resolveOrderGroupBy()
1637 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){ in resolveOrderGroupBy()
1748 pSub->pOrderBy = p->pOrderBy; in resolveSelectStep()
1749 p->pOrderBy = 0; in resolveSelectStep()
1859 p->pOrderBy = pSub->pOrderBy; in resolveSelectStep()
1860 pSub->pOrderBy = 0; in resolveSelectStep()
[all …]
H A Ddelete.c142 ExprList *pOrderBy, /* Optional ORDER BY clause */ in sqlite3MaterializeView() argument
195 if( pOrderBy && pLimit==0 ) { in sqlite3LimitWhere()
198 sqlite3ExprListDelete(pParse->db, pOrderBy); in sqlite3LimitWhere()
259 pOrderBy,0,pLimit in sqlite3LimitWhere()
281 ExprList *pOrderBy, /* ORDER BY clause. May be null */ in sqlite3DeleteFrom() argument
357 pOrderBy, pLimit, pTrigger); in sqlite3DeleteFrom()
364 pParse, pTabList, pWhere, pOrderBy, pLimit, "DELETE" in sqlite3DeleteFrom()
366 pOrderBy = 0; in sqlite3DeleteFrom()
419 pWhere, pOrderBy, pLimit, iTabCur in sqlite3DeleteFrom()
422 pOrderBy = 0; in sqlite3DeleteFrom()
[all …]
H A Dtreeview.c282 if( p->pOrderBy ) n++; in sqlite3TreeViewSelect()
333 if( p->pOrderBy ){ in sqlite3TreeViewSelect()
416 if( pWin->pOrderBy ) nElement++; in sqlite3TreeViewWindow()
427 if( pWin->pOrderBy ){ in sqlite3TreeViewWindow()
1011 const ExprList *pOrderBy, in sqlite3TreeViewDelete() argument
1022 if( pOrderBy ) n++; in sqlite3TreeViewDelete()
1042 if( pOrderBy ){ in sqlite3TreeViewDelete()
1043 sqlite3TreeViewExprList(pView, pOrderBy, (--n)>0, "ORDER-BY"); in sqlite3TreeViewDelete()
1139 const ExprList *pOrderBy, in sqlite3TreeViewUpdate() argument
1160 if( pOrderBy ) n++; in sqlite3TreeViewUpdate()
[all …]
H A Dupdate.c194 ExprList *pOrderBy, /* ORDER BY clause */ in updateFromSelect() argument
211 if( pOrderBy && pLimit==0 ) { in updateFromSelect()
215 pOrderBy2 = sqlite3ExprListDup(db, pOrderBy, 0); in updateFromSelect()
218 UNUSED_PARAMETER(pOrderBy); in updateFromSelect()
290 ExprList *pOrderBy, /* ORDER BY clause. May be null */ in sqlite3Update() argument
386 onError, pOrderBy, pLimit, pUpsert, pTrigger); in sqlite3Update()
400 pParse, pTabList, pWhere, pOrderBy, pLimit, "UPDATE" in sqlite3Update()
402 pOrderBy = 0; in sqlite3Update()
637 pWhere, pOrderBy, pLimit, iDataCur in sqlite3Update()
639 pOrderBy = 0; in sqlite3Update()
[all …]
H A Dwhere.c1187 ExprList *pOrderBy = pWInfo->pOrderBy; in allocateIndexInfo() local
1227 if( pOrderBy ){ in allocateIndexInfo()
4410 assert( pOrderBy!=0 ); in wherePathSatisfiesOrderBy()
5111 if( pWInfo->pOrderBy ){ in wherePathSolver()
5252 if( pWInfo->pOrderBy ) pWInfo->nOBSat = pWInfo->pOrderBy->nExpr; in whereShortCut()
5364 if( pWInfo->pOrderBy ){ in whereOmitNoopJoin()
5660 testcase( pOrderBy && pOrderBy->nExpr==BMS-1 ); in sqlite3WhereBegin()
5661 if( pOrderBy && pOrderBy->nExpr>=BMS ) pOrderBy = 0; in sqlite3WhereBegin()
5695 pWInfo->pOrderBy = pOrderBy; in sqlite3WhereBegin()
5734 if( pOrderBy ) pWInfo->nOBSat = pOrderBy->nExpr; in sqlite3WhereBegin()
[all …]
H A Dwalker.c29 rc = sqlite3WalkExprList(pWalker, pWin->pOrderBy); in walkWindowList()
136 if( sqlite3WalkExprList(pWalker, p->pOrderBy) ) return WRC_Abort; in sqlite3WalkSelectExpr()
H A Dwhereexpr.c942 mask |= sqlite3WhereExprListUsage(pMaskSet, pS->pOrderBy); in exprSelectUsage()
1610 ExprList *pOrderBy = p->pOrderBy; in sqlite3WhereAddLimit() local
1627 if( pOrderBy ){ in sqlite3WhereAddLimit()
1628 for(ii=0; ii<pOrderBy->nExpr; ii++){ in sqlite3WhereAddLimit()
1629 Expr *pExpr = pOrderBy->a[ii].pExpr; in sqlite3WhereAddLimit()
1632 if( pOrderBy->a[ii].fg.sortFlags & KEYINFO_ORDER_BIGNULL ) return; in sqlite3WhereAddLimit()
1753 mask |= sqlite3WhereExprListUsage(pMaskSet, p->y.pWin->pOrderBy); in sqlite3WhereExprUsageFull()
H A Dwherecode.c519 if( pSelect->pOrderBy ){ in removeUnindexableInClauseTerms()
527 ExprList *pOrderBy = pSelect->pOrderBy; in removeUnindexableInClauseTerms() local
528 for(i=0; i<pOrderBy->nExpr; i++){ in removeUnindexableInClauseTerms()
529 pOrderBy->a[i].u.x.iOrderByCol = 0; in removeUnindexableInClauseTerms()
H A DwhereInt.h465 ExprList *pOrderBy; /* The ORDER BY clause or NULL */ member
H A Dparse.y128 ExprList *pOrderBy, in updateDeleteLimitError() argument
131 if( pOrderBy ){ in updateDeleteLimitError()
136 sqlite3ExprListDelete(pParse->db, pOrderBy); in updateDeleteLimitError()
520 if( pLoop->pOrderBy || pLoop->pLimit ){
522 pLoop->pOrderBy!=0 ? "ORDER BY" : "LIMIT",
H A DsqliteInt.h3357 ExprList *pOrderBy; /* The ORDER BY clause */ member
3515 ExprList *pOrderBy; /* Key columns for SRT_Queue and SRT_DistQueue */ member
4242 ExprList *pOrderBy; /* ORDER BY clause */ member
H A Dexpr.c753 heightOfExprList(p->pOrderBy, pnHeight); in heightOfSelect()
1734 pNew->pOrderBy = sqlite3ExprListDup(db, p->pOrderBy, flags); in sqlite3SelectDup()
H A Dinsert.c2829 if( pSelect->pOrderBy ){ in xferOptimization()