Home
last modified time | relevance | path

Searched refs:ix (Results 1 – 22 of 22) sorted by relevance

/sqlite-3.40.0/test/
H A Dskipscan6.test38 CREATE INDEX ix on t1(aa, bb, cc, dd DESC);
40 INSERT INTO sqlite_stat1 VALUES('t1','ix','2695116 1347558 264 18 2');
41 …INSERT INTO sqlite_stat4 VALUES('t1','ix','2677151 196859 196859 32 1','0 15043 15043 92468 92499'…
42 …INSERT INTO sqlite_stat4 VALUES('t1','ix','2677151 14687 161 1 1','0 289067 299306 299457 299457',…
43 …INSERT INTO sqlite_stat4 VALUES('t1','ix','2677151 19313 19308 22 1','0 325815 325815 343725 34374…
44 …INSERT INTO sqlite_stat4 VALUES('t1','ix','2677151 25047 9051 15 1','0 350443 350443 356590 356604…
45 …INSERT INTO sqlite_stat4 VALUES('t1','ix','2677151 42327 9906 7 1','0 376381 376381 380291 380297'…
47 …INSERT INTO sqlite_stat4 VALUES('t1','ix','2677151 18730 18724 15 1','0 479663 479663 498271 49828…
49 …INSERT INTO sqlite_stat4 VALUES('t1','ix','2677151 1454 1454 1 1','0 898346 898346 898373 898373',…
74 } {/INDEX ix .aa=. AND bb=../}
[all …]
H A Dvtabdistinct.test26 SELECT ix FROM qpvtab WHERE vn='sqlite3_vtab_distinct';
29 SELECT DISTINCT ix FROM qpvtab WHERE vn='sqlite3_vtab_distinct';
32 SELECT distinct vn, ix FROM qpvtab(3)
36 SELECT vn, ix FROM qpvtab
H A Dshared8.test28 array set R {1 i 2 ii 3 iii 4 iv 5 v 6 vi 7 vii 8 viii 9 ix 10 x}
H A Dpager1.test1998 ia, ib, ic, id, ie, if, ig, ih, ii, ij, ik, il, im, ix,
2012 ia, ib, ic, id, ie, if, ig, ih, ii, ij, ik, il, im, ix,
H A Dfts1porter.test11165 ix ix
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5synonym2.test68 INSERT INTO ss VALUES('3 ii vii vi eight', '8 4 ix one three eight');
71 INSERT INTO ss VALUES('0 i iii nine 3 ix five', '0 eight iv 0 six 2');
78 INSERT INTO ss VALUES('7 ix four 8 vii', 'nine three nine ii ix vii');
79 INSERT INTO ss VALUES('nine iv v i 0 v', 'two iv vii six i ix 4');
81 INSERT INTO ss VALUES('six ii 5 nine 4 viii seven', 'eight i ix ix 7 four');
86 INSERT INTO ss VALUES('0 seven v five i five v', 'one 4 2 ix 9');
88 INSERT INTO ss VALUES('five 5 7 4 6 vii', 'three 2 ix 2 8 6');
90 INSERT INTO ss VALUES('vi vi iv 3 0 one one', '9 6 eight ix iv');
95 INSERT INTO ss VALUES('iii ii ix iv three', 'vi i 6 1 two');
97 INSERT INTO ss VALUES('iii seven five ix 8', 'ii 7 seven 0 four ii');
[all …]
H A Dfts5update.test25 "eight zero iv eight 7" "ix one 8 one three ii one"
26 "1 9 9 three viii" "5 zero ii 6 nine ix 3"
31 "one v 4 zero 4 iii ii" "2 3 eight six ix"
32 "six iv 7 three 5" "ix zero 0 8 ii 7 3"
H A Dfts5_common.tcl630 {nine 9 ix}
H A Dfts5porter.test5590 iwis iwi ix ix
H A Dfts5corrupt3.test11378 | 3088: b6 fc 53 9f bb 38 69 78 07 50 8c 77 cb d1 89 e2 ..S..8ix.P.w....
/sqlite-3.40.0/ext/misc/
H A Dpercentile.c186 double ix, vx; in percentFinal() local
192 ix = (p->rPct-1.0)*(p->nUsed-1)*0.01; in percentFinal()
193 i1 = (unsigned)ix; in percentFinal()
194 i2 = ix==(double)i1 || i1==p->nUsed-1 ? i1 : i1+1; in percentFinal()
197 vx = v1 + (v2-v1)*(ix-i1); in percentFinal()
/sqlite-3.40.0/tool/
H A Dshowshm.c105 static void print_index_hdr(unsigned char *aData, int ix){ in print_index_hdr() argument
107 assert( ix==0 || ix==1 ); in print_index_hdr()
108 i = ix ? 48 : 0; in print_index_hdr()
H A Dmksourceid.c484 int ix; in DigestToBase16() local
486 for(ix=0; ix<nByte; ix++){ in DigestToBase16()
/sqlite-3.40.0/src/
H A Dinsert.c1550 *pIx = pIter->u.ax.aIdx[0].ix; in indexIteratorFirst()
1566 *pIx = pIter->u.ax.aIdx[i].ix; in indexIteratorNext()
1686 int ix; /* Index loop counter */ in sqlite3GenerateConstraintChecks() local
1951 sIdxIter.u.ax.aIdx[i].ix = jj; in sqlite3GenerateConstraintChecks()
1957 sIdxIter.u.ax.aIdx[i].ix = jj; in sqlite3GenerateConstraintChecks()
2159 for(pIdx = indexIteratorFirst(&sIdxIter, &ix); in sqlite3GenerateConstraintChecks()
2161 pIdx = indexIteratorNext(&sIdxIter, &ix) in sqlite3GenerateConstraintChecks()
2182 iThisCur = iIdxCur+ix; in sqlite3GenerateConstraintChecks()
2187 sqlite3VdbeAddOp2(v, OP_Null, 0, aRegIdx[ix]); in sqlite3GenerateConstraintChecks()
2197 regIdx = aRegIdx[ix]+1; in sqlite3GenerateConstraintChecks()
[all …]
H A Dvdbemem.c683 i64 ix; in sqlite3VdbeIntegerAffinity() local
690 ix = doubleToInt64(pMem->u.r); in sqlite3VdbeIntegerAffinity()
702 if( pMem->u.r==ix && ix>SMALLEST_INT64 && ix<LARGEST_INT64 ){ in sqlite3VdbeIntegerAffinity()
703 pMem->u.i = ix; in sqlite3VdbeIntegerAffinity()
778 sqlite3_int64 ix; in sqlite3VdbeMemNumerify() local
782 if( ((rc==0 || rc==1) && sqlite3Atoi64(pMem->z, &ix, pMem->n, pMem->enc)<=1) in sqlite3VdbeMemNumerify()
783 || sqlite3RealSameAsInt(pMem->u.r, (ix = sqlite3RealToI64(pMem->u.r))) in sqlite3VdbeMemNumerify()
785 pMem->u.i = ix; in sqlite3VdbeMemNumerify()
H A Dbtree.c5265 pCur->ix = 0; in moveToChild()
5402 pCur->ix = 0; in moveToRoot()
6081 idx = ++pCur->ix; in btreeNext()
6122 pCur->ix--; in sqlite3BtreeNext()
6191 pCur->ix--; in btreePrevious()
6208 || pCur->ix==0 in sqlite3BtreePrevious()
6213 pCur->ix--; in sqlite3BtreePrevious()
9181 idx = pCur->ix; in sqlite3BtreeInsert()
9225 idx = ++pCur->ix; in sqlite3BtreeInsert()
10122 pCur->ix++; in sqlite3BtreeCount()
[all …]
H A Dprintf.c499 int ix = (length - 1)%3 + 1; in sqlite3_str_vappendf() local
503 ix--; in sqlite3_str_vappendf()
504 if( ix==0 ){ in sqlite3_str_vappendf()
507 ix = 3; in sqlite3_str_vappendf()
H A DbtreeInt.h546 u16 ix; /* Current index for apPage[iPage] */ member
H A DwhereInt.h405 int ix[BMS]; /* Cursor assigned to each bit */ member
H A Dwhere.c243 assert( pMaskSet->n>0 || pMaskSet->ix[0]<0 ); in sqlite3WhereGetMask()
245 if( pMaskSet->ix[0]==iCursor ){ in sqlite3WhereGetMask()
249 if( pMaskSet->ix[i]==iCursor ){ in sqlite3WhereGetMask()
289 assert( pMaskSet->n < ArraySize(pMaskSet->ix) ); in createMask()
290 pMaskSet->ix[pMaskSet->n++] = iCursor; in createMask()
5248 assert( pWInfo->sMaskSet.n==1 && iCur==pWInfo->sMaskSet.ix[0] ); in whereShortCut()
5713 pMaskSet->ix[0] = -99; /* Initialize ix[0] to a value that can never be in sqlite3WhereBegin()
H A Dvdbe.c450 sqlite3_int64 ix; in computeNumericType() local
459 if( rc==0 && sqlite3Atoi64(pMem->z, &ix, pMem->n, pMem->enc)<=1 ){ in computeNumericType()
460 pMem->u.i = ix; in computeNumericType()
465 }else if( rc==1 && sqlite3Atoi64(pMem->z, &ix, pMem->n, pMem->enc)==0 ){ in computeNumericType()
466 pMem->u.i = ix; in computeNumericType()
/sqlite-3.40.0/contrib/
H A Dsqlitecon.tcl440 scan [$w index insert] %d.%d ix iy
552 scan [$w index insert] %d.%d ix iy