Home
last modified time | relevance | path

Searched refs:w (Results 1 – 25 of 262) sorted by relevance

1234567891011

/sqlite-3.40.0/contrib/
H A Dsqlitecon.tcl41 if {[winfo exists $w]} {destroy $w}
43 toplevel $w
44 wm title $w $title
132 $w yview insert
174 $w delete insert
242 $w yview insert
446 focus $w
646 set w .ed$i
647 toplevel $w
648 wm protocol $w WM_DELETE_WINDOW "$w.b.can invoke"
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5ah.test36 set v {w w w w w w w w w w w w w w w w w w w w}
44 set v {w w w w w w w w w w w w w w w w w w w w}
49 SELECT rowid FROM t1 WHERE t1 MATCH 'x AND w'
53 SELECT rowid FROM t1 WHERE t1 MATCH 'x* AND w*'
95 1 { SELECT rowid FROM t1 WHERE t1 MATCH 'w + x' } [list $W]
96 2 { SELECT rowid FROM t1 WHERE t1 MATCH 'x + w' } [list $W]
97 3 { SELECT rowid FROM t1 WHERE t1 MATCH 'x AND w' } [list $W]
H A Dfts5auto.test36 {w r j z n s l} {m j i w d t w e l}
59 {p x r u} {x i s w o t o g x m z i w}
60 {q x m z} {h c j w b l y w x c o}
67 {z u w j f d b f} {j w i c g u d w e}
100 {i c x q w g v o x z i z p} {q o g k i n z x e d v w v}
107 {d h v w u z r e h x o l t} {p s f y w y r q d a m w}
113 {t v o d w} {w e q w h y c y y i j b a m}
145 {f o v y v l} {c w p s w j w c u t y}
187 {e o f j y x u w v e w z} {r d q g k n n v r c z n e w}
196 {q w a v} {a b s d x i g w t e z h}
[all …]
H A Dfts5ac.test39 11 {j z u m o y q j f w e e w t r j w} {g m o r x n t n w i f g l z f}
40 12 {s y w a w d o h x m k} {c w k z b p o r a}
43 15 {n a f n u s w h y n s i q e w} {x g e g a s s h n}
45 17 {g d t u w r o p m n m n p h b o u} {h s w o s l j e}
50 22 {w b f o c g x y j} {z d w x d f h i p}
60 32 {w g v l z f b z h p s c v h} {g e w v m h k r g w a r f q}
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}
86 58 {t d y e t d c w u o s w x f c h} {i o s v y b r d r}
95 67 {c b m h f n v w n h} {i r w i e x r w l z p x u g u l s}
[all …]
H A Dfts5ag.test44 {j s m y m r n l u k} {z k f u z g h s w g} {r n o s s b v n w w}
48 {v r w l e e t d z p} {c s b w k m n k o u} {w g y f v w v w v p}
50 {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}
51 {j y b i u d e m d w} {y s o j h i n a u p} {n a g b u c w e b m}
52 {b c k s c w j p w b} {m o c o w o b d q q} {n t y o y z y r z e}
60 {h o q w t f v i c y} {c q u n r z s l l q} {z x a q w s b w s y}
62 {z v s j f p v l f w} {c s b i z e k i g c} {x b v d w j f e d z}
64 {v h i v s y z i k l} {d t m w q w c a z p} {r s e s x v d w k b}
66 {q l f d a p w l q o} {y z q w j o p b o v} {s u h z h f d f n l}
67 {q o e o x x l g q i} {j g m h q q w c d b} {o m d h w a g b f n}
[all …]
/sqlite-3.40.0/test/
H A Dwhere2.test28 set w $i
81 } elseif {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+) USING.* INDEX (\w+)\y} \
283 SELECT * FROM t1 WHERE w=99 ORDER BY w
290 SELECT * FROM t1 WHERE w IN (99) ORDER BY w
295 SELECT * FROM t1 WHERE w IN (99) ORDER BY w DESC
306 SELECT * FROM t1 WHERE w=99 OR w=100 ORDER BY +w
311 SELECT * FROM t1 WHERE 99=w OR 100=w ORDER BY +w
316 SELECT * FROM t1 WHERE w=99 OR w=100 OR 6=w ORDER BY +w
322 SELECT * FROM t1 WHERE w=99 OR w=100 OR 6=+w ORDER BY +w
327 SELECT *, '|' FROM t1 WHERE w=99 OR +w=100 OR 6=w ORDER BY +w
[all …]
H A Dwhere.test71 SELECT x, y, w FROM t1 WHERE w=10
74 SELECT x, y, w FROM t1 WHERE w IS 10
86 SELECT x, y, w FROM t1 WHERE +w=10
241 count {SELECT w FROM t1 WHERE w>97}
250 count {SELECT w FROM t1 WHERE w<=97 AND w==97}
253 count {SELECT w FROM t1 WHERE w<98 AND w==97}
256 count {SELECT w FROM t1 WHERE w>=97 AND w==97}
259 count {SELECT w FROM t1 WHERE w>96 AND w==97}
262 count {SELECT w FROM t1 WHERE w==97 AND w==97}
268 count {SELECT w FROM t1 WHERE w<3}
[all …]
H A Dbetween.test28 set w $i
42 CREATE UNIQUE INDEX i1w ON t1(w);
61 if {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+) USING.* INDEX (\w+)\y} \
64 } elseif {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+)\y} $x all ss as tab]} {
73 SELECT * FROM t1 WHERE w BETWEEN 5 AND 6 ORDER BY +w
78 SELECT * FROM t1 WHERE +w BETWEEN 5 AND 6 ORDER BY +w
83 SELECT * FROM t1 WHERE w BETWEEN 5 AND 65-y ORDER BY +w
88 SELECT * FROM t1 WHERE +w BETWEEN 5 AND 65-y ORDER BY +w
93 SELECT * FROM t1 WHERE w BETWEEN 41-y AND 6 ORDER BY +w
98 SELECT * FROM t1 WHERE +w BETWEEN 41-y AND 6 ORDER BY +w
[all …]
H A DjoinF.test39 CREATE TABLE t4(w INT);
49 ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
58 ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
66 ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
75 ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
83 ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
93 ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
101 ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
110 ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
118 ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);
[all …]
H A Dunique2.test59 5 {CREATE TABLE t1(w,x,y NOT NULL,z NOT NULL,PRIMARY KEY(w,x)) WITHOUT ROWID}
60 6 {CREATE TABLE t1(w,x,y NOT NULL,z NOT NULL,PRIMARY KEY(w,x))}
61 7 {CREATE TABLE t1(w,x,y NOT NULL,z,PRIMARY KEY(w,x)) WITHOUT ROWID}
62 8 {CREATE TABLE t1(w,x,y NOT NULL,z,PRIMARY KEY(w,x))}
63 9 {CREATE TABLE t1(w,x,y,z NOT NULL,PRIMARY KEY(w,x)) WITHOUT ROWID}
64 10 {CREATE TABLE t1(w,x,y,z NOT NULL,PRIMARY KEY(w,x))}
65 11 {CREATE TABLE t1(w,x,y,z,PRIMARY KEY(w,x)) WITHOUT ROWID}
66 12 {CREATE TABLE t1(w,x,y,z,PRIMARY KEY(w,x))}
71 db eval {INSERT INTO t1(w,x,y,z) VALUES(1,2,3,4),(2,3,3,4)}
H A Dupsert4.test292 CREATE TABLE t1(w, x, y, z, PRIMARY KEY(x, y));
296 CREATE TABLE t1(w, x, y, z, PRIMARY KEY(x, y)) WITHOUT ROWID;
309 DO UPDATE SET w = excluded.w;
315 DO UPDATE SET w = w||w;
321 DO UPDATE SET w = w||t1.w;
327 DO UPDATE SET w = w||tbl.w;
355 DO UPDATE SET w=excluded.w;
361 DO UPDATE SET w=excluded.w;
367 DO UPDATE SET w=w||w WHERE excluded.w!='hello';
373 DO UPDATE SET w=w||w WHERE excluded.x=1;
[all …]
H A Dwhere4.test33 CREATE TABLE t1(w, x, y);
34 CREATE INDEX i1wxy ON t1(w,x,y);
59 count {SELECT rowid FROM t1 WHERE w IS NULL}
63 count {SELECT rowid FROM t1 WHERE w IS $null}
66 count {SELECT rowid FROM t1 WHERE +w IS NULL}
69 count {SELECT rowid FROM t1 WHERE w=1 AND x IS NULL}
72 count {SELECT rowid FROM t1 WHERE w=1 AND +x IS NULL}
75 count {SELECT rowid FROM t1 WHERE w=1 AND x>0}
78 count {SELECT rowid FROM t1 WHERE w=1 AND x<9}
112 execsql {SELECT rowid FROM t1 ORDER BY w, x, y}
[all …]
H A Drowvalue2.test86 foreach w $words {
87 set a [string range $w 0 2]
88 set b [string range $w 3 5]
89 set c [string range $w 6 end]
104 foreach w $words {
105 set a [string range $w 0 2]
106 set b [string range $w 3 5]
107 set c [string range $w 6 end]
114 SELECT rowid FROM t3 WHERE w [set op] $w ORDER BY +rowid
119 SELECT a, b, c FROM t3 WHERE w = $w
[all …]
H A Dalterdropcol2.test149 CREATE TABLE c1(u, v, w AS (u+v));
156 CREATE TABLE c1(u, v, w AS (u+v) STORED);
167 CREATE TABLE c1(u, v, w);
169 INSERT INTO log VALUES(new.w);
172 ALTER TABLE c1 DROP w
177 CREATE TABLE c1(u, v, w);
178 CREATE VIEW v1 AS SELECT u, v, w FROM c1;
180 ALTER TABLE c1 DROP w
185 CREATE TABLE c1(u, v, w);
188 ALTER TABLE c1 DROP w
[all …]
H A Dshell5.test89 set in [open shell5.csv w]
98 set in [open shell5.csv w]
107 set in [open shell5.csv w]
116 set in [open shell5.csv w]
128 set in [open shell5.csv w]
139 set in [open shell5.csv w]
150 set in [open shell5.csv w]
165 set in [open shell5.csv w]
178 set in [open shell5.csv w]
223 set in [open shell5.csv w]
[all …]
H A Dwhere3.test116 } elseif {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+) USING.* INDEX (\w+)\y} \
119 } elseif {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+)\y} $x all ss as tab]} {
374 CREATE TABLE t6w(a, w);
407 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
413 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
419 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
425 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
431 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
437 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
443 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
[all …]
H A Dquote.test103 3 { CREATE INDEX i3 ON t1("w") } w
104 4 { CREATE INDEX i4 ON t1(x) WHERE z="w" } w
113 CREATE INDEX i3 ON t1("w"||"");
114 CREATE INDEX i4 ON t1(x) WHERE z="w";
129 INSERT INTO t1 VALUES(4, 5, 'w');
130 SELECT * FROM t1 WHERE z='w';
131 } {4 5 w}
138 {CREATE INDEX i3 ON t1("w"||"")}
139 {CREATE INDEX i4 ON t1(x) WHERE z="w"}
/sqlite-3.40.0/ext/wasm/
H A Dtester1.js380 const w = wasm;
400 const ip = w.isPtr32;
413 T.assert(3 === w.jstrlen("abc")).assert(4 === w.jstrlen("äbc"));
504 const alloc = w.alloc, dealloc = w.dealloc;
505 w.alloc = w.dealloc = null;
509 w.alloc = alloc;
511 w.dealloc = dealloc;
587 if(w.bigIntEnabled){
598 let r1 = w.getMemValue(pI1, 'i64'), r2 = w.getMemValue(pI2, 'i64');
1653 if(w.bigIntEnabled){
[all …]
/sqlite-3.40.0/ext/lsm1/
H A Dlsm_varint.c82 unsigned int w, y; in lsmSqlite4PutVarint64() local
101 w = (unsigned int)(x>>32); in lsmSqlite4PutVarint64()
102 if( w==0 ){ in lsmSqlite4PutVarint64()
114 if( w<=255 ){ in lsmSqlite4PutVarint64()
116 z[1] = (unsigned char)w; in lsmSqlite4PutVarint64()
120 if( w<=32767 ){ in lsmSqlite4PutVarint64()
122 z[1] = (unsigned char)(w>>8); in lsmSqlite4PutVarint64()
123 z[2] = (unsigned char)w; in lsmSqlite4PutVarint64()
127 if( w<=16777215 ){ in lsmSqlite4PutVarint64()
131 z[3] = (unsigned char)w; in lsmSqlite4PutVarint64()
[all …]
/sqlite-3.40.0/tool/
H A Dspeedtest.tcl75 set fd [open clear.sql w]
83 set fd [open 2kinit.sql w]
128 set fd [open test$cnt.sql w]
139 set fd [open test$cnt.sql w]
152 set fd [open test$cnt.sql w]
163 set fd [open test$cnt.sql w]
172 set fd [open test$cnt.sql w]
180 set fd [open test$cnt.sql w]
191 set fd [open test$cnt.sql w]
204 set fd [open test$cnt.sql w]
[all …]
H A Dspeedtest2.tcl67 set fd [open clear.sql w]
75 set fd [open 2kinit.sql w]
118 set fd [open test$cnt.sql w]
130 set fd [open test$cnt.sql w]
136 set fd [open test$cnt.sql w]
147 set fd [open test$cnt.sql w]
153 set fd [open test$cnt.sql w]
164 set fd [open test$cnt.sql w]
170 set fd [open test$cnt.sql w]
181 set fd [open test$cnt.sql w]
[all …]
H A Ddbhash.c81 #define Rl0(v,w,x,y,z,i) \ argument
82 z+=((w&(x^y))^y)+blk0le(i)+0x5A827999+rol(v,5);w=ror(w,2);
84 z+=((w&(x^y))^y)+blk0be(i)+0x5A827999+rol(v,5);w=ror(w,2);
85 #define R1(v,w,x,y,z,i) \ argument
86 z+=((w&(x^y))^y)+blk(i)+0x5A827999+rol(v,5);w=ror(w,2);
87 #define R2(v,w,x,y,z,i) \ argument
88 z+=(w^x^y)+blk(i)+0x6ED9EBA1+rol(v,5);w=ror(w,2);
89 #define R3(v,w,x,y,z,i) \ argument
90 z+=(((w|x)&y)|(w&x))+blk(i)+0x8F1BBCDC+rol(v,5);w=ror(w,2);
91 #define R4(v,w,x,y,z,i) \ argument
[all …]
/sqlite-3.40.0/ext/misc/
H A Dsha1.c58 #define Rl0(v,w,x,y,z,i) \ argument
59 z+=((w&(x^y))^y)+blk0le(i)+0x5A827999+rol(v,5);w=ror(w,2);
61 z+=((w&(x^y))^y)+blk0be(i)+0x5A827999+rol(v,5);w=ror(w,2);
62 #define R1(v,w,x,y,z,i) \ argument
63 z+=((w&(x^y))^y)+blk(i)+0x5A827999+rol(v,5);w=ror(w,2);
64 #define R2(v,w,x,y,z,i) \ argument
65 z+=(w^x^y)+blk(i)+0x6ED9EBA1+rol(v,5);w=ror(w,2);
66 #define R3(v,w,x,y,z,i) \ argument
67 z+=(((w|x)&y)|(w&x))+blk(i)+0x8F1BBCDC+rol(v,5);w=ror(w,2);
68 #define R4(v,w,x,y,z,i) \ argument
[all …]
/sqlite-3.40.0/src/
H A Dattach.c519 pFix->w.pParse = pParse; in sqlite3FixInit()
520 pFix->w.xExprCallback = fixExprCb; in sqlite3FixInit()
521 pFix->w.xSelectCallback = fixSelectCb; in sqlite3FixInit()
523 pFix->w.walkerDepth = 0; in sqlite3FixInit()
524 pFix->w.eCode = 0; in sqlite3FixInit()
525 pFix->w.u.pFix = pFix; in sqlite3FixInit()
551 res = sqlite3WalkSelect(&pFix->w, &s); in sqlite3FixSrcList()
560 return sqlite3WalkSelect(&pFix->w, pSelect); in sqlite3FixSelect()
566 return sqlite3WalkExpr(&pFix->w, pExpr); in sqlite3FixExpr()
576 if( sqlite3WalkSelect(&pFix->w, pStep->pSelect) in sqlite3FixTriggerStep()
[all …]
H A Dresolve.c41 Walker w; in incrAggFunctionDepth() local
42 memset(&w, 0, sizeof(w)); in incrAggFunctionDepth()
44 w.u.n = N; in incrAggFunctionDepth()
1978 Walker w; in sqlite3ResolveExprNames() local
1987 w.u.pNC = pNC; in sqlite3ResolveExprNames()
1990 if( sqlite3ExprCheckHeight(w.pParse, w.pParse->nHeight) ){ in sqlite3ResolveExprNames()
2018 Walker w; in sqlite3ResolveExprListNames() local
2024 w.u.pNC = pNC; in sqlite3ResolveExprListNames()
2032 if( sqlite3ExprCheckHeight(w.pParse, w.pParse->nHeight) ){ in sqlite3ResolveExprListNames()
2073 Walker w; in sqlite3ResolveSelectNames() local
[all …]

1234567891011