Lines Matching refs:pSort
133836 SortCtx *pSort,
133841 int nOBSat = pSort->nOBSat;
133844 if( pSort->pDeferredRowLoad ){
133845 innerLoopLoadRow(pParse, pSelect, pSort->pDeferredRowLoad);
133857 SortCtx *pSort, /* Information about the ORDER BY clause */
133865 int bSeq = ((pSort->sortFlags & SORTFLAG_UseSorter)==0);
133866 int nExpr = pSort->pOrderBy->nExpr; /* No. of ORDER BY terms */
133870 int nOBSat = pSort->nOBSat; /* ORDER BY terms to skip */
133901 pSort->labelDone = sqlite3VdbeMakeLabel(pParse);
133902 sqlite3ExprCodeExprList(pParse, pSort->pOrderBy, regBase, regOrigData,
133905 sqlite3VdbeAddOp2(v, OP_Sequence, pSort->iECursor, regBase+nExpr);
133918 regRecord = makeSorterRecord(pParse, pSort, pSelect, regBase, nBase);
133920 pParse->nMem += pSort->nOBSat;
133921 nKey = nExpr - pSort->nOBSat + bSeq;
133925 addrFirst = sqlite3VdbeAddOp1(v, OP_SequenceTest, pSort->iECursor);
133928 sqlite3VdbeAddOp3(v, OP_Compare, regPrevKey, regBase, pSort->nOBSat);
133929 pOp = sqlite3VdbeGetOp(v, pSort->addrSortIndex);
133936 pOp->p4.pKeyInfo = sqlite3KeyInfoFromExprList(pParse,pSort->pOrderBy,nOBSat,
133941 pSort->labelBkOut = sqlite3VdbeMakeLabel(pParse);
133942 pSort->regReturn = ++pParse->nMem;
133943 sqlite3VdbeAddOp2(v, OP_Gosub, pSort->regReturn, pSort->labelBkOut);
133944 sqlite3VdbeAddOp1(v, OP_ResetSorter, pSort->iECursor);
133946 sqlite3VdbeAddOp2(v, OP_IfNot, iLimit, pSort->labelDone);
133950 sqlite3ExprCodeMove(pParse, regBase, regPrevKey, pSort->nOBSat);
133969 int iCsr = pSort->iECursor;
133979 regRecord = makeSorterRecord(pParse, pSort, pSelect, regBase, nBase);
133981 if( pSort->sortFlags & SORTFLAG_UseSorter ){
133986 sqlite3VdbeAddOp4Int(v, op, pSort->iECursor, regRecord,
133990 pSort->labelOBLopt ? pSort->labelOBLopt : sqlite3VdbeCurrentAddr(v));
134189 SortCtx *pSort, /* Sorter context */
134210 if( pSort->aDefer[j].iCsr==pExpr->iTable ) break;
134213 if( nDefer==ArraySize(pSort->aDefer) ){
134233 pSort->aDefer[nDefer].pTab = pExpr->y.pTab;
134234 pSort->aDefer[nDefer].iCsr = pExpr->iTable;
134235 pSort->aDefer[nDefer].nKey = nKey;
134243 pSort->nDefer = (u8)nDefer;
134261 SortCtx *pSort, /* If not NULL, info on how to process ORDER BY */
134287 if( pSort && pSort->pOrderBy==0 ) pSort = 0;
134288 if( pSort==0 && !hasDistinct ){
134298 if( pSort ){
134299 nPrefixReg = pSort->pOrderBy->nExpr;
134300 if( !(pSort->sortFlags & SORTFLAG_UseSorter) ) nPrefixReg++;
134334 if( pSort && hasDistinct==0 && eDest!=SRT_EphemTab && eDest!=SRT_Table ){
134343 for(i=pSort->nOBSat; i<pSort->pOrderBy->nExpr; i++){
134345 if( (j = pSort->pOrderBy->a[i].u.x.iOrderByCol)>0 ){
134346 p->pEList->a[j-1].u.x.iOrderByCol = i+1-pSort->nOBSat;
134350 selectExprDefer(pParse, pSort, p->pEList, &pExtra);
134357 VdbeOp *pOp = sqlite3VdbeGetOp(v, pSort->addrSortIndex);
134358 pOp->p2 += (pExtra->nExpr - pSort->nDefer);
134359 pOp->p4.pKeyInfo->nAllField += (pExtra->nExpr - pSort->nDefer);
134398 assert( pSort!=0 );
134400 pSort->pDeferredRowLoad = &sRowLoadInfo;
134417 if( pSort==0 ){
134469 assert( pSort==0 );
134472 if( pSort ){
134474 pushOntoSorter(pParse, pSort, p, r1+nPrefixReg, regOrig, 1, nPrefixReg);
134487 if( pSort ){
134489 pParse, pSort, p, regResult, regOrig, nResultCol, nPrefixReg);
134516 if( pSort ){
134522 pParse, pSort, p, regResult, regOrig, nResultCol, nPrefixReg);
134548 if( pSort ){
134551 pParse, pSort, p, regResult, regOrig, nResultCol, nPrefixReg);
134565 if( pSort ){
134566 pushOntoSorter(pParse, pSort, p, regResult, regOrig, nResultCol,
134642 if( pSort==0 && p->iLimit ){
134792 SortCtx *pSort, /* Information on the ORDER BY clause */
134797 int addrBreak = pSort->labelDone; /* Jump here to exit loop */
134802 ExprList *pOrderBy = pSort->pOrderBy;
134816 if( pSort->labelBkOut ){
134817 sqlite3VdbeAddOp2(v, OP_Gosub, pSort->regReturn, pSort->labelBkOut);
134819 sqlite3VdbeResolveLabel(v, pSort->labelBkOut);
134824 for(i=0; i<pSort->nDefer; i++){
134825 Table *pTab = pSort->aDefer[i].pTab;
134827 sqlite3OpenTable(pParse, pSort->aDefer[i].iCsr, iDb, pTab, OP_OpenRead);
134828 nRefKey = MAX(nRefKey, pSort->aDefer[i].nKey);
134832 iTab = pSort->iECursor;
134845 nKey = pOrderBy->nExpr - pSort->nOBSat;
134846 if( pSort->sortFlags & SORTFLAG_UseSorter ){
134849 if( pSort->labelBkOut ){
134873 if( pSort->nDefer ){
134877 for(i=0; i<pSort->nDefer; i++){
134878 int iCsr = pSort->aDefer[i].iCsr;
134879 Table *pTab = pSort->aDefer[i].pTab;
134880 int nKey = pSort->aDefer[i].nKey;
134976 if( pSort->sortFlags & SORTFLAG_UseSorter ){
134981 if( pSort->regReturn ) sqlite3VdbeAddOp1(v, OP_Return, pSort->regReturn);
157325 ExprList *pSort = 0;
157357 pSort = exprListAppendList(pParse, 0, pMWin->pPartition, 1);
157358 pSort = exprListAppendList(pParse, pSort, pMWin->pOrderBy, 1);
157359 if( pSort && p->pOrderBy && p->pOrderBy->nExpr<=pSort->nExpr ){
157360 int nSave = pSort->nExpr;
157361 pSort->nExpr = p->pOrderBy->nExpr;
157362 if( sqlite3ExprListCompare(pSort, p->pOrderBy, -1)==0 ){
157366 pSort->nExpr = nSave;
157423 pParse, pSublist, pSrc, pWhere, pGroupBy, pHaving, pSort, 0, 0