Home
last modified time | relevance | path

Searched refs:i2 (Results 1 – 25 of 120) sorted by relevance

12345

/sqlite-3.40.0/test/
H A Dexpr.test41 test_expr expr-1.1 {i1=10, i2=20} {i1+i2} 30
42 test_expr expr-1.2 {i1=10, i2=20} {i1-i2} -10
44 test_expr expr-1.4 {i1=10, i2=20} {i1/i2} 0
45 test_expr expr-1.5 {i1=10, i2=20} {i2/i1} 2
46 test_expr expr-1.6 {i1=10, i2=20} {i2<i1} 0
47 test_expr expr-1.7 {i1=10, i2=20} {i2<=i1} 0
48 test_expr expr-1.8 {i1=10, i2=20} {i2>i1} 1
49 test_expr expr-1.9 {i1=10, i2=20} {i2>=i1} 1
66 test_expr expr-1.24 {i1=1, i2=2} {min(i1,i2,i1+i2,i1-i2)} {-1}
67 test_expr expr-1.25 {i1=1, i2=2} {max(i1,i2,i1+i2,i1-i2)} {3}
[all …]
H A Dtt3_stress.c60 int i2 = 0; in stress_thread_3() local
66 if( err.rc ) i2++; in stress_thread_3()
72 return sqlite3_mprintf("read t1 %d/%d attempts", i2, i1); in stress_thread_3()
82 int i2 = 0; in stress_thread_4() local
96 if( err.rc ) i2++; in stress_thread_4()
102 return sqlite3_mprintf("wrote t1 %d/%d attempts", i2, i1); in stress_thread_4()
114 int i2 = 0; in stress_thread_5() local
125 if( err.rc ) i2++; in stress_thread_5()
289 int i2 = 0; in stress2_thread_wrapper() local
296 i2 += (err.rc==SQLITE_OK); in stress2_thread_wrapper()
[all …]
H A Dpragma.test375 } {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2}}
384 …i2} {row 2 missing from index i2} {wrong # of entries in index i2} {row 1 missing from index i2} {…
389 …} {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2} {r…
395 …} {0 {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2}…
403 …i2} {row 2 missing from index i2} {wrong # of entries in index i2} {row 1 missing from index i2} {…
438 … 6 is never used} {row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries …
441 } {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2}}
458 Page 6 is never used} {row 1 missing from index i2} {row 2 missing from index i2}}
493 … 6 is never used} {row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries …
1878 } {t1 i1 i2 i2x i3 t2}
[all …]
H A Dfuzzinvariants.c307 sqlite3_stmt *pS2, int i2, /* Value to test on the right */ in sameValue() argument
312 int t2 = sqlite3_column_type(pS2,i2); in sameValue()
324 x = sqlite3_column_int64(pS1,i1)==sqlite3_column_int64(pS2,i2); in sameValue()
328 x = sqlite3_column_double(pS1,i1)==sqlite3_column_double(pS2,i2); in sameValue()
333 int e2 = sqlite3_value_encoding(sqlite3_column_value(pS2,i2)); in sameValue()
336 const char *z2 = (const char*)sqlite3_column_text(pS2,i2); in sameValue()
343 sqlite3_bind_value(pTestCompare, 2, sqlite3_column_value(pS2,i2)); in sameValue()
352 int len2 = sqlite3_column_bytes16(pS2,i2); in sameValue()
353 const unsigned char *b2 = sqlite3_column_blob(pS2,i2); in sameValue()
368 int len2 = sqlite3_column_bytes(pS2,i2); in sameValue()
[all …]
H A Dexists.test99 sql1 { DROP INDEX IF EXISTS i2 }
100 sql2 { CREATE INDEX i2 ON t2(x) }
101 sql1 { DROP INDEX IF EXISTS i2 }
154 sql1 { DROP INDEX IF EXISTS aux.i2 }
155 sql2 { CREATE INDEX aux.i2 ON t2(x) }
156 sql1 { DROP INDEX IF EXISTS aux.i2 }
160 sql1 { DROP INDEX IF EXISTS i2 }
161 sql2 { CREATE INDEX aux.i2 ON t2(x) }
162 sql1 { DROP INDEX IF EXISTS i2 }
H A Deqp.test38 CREATE INDEX i2 ON t1(b);
51 | `--SEARCH t1 USING INDEX i2 (b=?)
63 `--SEARCH t1 USING INDEX i2 (b=?)
510 # 0|0|0|SEARCH t1 USING COVERING INDEX i2 (a=?)
540 # 0|0|0|SEARCH t1 USING COVERING INDEX i2 (a=?)
588 # 1|0|0|SCAN t1 USING COVERING INDEX i2
595 1 0 0 {SCAN t1 USING COVERING INDEX i2}
607 0 1 1 {SCAN t1 USING COVERING INDEX i2}
617 1 0 0 {SCAN t1 USING COVERING INDEX i2}
624 # 1|0|0|SCAN t1 USING COVERING INDEX i2
[all …]
H A Dpragma4.test171 CREATE INDEX aux.i2 ON t2(e);
175 do_execsql_test 4.3.3 { SELECT * FROM pragma_index_info('i2') } {0 1 e}
181 execsql { DROP INDEX i2 } db2
186 do_execsql_test 4.3.6 { SELECT * FROM pragma_index_info('i2') }
192 CREATE INDEX aux.i2 ON t2(e, f);
196 do_execsql_test 4.4.2 { SELECT * FROM pragma_index_list('t2') } {0 i2 0 c 0}
200 execsql { DROP INDEX i2 } db2
213 CREATE UNIQUE INDEX aux.i2 ON t2(d);
H A Dindexedby.test23 CREATE INDEX i2 ON t1(b);
134 SELECT * FROM t1 INDEXED BY i2 WHERE a = 'one' AND b = 'two'
135 } {SEARCH t1 USING INDEX i2 (b=?)}
137 catchsql { SELECT * FROM t1 INDEXED BY i2 WHERE a = 'one' }
140 catchsql { SELECT * FROM t1 INDEXED BY i2 ORDER BY a }
220 } {SEARCH t1 USING INDEX i2 (b=?)}
244 DELETE FROM t1 INDEXED BY i2 WHERE a = 5 AND b = 10
245 } {SEARCH t1 USING INDEX i2 (b=?)}
247 catchsql { DELETE FROM t1 INDEXED BY i2 WHERE a = 5}
265 UPDATE t1 INDEXED BY i2 SET rowid=rowid+1 WHERE a = 5 AND b = 10
[all …]
H A Dsubstr.test28 proc substr-test {id string i1 i2 result} {
35 SELECT substr(t, $i1, $i2) FROM t1
41 SELECT substring($qstr, $i1, $i2)
45 proc subblob-test {id hex i1 i2 hexresult} {
52 SELECT hex(substr(b, $i1, $i2)) FROM t1
57 SELECT hex(substring(x'$hex', $i1, $i2))
H A Dminmax3.test69 execsql { CREATE INDEX i2 ON t1(x,y) }
74 execsql { DROP INDEX i2 ; CREATE INDEX i2 ON t1(x, y DESC) }
89 execsql { DROP INDEX i1 ; DROP INDEX i2 }
98 # Index i2 optimizes the WHERE x='2' constraint and the min(y).
99 execsql { CREATE INDEX i2 ON t1(x,y) }
104 execsql { DROP INDEX i2 ; CREATE INDEX i2 ON t1(x, y DESC) }
110 execsql { DROP INDEX i1 ; DROP INDEX i2 }
H A Dcorrupt9.test82 CREATE INDEX i2 ON t2(b,a);
83 DROP INDEX i2;
103 CREATE INDEX i2 ON t2(b,a);
119 CREATE INDEX i2 ON t2(b,a);
134 CREATE INDEX i2 ON t2(b,a);
H A Dsort3.test27 set i2 2
30 set i1 [expr (($i2<<3) + $a) & 0x7FFFFFFF]
31 set i2 [expr (($i1<<3) + $b) & 0x7FFFFFFF]
33 list $i1 $i2
H A Dcorrupt8.test94 set i2 [expr {$i+1+$i%4}]
95 set oldval [hexio_read test.db $i2 1]
96 hexio_write test.db $i2 [format %02x [expr {($oldval+1)&0xff}]]
103 hexio_write test.db $i2 $oldval
H A DorderbyA.test109 2 { CREATE INDEX i2 ON t2(a, b) }
110 3 { CREATE INDEX i2 ON t2(a DESC, b DESC) }
112 4 { CREATE INDEX i2 ON t2(a, b DESC) }
113 5 { CREATE INDEX i2 ON t2(a DESC, b) }
115 execsql { DROP INDEX IF EXISTS i2 }
H A Dselect2.test69 set i2 [expr {$i*2}]
71 db eval {INSERT INTO tbl2 VALUES($i,$i2,$i3)}
84 set i2 [expr {$i*2}]
86 execsql "INSERT INTO tbl2 VALUES($i,$i2,$i3)"
H A Dunique.test91 CREATE UNIQUE INDEX i2 ON t2(a)
112 DROP INDEX i2;
128 CREATE UNIQUE INDEX i2 ON t2(a);
134 CREATE INDEX i2 ON t2(a);
H A Dwindowpushd.test74 CREATE INDEX i2 ON t1(b);
161 } {SEARCH t1 USING INDEX i2 (b=?)}
164 } {SEARCH t1 USING INDEX i2 (b>?)}
175 } {SCAN t1 USING INDEX i2}
H A Danalyze9.test99 CREATE INDEX i2 ON t2(a, b);
302 CREATE INDEX i2 ON t1(b);
395 CREATE INDEX i2 ON t1(e);
414 } {/t1 USING INDEX i2/}
422 } {/t1 USING INDEX i2/}
587 } {/SEARCH t1 USING INDEX i2/}
590 } {/SEARCH t1 USING INDEX i2/}
606 CREATE INDEX i2 ON t1(c);
853 ANALYZE main.i2;
860 } {/USING INDEX i2/}
[all …]
H A Dlike.test474 CREATE INDEX i2 ON t2(x COLLATE NOCASE);
480 } {abc ABC {ABC abc xyz} abcd nosort {} i2}
492 } {abc abcd nosort {} i2}
504 } {abc abcd nosort {} i2}
523 } {abc ABC {ABC abc xyz} abcd nosort {} i2}
535 } {ABC {ABC abc xyz} nosort {} i2}
547 } {ABC {ABC abc xyz} nosort {} i2}
572 } {zz-lower-lower zZ-lower-upper Zz-upper-lower ZZ-upper-upper nosort {} i2}
577 } {zz-lower-lower zZ-lower-upper Zz-upper-lower ZZ-upper-upper nosort {} i2}
710 regexp {INDEX i2} $res
[all …]
H A Dtemptable2.test113 CREATE INDEX i2 ON t2(a, b);
136 CREATE INDEX i2 ON t2(a, b);
190 CREATE INDEX i2 ON t2(a, b);
234 CREATE INDEX i2 ON t2(a, b);
297 CREATE INDEX i2 ON tx(b);
/sqlite-3.40.0/ext/misc/
H A Dspellfix.c1025 for(i2=0; i2<n2; i2++){ in editDist3Core()
1026 a2[i2].nByte = utf8Len((unsigned char)z2[i2], n2-i2); in editDist3Core()
1032 if( matchTo(p, z2+i2, n2-i2)==0 ) continue; in editDist3Core()
1040 a2[i2].apIns[a2[i2].nIns-1] = p; in editDist3Core()
1060 for(i2=0; i2<n2; i2 += b2){ in editDist3Core()
1087 if( matchFromTo(&f, i1, z2+i2, n2-i2) ){ in editDist3Core()
1093 if( matchTo(p, z2+i2, n2-i2) ){ in editDist3Core()
1110 for(i2=0; i2<n2; i2++){ in editDist3Core()
1111 printf("%c-%02x:", z2[i2], z2[i2]&0xff); in editDist3Core()
1125 for(i2=1; i2<=n2; i2++){ in editDist3Core()
[all …]
H A Dpercentile.c184 unsigned i1, i2; in percentFinal() local
194 i2 = ix==(double)i1 || i1==p->nUsed-1 ? i1 : i1+1; in percentFinal()
196 v2 = p->a[i2]; in percentFinal()
/sqlite-3.40.0/src/
H A Dtest_tclvar.c76 int i2; /* Current item (if any) in pList2 */ member
151 assert( pCur->i2==0 ); in next2()
154 pCur->i2++; in next2()
156 if( pCur->i2>=n ){ in next2()
159 pCur->i2 = 0; in next2()
242 pCur->i2 = 0; in tclvarFilter()
259 Tcl_ListObjIndex(interp, pCur->pList2, pCur->i2, &p2); in tclvarColumn()
/sqlite-3.40.0/ext/session/
H A Dsessionstat1.test239 CREATE INDEX i2 ON t1(b);
258 {INSERT sqlite_stat1 CONFLICT {t t1 t i2 t {3 1}} {t t1 t i2 t {2 1}}}
263 } {t1 i1 {2 1} t1 i2 {2 1}}
271 } {t1 i1 {3 1} t1 i2 {3 1}}
/sqlite-3.40.0/ext/rbu/
H A Drbu1.test175 CREATE INDEX i2 ON t1(c, b);
182 CREATE INDEX i2 ON t1(c, b);
355 CREATE INDEX i2 ON t1(c, b);
361 CREATE INDEX i2 ON t1(c, b);
367 CREATE INDEX i2 ON t1(c, b);
374 CREATE INDEX i2 ON t1(c, b);
380 CREATE INDEX i2 ON t1(c, b);
479 CREATE INDEX i2 ON t1(d, c);
488 CREATE INDEX i2 ON t1(d, c);
497 CREATE INDEX i2 ON t1(d, c);

12345