| /sqlite-3.40.0/test/ |
| H A D | tkt-38cb5df375.test | 39 LIMIT $::ii; 48 LIMIT $::ii; 57 LIMIT $::ii; 66 LIMIT $::ii; 75 LIMIT $::ii; 85 LIMIT $::ii; 94 LIMIT $::ii; 103 LIMIT $::ii; 112 LIMIT $::ii; 123 LIMIT $::ii; [all …]
|
| H A D | speed4p.explain | 107 for {set ii 0} {$ii < 50000} {incr ii} { 138 for {set ii 1} {$ii < 10000} {incr ii} { 153 for {set ii 1} {$ii < 10000} {incr ii} { 165 for {set ii 1} {$ii < 10000} {incr ii} { 199 for {set ii 1} {$ii < 10000} {incr ii} { 200 lappend list $ii [number_name $ii] 211 for {set ii 1} {$ii < 20000} {incr ii 2} { 226 for {set ii 1} {$ii < 20000} {incr ii 2} { 247 for {set ii 1} {$ii < 10000} {incr ii} { 259 for {set ii 1} {$ii < 20000} {incr ii 2} { [all …]
|
| H A D | speed4p.test | 107 for {set ii 0} {$ii < 50000} {incr ii} { 130 for {set ii 1} {$ii < 10000} {incr ii} { 144 for {set ii 1} {$ii < 10000} {incr ii} { 155 for {set ii 1} {$ii < 10000} {incr ii} { 170 for {set ii 1} {$ii < 10000} {incr ii} { 213 for {set ii 1} {$ii < 10000} {incr ii} { 224 for {set ii 1} {$ii < 20000} {incr ii 2} { 238 for {set ii 1} {$ii < 20000} {incr ii 2} { 258 for {set ii 1} {$ii < 10000} {incr ii} { 269 for {set ii 1} {$ii < 20000} {incr ii 2} { [all …]
|
| H A D | speed4.test | 104 for {set ii 0} {$ii < 50000} {incr ii} { 133 for {set ii 1} {$ii < 10000} {incr ii} { 144 for {set ii 1} {$ii < 10000} {incr ii} { 152 for {set ii 1} {$ii < 10000} {incr ii} { 179 for {set ii 1} {$ii < 10000} {incr ii} { 180 append sql "INSERT INTO t4 VALUES(NULL, $ii, '[number_name $ii]');" 184 for {set ii 1} {$ii < 20000} {incr ii 2} { 192 for {set ii 1} {$ii < 20000} {incr ii 2} { 211 for {set ii 1} {$ii < 10000} {incr ii} { 216 for {set ii 1} {$ii < 20000} {incr ii 2} { [all …]
|
| H A D | thread002.test | 31 for {set ii 0} {$ii < 3} {incr ii} { 32 forcedelete test${ii}.db 33 sqlite3 db test${ii}.db 45 for {set ii 1} {$ii <= 3} {incr ii} { 46 set T [lindex $order [expr $ii-1]] 47 execsql "ATTACH 'test${T}.db' AS aux${ii}" 50 for {set ii 0} {$ii < 100} {incr ii} { 74 for {set ii 0} {$ii < $::NTHREAD} {incr ii} { 91 for {set ii 0} {$ii < 3} {incr ii} { 92 do_test thread002.3.$ii { [all …]
|
| H A D | selectB.test | 59 for {set ii 1} {$ii <= 2} {incr ii} { 61 if {$ii == 2} { 197 for {set ii 3} {$ii <= 6} {incr ii} { 199 switch $ii { 221 do_test selectB-$ii.1 { 229 do_test selectB-$ii.2 { 236 do_test selectB-$ii.3 { 243 do_test selectB-$ii.4 { 252 do_test selectB-$ii.5 { 259 do_test selectB-$ii.6 { [all …]
|
| H A D | in2.test | 29 for {set ::ii 0} {$::ii < $::N} {incr ::ii} { 30 execsql {INSERT INTO a VALUES($::ii, $::ii)} 34 for {set ::ii 0} {$::ii < $::N} {incr ::ii} { 35 set ::t [format "x%04d" $ii] 45 # $::ii integers. 59 for {set ::ii 3} {$::ii < $::N} {incr ::ii} { 60 do_test in2-$::ii { 62 SELECT 1 IN (SELECT a FROM a WHERE (i < $::ii) OR (i >= $::N))
|
| H A D | crash6.test | 24 for {set ii 0} {$ii < 10} {incr ii} { 38 integrity_check crash6-1.$ii 41 for {set ii 0} {$ii < 10} {incr ii} { 57 integrity_check crash6-2.$ii 67 for {set ii 0} {$ii < 30} {incr ii} { 72 set pagesize [expr 1024 << ($ii % 4)] 76 do_test crash6-3.$ii.0 { 81 do_test crash6-3.$ii.1 { 102 do_test crash6-3.$ii.2 { 105 SELECT random() FROM abc LIMIT $ii; [all …]
|
| H A D | unionall.test | 130 2 two 2 ii 2 TWO 2 ii 3 three 3 iii 3 THREE 3 iii 138 2 two 2 ii 2 TWO 2 ii 3 three 3 iii 3 THREE 3 iii 153 2 TWO 2 ii 155 2 two 2 ii 161 2 TWO 2 ii 163 2 two 2 ii 192 1 one 2 ii 1 ONE 2 ii 2 two 2 ii 193 2 TWO 2 ii 3 three 2 ii 3 THREE 2 ii 208 1 one 2 ii 1 ONE 2 ii 2 two 2 ii 209 2 TWO 2 ii 3 three 2 ii 3 THREE 2 ii [all …]
|
| /sqlite-3.40.0/ext/fts3/ |
| H A D | fts3_test.c | 64 int ii; in nm_phrase_match() local 66 for(ii=0; ii<p->nToken; ii++){ in nm_phrase_match() 90 int ii; in nm_near_chain() local 115 for(ii=iStart; ii<=iStop; ii++){ in nm_near_chain() 134 for(ii=0; ii<(pDoc->nToken + 1 - p->nToken); ii++){ in nm_match_count() 181 for(ii=3; ii<objc; ii+=2){ in fts3_near_match_cmd() 207 for(ii=0; ii<doc.nToken; ii++){ in fts3_near_match_cmd() 208 doc.aToken[ii].z = Tcl_GetStringFromObj(apDocToken[ii], &doc.aToken[ii].n); in fts3_near_match_cmd() 217 for(ii=0; ii<nPhrase; ii++){ in fts3_near_match_cmd() 236 for(ii=1; ii<nPhrase; ii++){ in fts3_near_match_cmd() [all …]
|
| H A D | fts3_expr.c | 313 int ii; in getNextString() local 314 for(ii=0; rc==SQLITE_OK; ii++){ in getNextString() 410 int ii; in getNextNode() local 433 for(ii=0; ii<(int)(sizeof(aKeyword)/sizeof(struct Fts3Keyword)); ii++){ in getNextNode() 484 for(ii=1; ii<nInput && zInput[ii]!='"'; ii++); in getNextNode() 486 if( ii==nInput ){ in getNextNode() 525 for(ii=0; ii<pParse->nCol; ii++){ in getNextNode() 531 iCol = ii; in getNextNode() 1191 int ii; in fts3ExprTestCommon() local 1225 for(ii=0; ii<nCol; ii++){ in fts3ExprTestCommon() [all …]
|
| /sqlite-3.40.0/ext/rtree/ |
| H A D | rtree2.test | 47 CREATE TABLE t2 (ii, $cols); 53 for {set ii 0} {$ii < $::NROW} {incr ii} { 54 #puts "Row $ii" 64 incr ii -1 88 for {set ii 0} {$ii < $::NSELECT} {incr ii} { 89 do_test rtree2-$module.$nDim.4.$ii.1 { 94 set col ii 120 for {set ii 0} {$ii < $::NROW} {incr ii $::NDEL} { 122 do_test rtree2-$module.$nDim.5.$ii.1 { 123 execsql "DELETE FROM t2 WHERE ii <= $::ii" [all …]
|
| H A D | rtree.c | 818 for(ii=0; ii<pRtree->nDim2; ii++){ in nodeOverwriteCell() 1366 for(ii=0; ii<nCell; ii++){ in nodeRowidIndex() 1892 for(ii=0; ii<argc; ii++){ in rtreeFilter() 2173 for(ii=0; ii<nCell; ii++){ in cellOverlap() 2542 for(ii=0; ii<nCell; ii++){ in splitNodeStartree() 2820 for(ii=1; ii<nCell; ii++){ in fixBoundingBox() 2908 for(ii=0; ii<nCell; ii++){ in Reinsert() 2924 for(ii=0; ii<nCell; ii++){ in Reinsert() 3267 for(ii=0; ii<nn; ii+=2){ in rtreeUpdate() 3278 for(ii=0; ii<nn; ii+=2){ in rtreeUpdate() [all …]
|
| H A D | test_rtreedoc.c | 61 int ii; in invokeTclGeomCb() local 73 for(ii=0; ii<p->nParam; ii++){ in invokeTclGeomCb() 81 for(ii=0; ii<nCoord; ii++){ in invokeTclGeomCb() 151 int ii; in box_geom() local 159 for(ii=0; ii<nCoord; ii+=2){ in box_geom() 160 if( aCoord[ii]>p->aParam[ii+1] || aCoord[ii+1]<p->aParam[ii] ){ in box_geom() 211 int ii; in box_query() local 221 for(ii=0; ii<pInfo->nParam; ii++){ in box_query() 222 Tcl_Obj *p = Tcl_NewDoubleObj(pInfo->aParam[ii]); in box_query() 232 for(ii=0; ii<pInfo->nCoord; ii++){ in box_query() [all …]
|
| H A D | rtree1.test | 200 execsql { SELECT ii FROM t1 ORDER BY ii } 213 execsql { SELECT ii FROM t1 ORDER BY ii } 263 SELECT * FROM t2 ORDER BY ii; 268 DELETE FROM t2 WHERE ii=2; 269 SELECT * FROM t2 ORDER BY ii; 274 DELETE FROM t2 WHERE ii=1; 275 SELECT * FROM t2 ORDER BY ii; 280 DELETE FROM t2 WHERE ii=3; 281 SELECT * FROM t2 ORDER BY ii; 302 execsql { UPDATE t3 SET ii = 2 } [all …]
|
| H A D | geopoly.c | 329 for(ii=0; ii<nVertex; ii++){ in geopolyFuncParam() 464 int ii; in geopolyXformFunc() local 466 for(ii=0; ii<p->nVertex; ii++){ in geopolyXformFunc() 489 int ii; in geopolyArea() local 490 for(ii=0; ii<p->nVertex-1; ii++){ in geopolyArea() 543 for(ii=1, jj=p->nVertex-1; ii<jj; ii++, jj--){ in geopolyCcwFunc() 649 for(ii=1; ii<p->nVertex; ii++){ in geopolyBBox() 817 int ii; in geopolyContainsPointFunc() local 819 for(ii=0; ii<p1->nVertex-1; ii++){ in geopolyContainsPointFunc() 1266 for(ii=3; ii<argc; ii++){ in geopolyInit() [all …]
|
| H A D | rtree3.test | 61 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2); 64 DELETE FROM rt WHERE ii = 1; 66 SELECT ii FROM rt WHERE ii = 2; 74 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2); 98 for {set ii 0} {$ii < 100} {incr ii} { 110 for {set ii 0} {$ii < 100} {incr ii} { 122 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2); 142 db eval { DELETE FROM rt WHERE ii BETWEEN 1 AND 100 } 152 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2); 188 execsql { DELETE FROM rt WHERE ii=$i } [all …]
|
| H A D | rtree_util.tcl | 37 set ii $iNode 38 while {$ii != 1} { 39 set sql "SELECT parentnode FROM ${zTab}_parent WHERE nodeno = $ii" 40 set ii [db one $sql] 64 for {set ii 0} {$ii < $nCell} {incr ii} { 66 set newval [format "%.${iPrec}f" [lindex $node $ii $jj]] 67 lset node $ii $jj $newval 154 for {set ii 1} {$ii <= $nDim*2} {incr ii} { 155 set f [lindex $node 0 $ii] 157 set f2 [lindex $cell $ii]
|
| /sqlite-3.40.0/tool/ |
| H A D | speedtest8inst1.c | 76 int ii; in stringcompare() local 77 for(ii=0; zLeft[ii] && zRight[ii]; ii++){ in stringcompare() 78 if( zLeft[ii]!=zRight[ii] ) return 0; in stringcompare() 80 return( zLeft[ii]==zRight[ii] ); in stringcompare() 143 int ii; in main() local 154 for(ii=1; ii<argc; ii++){ in main() 155 if( stringcompare("-db", argv[ii]) && (ii+1)<argc ){ in main() 156 zDb = argv[++ii]; in main() 159 else if( stringcompare("-script", argv[ii]) && (ii+1)<argc ){ in main() 163 else if( stringcompare("-log", argv[ii]) && (ii+1)<argc ){ in main() [all …]
|
| /sqlite-3.40.0/src/ |
| H A D | test_bestindex.c | 283 int ii; in tclFilter() local 298 for(ii=0; ii<argc; ii++){ in tclFilter() 346 for(ii=0; rc==SQLITE_OK && ii<nElem; ii+=2){ in tclFilter() 395 int ii; in testBestIndexObjConstraints() local 398 for(ii=0; ii<pIdxInfo->nConstraint; ii++){ in testBestIndexObjConstraints() 459 int ii; in testBestIndexObjOrderby() local 462 for(ii=0; ii<pIdxInfo->nOrderBy; ii++){ in testBestIndexObjOrderby() 513 int ii; in testBestIndexObj() local 537 switch( ii ){ in testBestIndexObj() 642 int ii; in tclBestIndex() local [all …]
|
| H A D | test8.c | 184 int ii; in getColumnNames() local 193 for(ii=0; ii<nCol; ii++){ in getColumnNames() 211 for(ii=0; ii<nCol; ii++){ in getColumnNames() 212 aCol[ii] = zSpace; in getColumnNames() 657 int ii; in hashString() local 658 for(ii=0; zString[ii]; ii++){ in hashString() 804 int ii; in echoBestIndex() local 859 for(ii=0; ii<pIdxInfo->nConstraint; ii++){ in echoBestIndex() 944 for( ii=0; ii<(sizeof(int)*8)-1; ii++ ){ in echoBestIndex() 1030 int ii; in echoUpdate() local [all …]
|
| /sqlite-3.40.0/ext/recover/ |
| H A D | sqlite3recover.c | 1313 for(ii=0; ii<nField; ii++){ in recoverInsertStmt() 1447 for(ii=0; ii<nTotal; ii++){ in recoverLostAndFoundInsert() 1455 for(ii=0; ii<nTotal; ii++){ in recoverLostAndFoundInsert() 1538 for(ii=0; ii<nVal; ii++){ in recoverLostAndFoundOnePage() 1547 for(ii=0; ii<nVal; ii++){ in recoverLostAndFoundOnePage() 1577 for(ii=0; ii<nVal; ii++){ in recoverLostAndFoundOnePage() 1700 for(ii=0; ii<p1->nVal; ii++){ in recoverWriteDataCleanup() 1780 for(ii=0; ii<pTab->nCol; ii++){ in recoverWriteDataStep() 1804 for(ii=0; ii<p1->nVal; ii++){ in recoverWriteDataStep() 2115 for(ii=0; ii<nCell; ii++){ in recoverIsValidPage() [all …]
|
| /sqlite-3.40.0/ext/fts5/test/ |
| H A D | fts5synonym.test | 183 3 {5 i 5 2 four 4 1} {iii ii five two 1} 184 4 {ii four 4 one 5 three five} {one 5 1 iii 4 3} 186 6 {4 2 ii two 2 iii} {three 1 four 4 iv 1 iv} 187 7 {ii ii two three 2 5} {iii i ii iii iii one one} 188 8 {2 ii i two 3 three 2} {two iv v iii 3 five} 200 3 {5 [i] 5 2 four 4 [1]} {iii ii five two [1]} 204 7 {ii ii two three 2 5} {iii [i] ii iii iii [one] [one]} 224 7 {[ii] [ii] [two] [three] [2] [5]} {[iii] [i] [ii] [iii] [iii] [one] [one]} 231 3 {[5 i] 5 2 four 4 1} {iii ii five two 1} 237 7 {ii ii two three 2 5} {iii [i ii iii] iii one one} [all …]
|
| H A D | fts5synonym2.test | 58 INSERT INTO ss VALUES('9 ii six 8 1 6', 'six 4 iv iv 7'); 59 INSERT INTO ss VALUES('1 5 4 eight ii iv iii', 'nine 2 eight ix v vii'); 68 INSERT INTO ss VALUES('3 ii vii vi eight', '8 4 ix one three eight'); 72 INSERT INTO ss VALUES('iv vii three 3 9 one 8', '2 ii 6 eight ii six six'); 75 INSERT INTO ss VALUES('4 0 eight 0 0', '1 four one vii seven ii'); 78 INSERT INTO ss VALUES('7 ix four 8 vii', 'nine three nine ii ix vii'); 84 INSERT INTO ss VALUES('viii 8 iii i ii 8 3', '4 2 7 v 8 8'); 92 INSERT INTO ss VALUES('8 6 iv six ii', 'iv 6 3 4 ii five'); 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 D | fts5multi.test | 28 INSERT INTO t1 VALUES('gg bb bb' ,'gg ff gg' ,'ii ii'); 31 INSERT INTO t1 VALUES('hh' ,'bb jj cc' ,'kk ii'); 32 INSERT INTO t1 VALUES('kk dd kk ii','aa ee aa' ,'ee'); 40 INSERT INTO t1 VALUES('ff aa cc jj','kk' ,'ii dd'); 41 INSERT INTO t1 VALUES('jj dd' ,'cc' ,'ii hh ee aa'); 42 INSERT INTO t1 VALUES('ff ii hh' ,'dd' ,'gg'); 45 INSERT INTO t1 VALUES('ii' ,'bb ii' ,'jj kk'); 48 INSERT INTO t1 VALUES('dd kk' ,'ii gg' ,'dd'); 49 INSERT INTO t1 VALUES('cc' ,'aa ff' ,'ii'); 50 INSERT INTO t1 VALUES('bb ff bb ii','bb kk bb aa','hh ff ii dd'); [all …]
|