| /sqlite-3.40.0/test/ |
| H A D | vt02.c | 645 zLogTab, iBI, pInfo->nOrderBy in sqlite3BestIndexLog()
647 for(i=0; i<pInfo->nOrderBy; i++){ in sqlite3BestIndexLog()
710 if( pInfo->nOrderBy ){ in sqlite3BestIndexLog()
837 if( pInfo->nOrderBy>0 && (flags & VT02_NO_SORT_OPT)==0 ){ in vt02BestIndex()
850 for(i=0; i<pInfo->nOrderBy; i++){ in vt02BestIndex()
907 && (pInfo->nOrderBy==0 || pInfo->orderByConsumed) in vt02BestIndex()
|
| H A D | vtabdistinct.test | 33 WHERE +vn IN ('sqlite3_vtab_distinct','nOrderBy');
34 } {nOrderBy 2 sqlite3_vtab_distinct 2}
|
| H A D | window1.test | 990 proc do_ordercount_test {tn sql nOrderBy} {
992 uplevel [list do_test $tn [list regexp -all ORDER $plan] $nOrderBy]
|
| /sqlite-3.40.0/src/ |
| H A D | where.c | 1182 int nOrderBy; in allocateIndexInfo() local
1226 nOrderBy = 0; in allocateIndexInfo()
1268 nOrderBy = n; in allocateIndexInfo()
1344 for(i=j=0; i<nOrderBy; i++){ in allocateIndexInfo()
1354 pIdxInfo->nOrderBy = j; in allocateIndexInfo()
4729 int nOrderBy, in whereSortingCost() argument
4748 rScale = sqlite3LogEst((nOrderBy-nSorted)*100/nOrderBy) - 66; in whereSortingCost()
4815 nOrderBy = 0; in wherePathSolver()
4832 if( nOrderBy ){ in wherePathSolver()
4853 if( nOrderBy ){ in wherePathSolver()
[all …]
|
| H A D | dbstat.c | 266 if( ( pIdxInfo->nOrderBy==1 in statBestIndex()
270 ( pIdxInfo->nOrderBy==2 in statBestIndex()
|
| H A D | select.c | 2489 int nOrderBy = ALWAYS(pOrderBy!=0) ? pOrderBy->nExpr : 0; in multiSelectOrderByKeyInfo() local
2491 KeyInfo *pRet = sqlite3KeyInfoAlloc(db, nOrderBy+nExtra, 1); in multiSelectOrderByKeyInfo()
2494 for(i=0; i<nOrderBy; i++){ in multiSelectOrderByKeyInfo()
3435 int nOrderBy; /* Number of terms in the ORDER BY clause */ in multiSelectOrderBy() local
3453 nOrderBy = pOrderBy->nExpr; in multiSelectOrderBy()
3462 for(j=0, pItem=pOrderBy->a; j<nOrderBy; j++, pItem++){ in multiSelectOrderBy()
3467 if( j==nOrderBy ){ in multiSelectOrderBy()
3485 aPermute = sqlite3DbMallocRawNN(db, sizeof(u32)*(nOrderBy + 1)); in multiSelectOrderBy()
3488 aPermute[0] = nOrderBy; in multiSelectOrderBy()
3489 for(i=1, pItem=pOrderBy->a; i<=nOrderBy; i++, pItem++){ in multiSelectOrderBy()
[all …]
|
| H A D | dbpage.c | 153 if( pIdxInfo->nOrderBy>=1 in dbpageBestIndex()
|
| H A D | test_bestindex.c | 462 for(ii=0; ii<pIdxInfo->nOrderBy; ii++){ in testBestIndexObjOrderby()
|
| H A D | test8.c | 920 if( pIdxInfo->nOrderBy==1 && ( in echoBestIndex()
|
| H A D | sqlite.h.in | 7181 int nOrderBy; /* Number of terms in the ORDER BY clause */ member
9641 ** sort order defined by the "nOrderBy" and "aOrderBy" fields of the
|
| /sqlite-3.40.0/ext/fts3/ |
| H A D | fts3_term.c | 151 if( pInfo->nOrderBy ){ in fts3termBestIndexMethod()
153 for(i=0; i<pInfo->nOrderBy; i++){ in fts3termBestIndexMethod()
156 if( i==pInfo->nOrderBy ){ in fts3termBestIndexMethod()
|
| H A D | fts3_aux.c | 163 if( pInfo->nOrderBy==1 in fts3auxBestIndexMethod()
|
| H A D | fts3.c | 1721 if( pInfo->nOrderBy==1 ){ in fts3BestIndexMethod()
|
| /sqlite-3.40.0/ext/misc/ |
| H A D | qpvtab.c | 392 sqlite3_str_appendf(pStr, "nOrderBy,%d,,,,\n", pIdxInfo->nOrderBy); in qpvtabBestIndex()
393 for(i=0; i<pIdxInfo->nOrderBy; i++){ in qpvtabBestIndex()
|
| H A D | wholenumber.c | 217 if( pIdxInfo->nOrderBy==1 in wholenumberBestIndex()
|
| H A D | series.c | 389 if( pIdxInfo->nOrderBy>=1 && pIdxInfo->aOrderBy[0].iColumn==0 ){ in seriesBestIndex()
|
| H A D | closure.c | 904 if( pIdxInfo->nOrderBy==1 in closureBestIndex()
|
| H A D | fuzzer.c | 1132 if( pIdxInfo->nOrderBy==1 in fuzzerBestIndex()
|
| H A D | amatch.c | 1401 if( pIdxInfo->nOrderBy==1 in amatchBestIndex()
|
| H A D | spellfix.c | 2293 if( pIdxInfo->nOrderBy==1 in spellfix1BestIndex()
|
| /sqlite-3.40.0/ext/recover/ |
| H A D | dbdata.c | 237 if( pTab->bPtr==0 && pIdx->nOrderBy && pIdx->aOrderBy[0].desc==0 ){ in dbdataBestIndex()
239 if( pIdx->nOrderBy==1 ){ in dbdataBestIndex()
241 }else if( pIdx->nOrderBy==2 && pIdx->aOrderBy[1].desc==0 && iCol==0 ){ in dbdataBestIndex()
|
| /sqlite-3.40.0/ext/fts5/ |
| H A D | fts5_vocab.c | 312 if( pInfo->nOrderBy==1 in fts5VocabBestIndexMethod()
|
| H A D | fts5_main.c | 651 if( pInfo->nOrderBy==1 ){ in fts5BestIndexMethod()
|
| /sqlite-3.40.0/tool/ |
| H A D | fuzzershell.c | 643 if( pIdxInfo->nOrderBy==1 ){ in seriesBestIndex()
|
| /sqlite-3.40.0/ext/expert/ |
| H A D | sqlite3expert.c | 501 for(i=pIdxInfo->nOrderBy-1; i>=0; i--){ in expertBestIndex()
|