Home
last modified time | relevance | path

Searched refs:t (Results 1 – 25 of 366) sorted by relevance

12345678910>>...15

/sqlite-3.40.0/ext/session/
H A Dsessionstat1.test36 {INSERT sqlite_stat1 0 XX. {} {t t1 t sqlite_autoindex_t1_1 t {32 1}}}
37 {INSERT sqlite_stat1 0 XX. {} {t t1 t t1b t {32 4}}}
38 {INSERT sqlite_stat1 0 XX. {} {t t1 t t1c t {32 16}}}
51 {UPDATE sqlite_stat1 0 XX. {t t1 t sqlite_autoindex_t1_1 t {32 1}} {{} {} {} {} t {64 1}}}
52 {UPDATE sqlite_stat1 0 XX. {t t1 t t1b t {32 4}} {{} {} {} {} t {64 8}}}
53 {UPDATE sqlite_stat1 0 XX. {t t1 t t1c t {32 16}} {{} {} {} {} t {64 32}}}
59 {DELETE sqlite_stat1 0 XX. {t t1 t t1b t {64 8}} {}}
66 {DELETE sqlite_stat1 0 XX. {t t1 t t1c t {64 32}} {}}
257 {INSERT sqlite_stat1 CONFLICT {t t1 t i1 t {3 1}} {t t1 t i1 t {2 1}}}
258 {INSERT sqlite_stat1 CONFLICT {t t1 t i2 t {3 1}} {t t1 t i2 t {2 1}}}
[all …]
H A Dsessioninvert.test72 {DELETE t1 0 X.. {i 7 t seven t vii} {}}
78 {INSERT t1 0 X.. {} {i 1 t one t i}}
79 {INSERT t1 0 X.. {} {i 2 t two t ii}}
80 {INSERT t1 0 X.. {} {i 3 t three t iii}}
124 {DELETE sqlite_stat1 0 XX. {t t3 t idx2 t {1 2 3}} {}}
130 {INSERT sqlite_stat1 0 XX. {} {t t1 t sqlite_autoindex_t1_1 t {6 1}}}
131 {INSERT sqlite_stat1 0 XX. {} {t t2 t sqlite_autoindex_t2_1 t {6 1 1}}}
176 {UPDATE t1 0 X. {i 1 t two} {{} {} t one}}
177 {UPDATE t1 0 X. {i 2 t five} {{} {} t two}}
178 {UPDATE t1 0 X. {i 3 t one} {{} {} t three}}
[all …]
H A DsessionF.test55 {INSERT t2 0 X. {} {i 2 t two}}
56 {INSERT t1 0 X. {} {i 1 t one}}
57 {INSERT t3 0 X. {} {i 3 t three}}
64 {INSERT t1 0 X. {} {i 1 t one}}
65 {INSERT t2 0 X. {} {i 2 t two}}
75 {INSERT t2 0 X. {} {i 2 t two}}
76 {INSERT t1 0 X. {} {i 1 t one}}
106 {INSERT t3 0 X. {} {i 6 t six}}
116 {INSERT t3 0 X. {} {i 6 t six}}
124 {INSERT t3 0 X. {} {i 6 t six}}
[all …]
H A Dsessionwor.test44 {INSERT t1 0 X. {} {t one t two}}
50 {UPDATE t1 0 X. {t one t two} {{} {} t three}}
56 {UPDATE t1 0 X. {t one t three} {{} {} t four}}
62 {DELETE t1 0 X. {t one t four} {}}
79 {INSERT t1 0 X. {} {i 1 t two}}
85 {UPDATE t1 0 X. {i 1 t two} {{} {} t three}}
91 {UPDATE t1 0 X. {i 1 t three} {{} {} t four}}
97 {DELETE t1 0 X. {i 1 t four} {}}
109 {INSERT t2 0 X. {} {i 1 t one}}
110 {INSERT t2 0 X. {} {i 2 t two}}
[all …]
H A Dsession1.test131 {UPDATE t1 0 X. {i 2 t Ayutthaya} {{} {} t Surin}}
204 foreach t $O(-tables) { S attach $t }
244 {INSERT t1 CONFLICT {i 6 t six} {i 6 t VI}}
282 {DELETE t2 DATA {i 4 t four} {i 4 t five}}
395 {INSERT {'foolish name'} CONFLICT {t one t two i 2} {t one t two t i}}
423 {DELETE d1 DATA {i 2 t two} {i 2 t TWO}}
454 {INSERT t1 CONFLICT {t A t B} {t a t b}}
560 {INSERT $tblname 0 X. {} {t uvw t abc}}
561 {DELETE $tblname 0 X. {t xyz t def} {}}
600 {INSERT $tblname 0 X. {} {t uvw t abc}}
[all …]
/sqlite-3.40.0/test/
H A Dwal9.test39 INSERT INTO t SELECT randomblob(100) FROM t;
40 INSERT INTO t SELECT randomblob(100) FROM t;
41 INSERT INTO t SELECT randomblob(100) FROM t;
42 INSERT INTO t SELECT randomblob(100) FROM t;
43 INSERT INTO t SELECT randomblob(100) FROM t;
44 INSERT INTO t SELECT randomblob(100) FROM t;
45 INSERT INTO t SELECT randomblob(100) FROM t;
47 INSERT INTO t SELECT randomblob(100) FROM t;
48 INSERT INTO t SELECT randomblob(100) FROM t;
49 INSERT INTO t SELECT randomblob(100) FROM t;
[all …]
H A Dbigmmap.test65 INSERT INTO t$i SELECT i, 't$i', randomblob(800) FROM s;
83 for {set t 0} {$t < 8} {incr t} {
84 do_execsql_test 2.$i.$t.1 "
85 SELECT count(*) FROM t$t;
86 SELECT count(b || c) FROM t$t GROUP BY b;
89 do_execsql_test 2.$i.$t.2 "
90 SELECT * FROM t$t AS o WHERE
91 NOT EXISTS( SELECT * FROM t$t AS i WHERE a=o.a AND +b=o.b AND +c=o.c )
95 do_eqp_test 2.$i.$t.3 "
96 SELECT * FROM t$t AS o WHERE
[all …]
H A Dspeed4p.test106 set stmt [string map "%T% t$jj" {INSERT INTO %T% VALUES(NULL, $i, $t)}]
109 set t [number_name $i]
114 CREATE INDEX i1 ON t1(t);
115 CREATE INDEX i2 ON t2(t);
116 CREATE INDEX i3 ON t3(t);
125 set sql "SELECT * FROM t1, t2, t3 WHERE t1.t = t2.t AND t2.t = t3.t"
132 set t [expr {$ii%3+1}]
146 set t [expr {$ii%3+1}]
147 db eval "SELECT t FROM t$t WHERE rowid = \$v"
188 foreach t $::list {
[all …]
H A Dspeed4p.explain101 CREATE VIEW v1 AS SELECT rowid, i, t FROM t1;
102 CREATE VIEW v2 AS SELECT rowid, i, t FROM t2;
106 set stmt [string map "%T% t$jj" {INSERT INTO %T% VALUES(NULL, $i, $t)}]
109 set t [number_name $i]
114 CREATE INDEX i1 ON t1(t);
115 CREATE INDEX i2 ON t2(t);
116 CREATE INDEX i3 ON t3(t);
132 set sql "SELECT * FROM t1, t2, t3 WHERE t1.t = t2.t AND t2.t = t3.t"
140 set t [expr {$ii%3+1}]
155 set t [expr {$ii%3+1}]
[all …]
H A Dtkt-a8a0d2996a.test21 CREATE TABLE t(x,y);
22 INSERT INTO t VALUES('1','1');
23 SELECT typeof(x), typeof(y) FROM t WHERE 1=x+0 AND y=='1';
26 SELECT typeof(x), typeof(y) FROM t WHERE 1=x-0 AND y=='1';
29 SELECT typeof(x), typeof(y) FROM t WHERE 1=x*1 AND y=='1';
32 SELECT typeof(x), typeof(y) FROM t WHERE 1=x/1 AND y=='1';
35 SELECT typeof(x), typeof(y) FROM t WHERE 1=x%4 AND y=='1';
39 UPDATE t SET x='1xyzzy';
40 SELECT typeof(x), typeof(y) FROM t WHERE 1=x+0 AND y=='1';
43 SELECT typeof(x), typeof(y) FROM t WHERE 1=x-0 AND y=='1';
[all …]
H A DwhereD.test22 CREATE TABLE t(i,j,k,m,n);
23 CREATE INDEX ijk ON t(i,j,k);
24 CREATE INDEX jmn ON t(j,m,n);
223 DROP TABLE IF EXISTS t;
225 CREATE INDEX tc0 ON t(c0);
226 CREATE INDEX tc1 ON t(c1);
246 SELECT * FROM t WHERE
254 DELETE FROM t;
256 SELECT * FROM t WHERE
264 DELETE FROM t;
[all …]
H A Dspeed4.test98 CREATE VIEW v1 AS SELECT rowid, i, t FROM t1;
99 CREATE VIEW v2 AS SELECT rowid, i, t FROM t2;
100 CREATE VIEW v3 AS SELECT rowid, i, t FROM t3;
103 set stmt [string map "%T% t$jj" {INSERT INTO %T% VALUES(NULL, $i, $t)}]
106 set t [number_name $i]
111 CREATE INDEX i1 ON t1(t);
112 CREATE INDEX i2 ON t2(t);
113 CREATE INDEX i3 ON t3(t);
128 set sql "SELECT * FROM t1, t2, t3 WHERE t1.t = t2.t AND t2.t = t3.t"
145 append sql "SELECT t FROM t[expr {($ii%3)+1}] WHERE rowid = [expr {$ii*3}];"
[all …]
H A Dtkt-f973c7ac31.test19 CREATE TABLE t(c1 INTEGER, c2 INTEGER);
20 INSERT INTO t VALUES(5, 5);
21 INSERT INTO t VALUES(5, 4);
27 2 "CREATE INDEX i1 ON t(c1, c2)"
34 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='2' ORDER BY c2 DESC
39 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<=5 ORDER BY c2 DESC
44 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='5' ORDER BY c2 DESC
49 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<=5 ORDER BY c2 DESC
60 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='2' ORDER BY c2 ASC
65 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<=5 ORDER BY c2 ASC
[all …]
H A Dtkt-fc7bd6358f.test17 # CREATE TABLE t(textid TEXT);
18 # INSERT INTO t VALUES('12');
19 # INSERT INTO t VALUES('34');
25 # FROM t t1, i, t t2
39 CREATE TABLE t(textid TEXT);
40 INSERT INTO t VALUES('12');
41 INSERT INTO t VALUES('34');
52 1 {FROM t t1, i, t t2}
53 2 {FROM i, t t1, t t2}
54 3 {FROM t t1, t t2, i}
/sqlite-3.40.0/src/
H A Dtest_osinst.c265 t = vfslog_time() - t; in vfslogClose()
284 t = vfslog_time() - t; in vfslogRead()
303 t = vfslog_time() - t; in vfslogWrite()
317 t = vfslog_time() - t; in vfslogTruncate()
331 t = vfslog_time() - t; in vfslogSync()
345 t = vfslog_time() - t; in vfslogFileSize()
359 t = vfslog_time() - t; in vfslogLock()
373 t = vfslog_time() - t; in vfslogUnlock()
387 t = vfslog_time() - t; in vfslogCheckReservedLock()
413 t = vfslog_time() - t; in vfslogSectorSize()
[all …]
/sqlite-3.40.0/ext/rtree/
H A DrtreeC.test30 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND t.x<=max_y
33 |--SCAN t
39 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND t.x<=max_y
42 |--SCAN t
48 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND ?<=max_y
75 INSERT INTO t SELECT x+1, y FROM t;
76 INSERT INTO t SELECT x+2, y FROM t;
77 INSERT INTO t SELECT x+4, y FROM t;
87 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND t.x<=max_y
96 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND t.x<=max_y
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5auto.test27 {n x w k b p x b n t t d s} {f j j s p j o}
41 {p i k j k q c t g u s} {g u y s m h q k g t e s o r}
45 {t m w z b g q t s d d h} {o n v u i t o y k j}
75 {t t p b n u i h e c k} {m z}
80 {d i g q t f d r h k} {n w g j c x r p t y f l c t}
99 {o a a z t t u h j} {z z i r k r}
119 {l n p u o j d x t u u c o j} {k r n a r e k v i t o e}
120 {q f t t a a c z v f} {o n m p v f o e n}
129 {m j a h o b i x k r w z q u} {m t r g j o e q t m p u l}
131 {m w g x r n e u t s r} {b x a t u u j c r n}
[all …]
H A Dfts5ac.test54 26 {g s q w t d k x g f m j p k y} {r m b x e l t d}
56 28 {c t j g v r s b z j} {l c f y d t q n}
66 38 {r w t t t t r v v o e p g h} {l w x a g a u h y}
70 42 {t x w a r l w d t b c o d o} {a h f h w z d n s}
71 43 {t u q c d g p q x j o l c x c} {m n t o z z j a y}
85 57 {d g l o h t b s b r} {n u e p t i m u}
97 69 {c x f d x o n p o b r t b l p l} {m i t k b x v f p t m l l y r o}
117 89 {t c t p r s u c q n} {z x l i k n f q l n t}
118 90 {w t d q j g m r f k n} {l e w f w w a l y q k i q t p c t}
121 93 {k x j r m a d o i z j} {r t t t f e b r x i v j v g o}
[all …]
H A Dfts5ag.test50 {j s w x o t j b t m} {v a v v r t x c q a} {r t k x w u l h a g}
56 {f z k r b u s k z e} {n z v z w l e r h t} {t i s v v a v p n s}
58 {z r c t d q q h x b} {u c g z n z u v s s} {y t n f f x b f d x}
68 {m x k t s s y l v a} {j x t c a u w b w g} {n f j b v x y p u t}
70 {x v b l m t l m h l} {t p y i y i q b q a} {k o o z w a c h c f}
75 {t o s i q d z x d t} {v a k s q z j c o o} {z f n n r l y w v v}
78 {v s g x k z a k a r} {l t g v j q l k p l} {f h n a x t v s t y}
80 {q z l t w o l m p e} {t s g h r p r o t z} {y b f a o n u m z g}
81 {d t w n y b o g f o} {d a j e r l g g s h} {d z e l w q l t h f}
85 {k h s g o n s d a x} {u d t t s j o v h a} {z r b a e u v o e s}
[all …]
H A Dfts5corrupt5.test61 | 3888: 41 52 59 20 4b 45 59 28 73 65 67 69 64 2c 20 74 ARY KEY(segid, t
100 | 2672: 80 80 80 08 03 00 36 00 00 00 13 02 31 74 03 08 ......6.....1t..
133 | 3200: 16 02 31 74 02 08 02 01 01 07 00 03 32 61 6e 02 ..1t........2an.
171 | 3808: 02 02 02 01 74 01 06 01 01 04 04 07 1b 84 80 80 ....t...........
172 | 3824: 80 80 08 03 00 3c 00 00 00 16 02 31 74 01 0a 04 .....<.....1t...
197 | 3664: 04 01 10 01 03 34 74 20 07 04 01 0e 01 03 34 1e .....4t ......4.
200 | 3712: 01 03 32 74 16 08 04 01 10 01 03 32 6e 14 07 04 ..2t.......2n...
201 | 3728: 01 0e 01 03 32 12 08 04 01 10 01 03 31 74 10 08 ....2.......1t..
204 | 3776: 30 74 08 09 04 01 12 01 03 30 6e 75 06 08 04 01 0t.......0nu....
208 | 3840: 1c 08 04 01 10 01 02 32 74 1a 08 04 01 10 01 02 .......2t.......
[all …]
/sqlite-3.40.0/tool/
H A Dspeedtest.tcl40 set t [time "exec mysql -f drh <$sqlfile" 1]
41 set t [expr {[lindex $t 0]/1000000.0}]
42 puts [format $format MySQL: $t]
50 set t [time "exec ./sqlite248 s2k.db <$sqlfile" 1]
51 set t [expr {[lindex $t 0]/1000000.0}]
52 puts [format $format {SQLite 2.4.8:} $t]
55 set t [expr {[lindex $t 0]/1000000.0}]
56 puts [format $format {SQLite 2.4.8 (nosync):} $t]
59 set t [expr {[lindex $t 0]/1000000.0}]
60 puts [format $format {SQLite 2.4.12:} $t]
[all …]
H A Dspeedtest2.tcl36 set t [time "exec psql drh <$sqlfile" 1]
37 set t [expr {[lindex $t 0]/1000000.0}]
38 puts [format $format PostgreSQL: $t]
40 set t [time "exec mysql -f drh <$sqlfile" 1]
41 set t [expr {[lindex $t 0]/1000000.0}]
42 puts [format $format MySQL: $t]
50 set t [time "exec ./sqlite240 s2k.db <$sqlfile" 1]
51 set t [expr {[lindex $t 0]/1000000.0}]
52 puts [format $format {SQLite 2.4:} $t]
55 set t [expr {[lindex $t 0]/1000000.0}]
[all …]
/sqlite-3.40.0/ext/fts2/
H A Dfts2_tokenizer1.c57 static int simpleDelim(simple_tokenizer *t, unsigned char c){ in simpleDelim() argument
58 return c<0x80 && t->delim[c]; in simpleDelim()
68 simple_tokenizer *t; in simpleCreate() local
70 t = (simple_tokenizer *) sqlite3_malloc(sizeof(*t)); in simpleCreate()
71 if( t==NULL ) return SQLITE_NOMEM; in simpleCreate()
72 memset(t, 0, sizeof(*t)); in simpleCreate()
85 sqlite3_free(t); in simpleCreate()
88 t->delim[ch] = 1; in simpleCreate()
94 t->delim[i] = !((i>='0' && i<='9') || (i>='A' && i<='Z') || in simpleCreate()
99 *ppTokenizer = &t->base; in simpleCreate()
[all …]
/sqlite-3.40.0/ext/fts3/
H A Dfts3_tokenizer1.c51 static int simpleDelim(simple_tokenizer *t, unsigned char c){ in simpleDelim() argument
52 return c<0x80 && t->delim[c]; in simpleDelim()
65 simple_tokenizer *t; in simpleCreate() local
67 t = (simple_tokenizer *) sqlite3_malloc(sizeof(*t)); in simpleCreate()
68 if( t==NULL ) return SQLITE_NOMEM; in simpleCreate()
69 memset(t, 0, sizeof(*t)); in simpleCreate()
82 sqlite3_free(t); in simpleCreate()
85 t->delim[ch] = 1; in simpleCreate()
91 t->delim[i] = !fts3_isalnum(i) ? -1 : 0; in simpleCreate()
95 *ppTokenizer = &t->base; in simpleCreate()
[all …]
/sqlite-3.40.0/ext/fts1/
H A Dfts1_tokenizer1.c47 static int isDelim(simple_tokenizer *t, unsigned char c){ in isDelim() argument
48 return c<0x80 && t->delim[c]; in isDelim()
58 simple_tokenizer *t; in simpleCreate() local
60 t = (simple_tokenizer *) calloc(sizeof(*t), 1); in simpleCreate()
61 if( t==NULL ) return SQLITE_NOMEM; in simpleCreate()
74 free(t); in simpleCreate()
77 t->delim[ch] = 1; in simpleCreate()
83 t->delim[i] = !isalnum(i); in simpleCreate()
87 *ppTokenizer = &t->base; in simpleCreate()
163 while( c->iOffset<c->nBytes && isDelim(t, p[c->iOffset]) ){ in simpleNext()
[all …]

12345678910>>...15