Home
last modified time | relevance | path

Searched refs:i1 (Results 1 – 25 of 240) sorted by relevance

12345678910

/sqlite-3.40.0/test/
H A Dexpr.test41 test_expr expr-1.1 {i1=10, i2=20} {i1+i2} 30
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
48 test_expr expr-1.8 {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}
68 test_expr expr-1.26 {i1=1, i2=2} {max(i1,i2,i1+i2,i1-i2)} {3}
80 test_expr expr-1.38 {i1=1} {-i1} {-1}
81 test_expr expr-1.39 {i1=1} {+i1} {1}
[all …]
H A Dicu.test42 test_expr icu-1.1 {i1='hello'} {i1 REGEXP 'hello'} 1
43 test_expr icu-1.2 {i1='hello'} {i1 REGEXP '.ello'} 1
44 test_expr icu-1.3 {i1='hello'} {i1 REGEXP '.ell'} 0
45 test_expr icu-1.4 {i1='hello'} {i1 REGEXP '.ell.*'} 1
46 test_expr icu-1.5 {i1=NULL} {i1 REGEXP '.ell.*'} {}
65 test_expr icu-2.3 {i1=$::egrave} {lower(i1)} $::egrave
66 test_expr icu-2.4 {i1=$::egrave} {upper(i1)} $::EGRAVE
74 test_expr icu-2.7 {i1=$::szlig} {upper(i1)} "SS"
75 test_expr icu-2.8 {i1='SS'} {lower(i1)} "ss"
85 test_expr icu-3.1 {i1='I'} {lower(i1)} "i"
[all …]
H A DcorruptM.test41 CREATE INDEX i1 ON t1(b);
45 } {table t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
50 } {table t1 {} | index i1 t1 | view v2 v2 | trigger r1 t1 |}
60 } {table t1 tx | index i1 t1 | view v2 v2 | trigger r1 t1 |}
69 } {tabl t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
99 } {view t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
109 UPDATE sqlite_master SET tbl_name='tx' WHERE name='i1';
117 } {1 {malformed database schema (i1)}}
128 } {1 {malformed database schema (i1)}}
139 } {1 {malformed database schema (i1)}}
[all …]
H A Dindexedby.test22 CREATE INDEX i1 ON t1(a);
45 } {SEARCH t1 USING INDEX i1 (a=?)}
108 } {1 {no such index: i1}}
132 } {SEARCH t1 USING INDEX i1 (a=?)}
175 |--SCAN t1 USING INDEX i1
201 execsql { DROP INDEX i1 }
203 } {1 {no such index: i1}}
212 execsql { DROP INDEX i1 ; CREATE INDEX i1 ON t1(a) }
233 } {SEARCH t1 USING INDEX i1 (a=?)}
239 } {SEARCH t1 USING INDEX i1 (a=?)}
[all …]
H A Dtt3_stress.c59 int i1 = 0; in stress_thread_3() local
65 i1++; in stress_thread_3()
81 int i1 = 0; in stress_thread_4() local
95 i1++; in stress_thread_4()
113 int i1 = 0; in stress_thread_5() local
118 i64 i = (i1 % 4); in stress_thread_5()
124 i1++; in stress_thread_5()
288 int i1 = 0; in stress2_thread_wrapper() local
295 pCtx->xProc(&err, &db, i1); in stress2_thread_wrapper()
298 i1++; in stress2_thread_wrapper()
[all …]
H A Dunordered.test21 CREATE INDEX i1 ON t1(a);
43 {SCAN t1 USING INDEX i1}
46 {SEARCH t1 USING INDEX i1 (a>?)}
49 {SEARCH t1 USING INDEX i1 (a=?)}
50 {SEARCH t1 USING INDEX i1 (a=?)*USE TEMP B-TREE FOR ORDER BY}
52 {SEARCH t1 USING COVERING INDEX i1}
55 {SCAN t1 USING INDEX i1}
59 {SEARCH t1 USING INDEX i1 (a=?)}
60 {SEARCH t1 USING INDEX i1 (a=?)}
62 {SCAN t1 USING COVERING INDEX i1}
H A Dminmax3.test64 execsql { CREATE INDEX i1 ON t1(x) }
94 execsql { CREATE INDEX i1 ON t1(x) }
114 # Index i1 optimizes the min(y)
115 execsql { CREATE INDEX i1 ON t1(y) }
119 # Index i1 optimizes the min(y)
120 execsql { DROP INDEX i1 ; CREATE INDEX i1 ON t1(y DESC) }
126 execsql { DROP INDEX i1 }
130 # Index i1 optimizes the max(y)
135 # Index i1 optimizes the max(y)
136 execsql { DROP INDEX i1 ; CREATE INDEX i1 ON t1(y DESC) }
[all …]
H A Dfuzzinvariants.c306 sqlite3_stmt *pS1, int i1, /* Value to text on the left */ in sameValue() argument
311 int t1 = sqlite3_column_type(pS1,i1); in sameValue()
322 switch( sqlite3_column_type(pS1,i1) ){ 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()
332 int e1 = sqlite3_value_encoding(sqlite3_column_value(pS1,i1)); in sameValue()
335 const char *z1 = (const char*)sqlite3_column_text(pS1,i1); in sameValue()
350 int len1 = sqlite3_column_bytes16(pS1,i1); in sameValue()
351 const unsigned char *b1 = sqlite3_column_blob(pS1,i1); in sameValue()
366 int len1 = sqlite3_column_bytes(pS1,i1); in sameValue()
[all …]
H A Dtkt-4dd95f6943.test24 1 { CREATE INDEX i1 ON t1(x ASC) }
25 2 { CREATE INDEX i1 ON t1(x DESC) }
27 do_execsql_test 1.$tn1.1 { DROP INDEX IF EXISTS i1; }
56 1 { CREATE INDEX i1 ON t2(x ASC, y ASC) }
57 2 { CREATE INDEX i1 ON t2(x ASC, y DESC) }
58 3 { CREATE INDEX i1 ON t2(x DESC, y ASC) }
59 4 { CREATE INDEX i1 ON t2(x DESC, y DESC) }
61 5 { CREATE INDEX i1 ON t2(y ASC, x ASC) }
62 6 { CREATE INDEX i1 ON t2(y ASC, x DESC) }
63 7 { CREATE INDEX i1 ON t2(y DESC, x ASC) }
[all …]
H A Dattach3.test78 CREATE INDEX aux.i1 on t3(e);
83 SELECT * FROM sqlite_master WHERE name = 'i1';
88 SELECT * FROM aux.sqlite_master WHERE name = 'i1';
90 } "index i1 t3 [expr $AUTOVACUUM?6:5] {CREATE INDEX i1 on t3(e)}"
95 DROP INDEX aux.i1;
96 SELECT * FROM aux.sqlite_master WHERE name = 'i1';
101 CREATE INDEX aux.i1 on t3(e);
102 SELECT * FROM aux.sqlite_master WHERE name = 'i1';
104 } "index i1 t3 [expr $AUTOVACUUM?6:5] {CREATE INDEX i1 on t3(e)}"
107 DROP INDEX i1;
[all …]
H A Danalyze9.test47 CREATE INDEX i1 ON t1(a, b);
266 CREATE INDEX i1 ON t1(o);
301 CREATE INDEX i1 ON t1(a);
332 CREATE INDEX i1 ON t1(a, b);
377 CREATE INDEX i1 ON t1(x);
417 } {/t1 USING INDEX i1/}
426 } {/t1 USING INDEX i1/}
570 CREATE INDEX i1 ON t1(a);
846 } {/USING INDEX i1/}
849 } {/USING INDEX i1/}
[all …]
H A Dtkt-ba7cbfaedc.test30 CREATE INDEX i1 ON t1(x, y);
34 1 { CREATE INDEX i1 ON t1(x, y) }
35 2 { CREATE INDEX i1 ON t1(x DESC, y) }
36 3 { CREATE INDEX i1 ON t1(x, y DESC) }
37 4 { CREATE INDEX i1 ON t1(x DESC, y DESC) }
39 catchsql { DROP INDEX i1 }
H A Dnulls1.test48 execsql { CREATE INDEX i1 ON t3(a) }
51 execsql { DROP INDEX i1 ; CREATE INDEX i1 ON t3(a DESC) }
89 1 { CREATE INDEX i1 ON t1(a ASC NULLS LAST) } LAST
90 2 { CREATE INDEX i1 ON t1(a ASC NULLS FIRST) } FIRST
91 3 { CREATE INDEX i1 ON t1(a, b ASC NULLS LAST) } LAST
92 4 { CREATE INDEX i1 ON t1(a, b ASC NULLS FIRST) } FIRST
93 5 { CREATE INDEX i1 ON t1(a DESC NULLS LAST) } LAST
94 6 { CREATE INDEX i1 ON t1(a DESC NULLS FIRST) } FIRST
95 7 { CREATE INDEX i1 ON t1(a, b DESC NULLS LAST) } LAST
96 8 { CREATE INDEX i1 ON t1(a, b DESC NULLS FIRST) } FIRST
[all …]
H A Dlike.test210 } {abc abcd nosort {} i1}
269 } {a nosort {} i1}
274 } {ab nosort {} i1}
279 } {abcd nosort {} i1}
284 } {nosort {} i1}
294 } {abc nosort {} i1}
349 DROP INDEX i1;
399 } {abd acd nosort {} i1}
410 } {a nosort {} i1}
415 } {abcd nosort {} i1}
[all …]
H A Dindexfault.test87 execsql { CREATE INDEX i1 ON t1(x) }
96 execsql { CREATE INDEX i1 ON t1(x) }
143 execsql { CREATE INDEX i1 ON t1(t,u,v,w,x,y,z) }
152 execsql { CREATE INDEX i1 ON t1(t,u,v,w,x,y,z) }
213 execsql { CREATE INDEX i1 ON t1(x) }
221 execsql { CREATE INDEX i1 ON t1(x) }
250 execsql { CREATE INDEX i1 ON t1(x) }
260 execsql { CREATE INDEX i1 ON t1(x) }
306 execsql { CREATE INDEX i1 ON t1(x) }
336 execsql { CREATE INDEX i1 ON t1(x) }
H A Dpragma4.test168 CREATE INDEX i1 ON t1(b);
174 do_execsql_test 4.3.2 { SELECT * FROM pragma_index_info('i1') } {0 1 b}
180 execsql { DROP INDEX i1 } db3
185 do_execsql_test 4.3.5 { SELECT * FROM pragma_index_info('i1') }
191 CREATE INDEX main.i1 ON t1(b, c);
195 do_execsql_test 4.4.1 { SELECT * FROM pragma_index_list('t1') } {0 i1 0 c 0}
199 execsql { DROP INDEX i1 } db3
212 CREATE UNIQUE INDEX main.i1 ON t1(a);
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 Dtypes2.test37 i1 INTEGER,
294 test_bool types2-7.1 {i1=1} {i1 IN (SELECT i FROM t3)} 1
295 test_bool types2-7.2 {i1='2.0'} {i1 IN (SELECT i FROM t3)} 1
296 test_bool types2-7.3 {i1='2.0'} {i1 IN (SELECT n FROM t3)} 1
297 test_bool types2-7.4 {i1='2.0'} {i1 IN (SELECT t FROM t3)} 1
298 test_bool types2-7.5 {i1='2.0'} {i1 IN (SELECT o FROM t3)} 1
H A Dschema4.test35 CREATE INDEX i1 ON tbl(a);
45 CREATE TRIGGER i1 AFTER DELETE ON tbl BEGIN
61 DROP INDEX i1;
86 CREATE INDEX i1 ON tbl(a);
112 CREATE INDEX i1 ON t1(a, b);
119 CREATE TRIGGER i1 AFTER DELETE ON tbl BEGIN
H A Davtrans.test303 } {i1 t1}
311 } {i1 t1}
331 } {i1 t1}
335 DROP INDEX i1;
348 } {i1 t1}
352 DROP INDEX i1;
552 DROP INDEX i1;
574 DROP INDEX i1;
620 DROP INDEX i1;
642 DROP INDEX i1;
[all …]
H A Dtrans.test341 } {i1 t1}
349 } {i1 t1}
369 } {i1 t1}
373 DROP INDEX i1;
386 } {i1 t1}
390 DROP INDEX i1;
590 DROP INDEX i1;
612 DROP INDEX i1;
658 DROP INDEX i1;
680 DROP INDEX i1;
[all …]
/sqlite-3.40.0/ext/misc/
H A Dpercentile.c184 unsigned i1, i2; in percentFinal() local
193 i1 = (unsigned)ix; in percentFinal()
194 i2 = ix==(double)i1 || i1==p->nUsed-1 ? i1 : i1+1; in percentFinal()
195 v1 = p->a[i1]; in percentFinal()
197 vx = v1 + (v2-v1)*(ix-i1); in percentFinal()
H A Dspellfix.c998 int i1, b1; in editDist3Core() local
1050 for(i1=0; i1<f.n; i1 += b1){ in editDist3Core()
1052 updateCost(m, i1+b1, i1, pLang->iDelCost); in editDist3Core()
1055 updateCost(m, i1+p->nFrom, i1, p->iCost); in editDist3Core()
1071 for(i1=0; i1<f.n; i1+=b1){ in editDist3Core()
1077 cxp = rx + i1; in editDist3Core()
1079 cxd = rxp + i1; in editDist3Core()
1102 for(i1=0; i1<f.n; i1++) printf(" %c-%2x", f.z[i1], f.z[i1]&0xff); in editDist3Core()
1104 for(i1=0; i1<szRow; i1++){ in editDist3Core()
1105 int v = m[i1]; in editDist3Core()
[all …]
/sqlite-3.40.0/ext/rbu/
H A Drbu1.test155 CREATE INDEX i1 ON t1(b);
162 CREATE INDEX i1 ON t1(b);
166 CREATE INDEX i1 ON t1(b);
188 CREATE INDEX i1 ON t1(b);
211 CREATE INDEX i1 ON t1(b);
216 CREATE INDEX i1 ON t1(b);
350 CREATE INDEX i1 ON t1(b);
354 CREATE INDEX i1 ON t1(b);
360 CREATE INDEX i1 ON t1(b);
366 CREATE INDEX i1 ON t1(b);
[all …]
/sqlite-3.40.0/ext/repair/test/
H A Dcheckindex01.test7 CREATE INDEX i1 ON t1(a);
47 SELECT rowid, errmsg IS NULL, current_key FROM incremental_index_check('i1');
57 FROM incremental_index_check('i1') LIMIT 1;
61 i1
63 … COLLATE BINARY IS i.i1), quote(i0)||','||quote(i1) FROM (SELECT (a) AS i0, ("rowid" COLLATE BINAR…
66 do_index_check_test 1.3 i1 {
92 do_index_check_test 1.6 i1 {

12345678910