Lines Matching refs:pOrderBy
669 pWin->pOrderBy = sqlite3ExprListDup(pParse->db, p->pOrderBy, 0); in sqlite3WindowUpdate()
681 && (pWin->pOrderBy==0 || pWin->pOrderBy->nExpr!=1) in sqlite3WindowUpdate()
990 sqlite3WalkExprList(&w, p->pOrderBy); in sqlite3WindowRewrite()
1004 pSort = exprListAppendList(pParse, pSort, pMWin->pOrderBy, 1); in sqlite3WindowRewrite()
1005 if( pSort && p->pOrderBy && p->pOrderBy->nExpr<=pSort->nExpr ){ in sqlite3WindowRewrite()
1007 pSort->nExpr = p->pOrderBy->nExpr; in sqlite3WindowRewrite()
1008 if( sqlite3ExprListCompare(pSort, p->pOrderBy, -1)==0 ){ in sqlite3WindowRewrite()
1009 sqlite3ExprListDelete(db, p->pOrderBy); in sqlite3WindowRewrite()
1010 p->pOrderBy = 0; in sqlite3WindowRewrite()
1022 selectWindowRewriteEList(pParse, pMWin, pSrc, p->pOrderBy, pTab, &pSublist); in sqlite3WindowRewrite()
1029 pSublist = exprListAppendList(pParse, pSublist, pMWin->pOrderBy, 0); in sqlite3WindowRewrite()
1137 sqlite3ExprListDelete(db, p->pOrderBy); in sqlite3WindowDelete()
1252 ExprList *pOrderBy, in sqlite3WindowAssemble() argument
1257 pWin->pOrderBy = pOrderBy; in sqlite3WindowAssemble()
1263 sqlite3ExprListDelete(pParse->db, pOrderBy); in sqlite3WindowAssemble()
1284 }else if( pExist->pOrderBy && pWin->pOrderBy ){ in sqlite3WindowChain()
1295 if( pExist->pOrderBy ){ in sqlite3WindowChain()
1296 assert( pWin->pOrderBy==0 ); in sqlite3WindowChain()
1297 pWin->pOrderBy = sqlite3ExprListDup(db, pExist->pOrderBy, 0); in sqlite3WindowChain()
1371 if( (res = sqlite3ExprListCompare(p1->pOrderBy, p2->pOrderBy, -1)) ){ in sqlite3WindowCompare()
1620 ExprList *pOrderBy = pMWin->pOrderBy; in windowReadPeerValues() local
1621 if( pOrderBy ){ in windowReadPeerValues()
1626 for(i=0; i<pOrderBy->nExpr; i++){ in windowReadPeerValues()
1828 nPeer = (pMWin->pOrderBy ? pMWin->pOrderBy->nExpr : 0); in windowFullScan()
1862 if( pMWin->pOrderBy ){ in windowFullScan()
1863 pKeyInfo = sqlite3KeyInfoFromExprList(pParse, pMWin->pOrderBy, 0, 0); in windowFullScan()
2050 ExprList *pOrderBy, in windowIfNewPeer() argument
2056 if( pOrderBy ){ in windowIfNewPeer()
2057 int nVal = pOrderBy->nExpr; in windowIfNewPeer()
2058 KeyInfo *pKeyInfo = sqlite3KeyInfoFromExprList(pParse, pOrderBy, 0, 0); in windowIfNewPeer()
2104 ExprList *pOrderBy = p->pMWin->pOrderBy; /* ORDER BY clause for window */ in windowCodeRangeTest() local
2118 assert( pOrderBy && pOrderBy->nExpr==1 ); in windowCodeRangeTest()
2119 if( pOrderBy->a[0].fg.sortFlags & KEYINFO_ORDER_DESC ){ in windowCodeRangeTest()
2152 if( pOrderBy->a[0].fg.sortFlags & KEYINFO_ORDER_BIGNULL ){ in windowCodeRangeTest()
2204 pColl = sqlite3ExprNNCollSeq(pParse, pOrderBy->a[0].pExpr); in windowCodeRangeTest()
2355 int nReg = (pMWin->pOrderBy ? pMWin->pOrderBy->nExpr : 0); in windowCodeOp()
2358 windowIfNewPeer(pParse, pMWin->pOrderBy, regTmp, reg, addrContinue); in windowCodeOp()
2385 pNew->pOrderBy = sqlite3ExprListDup(db, p->pOrderBy, 0); in sqlite3WindowDup()
2785 ExprList *pOrderBy = pMWin->pOrderBy; in sqlite3WindowCodeStep() local
2884 int nPeer = (pOrderBy ? pOrderBy->nExpr : 0); in sqlite3WindowCodeStep()
2967 if( regPeer && pOrderBy ){ in sqlite3WindowCodeStep()
2968 sqlite3VdbeAddOp3(v, OP_Copy, regNewPeer, regPeer, pOrderBy->nExpr-1); in sqlite3WindowCodeStep()
2969 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.start.reg, pOrderBy->nExpr-1); in sqlite3WindowCodeStep()
2970 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.current.reg, pOrderBy->nExpr-1); in sqlite3WindowCodeStep()
2971 sqlite3VdbeAddOp3(v, OP_Copy, regPeer, s.end.reg, pOrderBy->nExpr-1); in sqlite3WindowCodeStep()
2980 windowIfNewPeer(pParse, pOrderBy, regNewPeer, regPeer, lblWhereEnd); in sqlite3WindowCodeStep()