Home
last modified time | relevance | path

Searched refs:y (Results 1 – 25 of 654) sorted by relevance

12345678910>>...27

/sqlite-3.40.0/test/
H A Dlike2.test55 INSERT INTO t1(x,y) VALUES(32,' ');
56 INSERT INTO t1(x,y) VALUES(33,'!');
57 INSERT INTO t1(x,y) VALUES(34,'"');
58 INSERT INTO t1(x,y) VALUES(35,'#');
59 INSERT INTO t1(x,y) VALUES(36,'$');
60 INSERT INTO t1(x,y) VALUES(37,'%');
144 INSERT INTO t1(x,y) VALUES(121,'y');
158 CREATE INDEX i2 ON t2(y);
166 CREATE INDEX i3 ON t3(y);
954 db eval "SELECT x FROM t1 WHERE y LIKE 'y%'"
[all …]
H A Dindex9.test38 set y [expr 45]
39 do_sqluses_test 1.1 { SELECT * FROM t1 WHERE x=? AND y=$y } {t1 t1x}
40 set y [expr 45.1]
41 do_sqluses_test 1.2 { SELECT * FROM t1 WHERE x=? AND y=$y } {t1}
42 set y [expr 44]
43 do_sqluses_test 1.3 { SELECT * FROM t1 WHERE x=? AND y=$y } {t1}
44 unset -nocomplain y
45 do_sqluses_test 1.4 { SELECT * FROM t1 WHERE x=? AND y=$y } {t1}
47 do_sqluses_test 1.5 { SELECT * FROM t1 WHERE x=? AND y=$y } {t1}
52 do_sqluses_test 2.1 { SELECT * FROM t1 WHERE y=$y ORDER BY x } {t1}
[all …]
H A DwhereB.test41 SELECT x, a, y=b FROM t1, t2 WHERE y=b;
46 SELECT x, a, y=b FROM t1, t2 WHERE b=y;
51 SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
57 SELECT x, a, y=b FROM t1, t2 WHERE y=b;
62 SELECT x, a, y=b FROM t1, t2 WHERE b=y;
67 SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
96 SELECT x, a, y=b FROM t1, t2 WHERE y=b;
101 SELECT x, a, y=b FROM t1, t2 WHERE b=y;
112 SELECT x, a, y=b FROM t1, t2 WHERE y=b;
117 SELECT x, a, y=b FROM t1, t2 WHERE b=y;
[all …]
H A Dtkt1473.test174 CREATE TABLE t2(x,y);
197 SELECT 6 FROM t2 WHERE y=0
199 SELECT 7 FROM t2 WHERE y=1
201 SELECT 8 FROM t2 WHERE y=2
203 SELECT 9 FROM t2 WHERE y=3
205 SELECT 10 FROM t2 WHERE y=4
221 SELECT 6 FROM t2 WHERE y=0
223 SELECT 7 FROM t2 WHERE y=1
225 SELECT 8 FROM t2 WHERE y=2
227 SELECT 9 FROM t2 WHERE y=3
[all …]
H A Dwhere.test34 INSERT INTO t2 SELECT 101-w, x, (SELECT max(y) FROM t1)+1-y, y FROM t1;
724 SELECT y FROM t1 WHERE y>4 AND y<25 ORDER BY rowid;
729 SELECT y FROM t1 WHERE y>=4 AND y<=25 ORDER BY oid;
734 SELECT y FROM t1 WHERE y<=25 ORDER BY _rowid_, w+y;
793 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<196 ORDER BY y;
808 SELECT w FROM t1 WHERE x=3 AND y>100 AND y<196 ORDER BY y;
908 SELECT y FROM t1 WHERE y<25 AND y>4 ORDER BY rowid DESC, y DESC
913 SELECT y FROM t1 WHERE y<25 AND y>=4 ORDER BY rowid DESC
1199 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, y.a||y.b
1204 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a, y.a||y.b
[all …]
H A Dtkt-4dd95f6943.test75 SELECT x, y FROM t2 WHERE x = 1 AND y IN $inexpr ORDER BY x ASC, y ASC;
79 SELECT x, y FROM t2 WHERE x = 2 AND y IN $inexpr ORDER BY x ASC, y DESC;
83 SELECT x, y FROM t2 WHERE x = 3 AND y IN $inexpr ORDER BY x DESC, y ASC;
87 SELECT x, y FROM t2 WHERE x = 4 AND y IN $inexpr ORDER BY x DESC, y DESC;
91 SELECT a, x, y FROM t2, t3 WHERE a = 4 AND x = 1 AND y IN $inexpr
95 SELECT a, x, y FROM t2, t3 WHERE a = 2 AND x = 1 AND y IN $inexpr
100 SELECT a, x, y FROM t2, t3 WHERE a = 4 AND x = 1 AND y IN $inexpr
104 SELECT a, x, y FROM t2, t3 WHERE a = 2 AND x = 1 AND y IN $inexpr
109 SELECT a, x, y FROM t2, t3 WHERE a = 4 AND x = 1 AND y IN $inexpr
113 SELECT a, x, y FROM t2, t3 WHERE a = 2 AND x = 1 AND y IN $inexpr
[all …]
H A Dtkt-a8a0d2996a.test23 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';
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';
46 SELECT typeof(x), typeof(y) FROM t WHERE 1=x*1 AND y=='1';
49 SELECT typeof(x), typeof(y) FROM t WHERE 1=x/1 AND y=='1';
52 SELECT typeof(x), typeof(y) FROM t WHERE 1=x%4 AND y=='1';
[all …]
H A Dselect6.test51 SELECT DISTINCT y FROM t1 ORDER BY y;
76 WHERE a.y=b.y ORDER BY a.y
84 WHERE a.y=b.y ORDER BY a.y
99 (SELECT max(x) as r, y as s, min(x)+y FROM t1 GROUP BY y) as b
242 SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)
248 SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)
256 (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
262 SELECT y FROM (SELECT DISTINCT y FROM t1) WHERE y<5 ORDER BY y
267 SELECT DISTINCT y FROM (SELECT y FROM t1) WHERE y<5 ORDER BY y
272 SELECT avg(y) FROM (SELECT DISTINCT y FROM t1) WHERE y<5 ORDER BY y
[all …]
H A DjoinF.test37 CREATE TABLE t2(y INT);
47 INNER JOIN t3 ON t2.y IS NOT NULL
55 INNER JOIN t3 ON t2.y IS NOT NULL
64 INNER JOIN t3 ON t2.y IS NOT NULL
72 INNER JOIN t3 ON t2.y IS NOT NULL
99 LEFT JOIN t3 ON t2.y IS NOT NULL
107 LEFT JOIN t3 ON t2.y IS NOT NULL
116 LEFT JOIN t3 ON t2.y IS NOT NULL
124 LEFT JOIN t3 ON t2.y IS NOT NULL
133 LEFT JOIN t3 ON t2.y IS NOT NULL
[all …]
H A Doffset1.test36 SELECT * FROM (SELECT x, y FROM t2 ORDER BY y)
42 SELECT * FROM (SELECT x, y FROM t2 ORDER BY y)
48 SELECT * FROM (SELECT x, y FROM t2 ORDER BY y)
54 SELECT * FROM (SELECT x, y FROM t2 ORDER BY y)
60 SELECT * FROM (SELECT x, y FROM t2 ORDER BY y)
66 SELECT * FROM (SELECT x, y FROM t2 ORDER BY y)
72 SELECT * FROM (SELECT x, y FROM t2 ORDER BY y)
78 SELECT * FROM (SELECT x, y FROM t2 ORDER BY y)
84 SELECT * FROM (SELECT x, y FROM t2 ORDER BY y)
90 SELECT * FROM (SELECT x, y FROM t2 ORDER BY y)
[all …]
H A Dresolver01.test34 SELECT 1 AS y FROM t1, t2 ORDER BY y;
45 SELECT x AS y FROM t3 ORDER BY y;
77 SELECT 2 AS y FROM t1, t2 ORDER BY y COLLATE nocase;
87 SELECT x AS y FROM t3 ORDER BY y COLLATE nocase;
115 SELECT 3 AS y FROM t1, t2 ORDER BY +y;
125 SELECT x AS y FROM t3 ORDER BY +y;
152 } {1 x 1 y 1 z 2 x 2 y 2 z 3 z 3 y 3 x}
180 } {1 y 2 x}
184 } {1 y 2 x}
207 SELECT 2 AS x WHERE (SELECT x AS y WHERE 3>y);
[all …]
H A DanalyzeF.test50 2 "x = 19 AND y = 4" {t1y (y=?)}
52 4 "x = '19' AND y = '4'" {t1y (y=?)}
53 5 "x = substr('5195', 2, 2) AND y = substr('145', 2, 1)" {t1y (y=?)}
59 9 "x = str('19') AND y = str('4')" {t1y (y=?)}
60 10 "x = str('4') AND y = str('19')" {t1y (y=?)}
62 11 "x = nullif('19', 0) AND y = nullif('4', 0)" {t1y (y=?)}
63 12 "x = nullif('4', 0) AND y = nullif('19', 0)" {t1y (y=?)}
75 UPDATE t1 SET y=y+1 WHERE x = substr('145', 2, 1) AND y = func(1, 2, 3)
90 2 "x = det19() AND y = det4()" {t1y (y=?)}
92 3 "x = nondet4() AND y = nondet19()" {t1y (y=?)}
[all …]
H A Dalias.test54 SELECT x, sequence() AS y FROM t1 WHERE y>0
60 SELECT x, sequence() AS y FROM t1 WHERE y>0 AND y<99
66 SELECT x, sequence() AS y FROM t1 WHERE y>0 AND y<99 AND y!=55
73 WHERE y>0 AND y<99 AND y!=55 AND y NOT IN (56,57,58)
74 AND y NOT LIKE 'abc%' AND y%10==2
80 SELECT x, sequence() AS y FROM t1 WHERE y BETWEEN 0 AND 99
86 # SELECT x, sequence() AS y FROM t1 WHERE y IN (55,66,3)
92 SELECT x, 1-sequence() AS y FROM t1 ORDER BY y
98 SELECT x, sequence() AS y FROM t1 ORDER BY -y
104 SELECT x, sequence() AS y FROM t1 ORDER BY x%2, y
[all …]
H A DselectA.test285 ORDER BY y COLLATE NOCASE,x,z
511 EXCEPT SELECT x,y,z FROM t2
513 EXCEPT SELECT y,x,z FROM t2
606 ORDER BY y COLLATE NOCASE,x,z
641 SELECT x,y,z FROM t2
897 ORDER BY y COLLATE NOCASE,x,z
1123 EXCEPT SELECT x,y,z FROM t2
1125 EXCEPT SELECT y,x,z FROM t2
1253 SELECT x,y,z FROM t2
1286 SELECT x,y,z FROM t2
[all …]
H A Dptrchng.test40 CREATE TABLE t1(x INTEGER PRIMARY KEY, y BLOB);
59 SELECT pointer_change(y, 'text', 'noop', 'blob') FROM t1 WHERE x=1
64 SELECT pointer_change(y, 'blob', 'noop', 'text') FROM t1 WHERE x=1
91 SELECT pointer_change(y, 'text', 'noop', 'blob') FROM t1 WHERE x=3
96 SELECT pointer_change(y, 'blob', 'noop', 'text') FROM t1 WHERE x=3
127 SELECT pointer_change(y, 'text', 'noop', 'blob') FROM t1 WHERE x=2
194 SELECT pointer_change(y, 'text', 'bytes', 'text') FROM t1
199 SELECT pointer_change(y, 'blob', 'bytes', 'blob') FROM t1
207 SELECT pointer_change(y, 'text', 'bytes', 'blob') FROM t1
213 SELECT pointer_change(y, 'text16', 'noop', 'blob') FROM t1
[all …]
H A Dwhere2.test463 SELECT x.a, y.a FROM t2249a x CROSS JOIN t2249a y WHERE x.a=y.a
474 SELECT x.a,y.a FROM t2249a x CROSS JOIN t2249a y
475 WHERE x.a=y.a OR y.a='hello'
480 SELECT x.a,y.a FROM t2249a x CROSS JOIN t2249a y
481 WHERE y.a=x.a OR y.a='hello'
486 SELECT x.a,y.a FROM t2249a x CROSS JOIN t2249a y
487 WHERE y.a='hello' OR x.a=y.a
505 select y from t8, t9 where a=1 order by a, y;
546 AND +y IN (SELECT y FROM tx WHERE rowid=1)
553 AND y IN (SELECT y FROM tx WHERE rowid<0)
[all …]
H A Dselect5.test34 execsql {SELECT DISTINCT y FROM t1 ORDER BY y}
40 execsql {SELECT y, count(*) FROM t1 GROUP BY y ORDER BY y}
43 execsql {SELECT y, count(*) FROM t1 GROUP BY y ORDER BY count(*), y}
46 execsql {SELECT count(*), y FROM t1 GROUP BY y ORDER BY count(*), y}
53 SELECT y, count(*) FROM t1 GROUP BY z ORDER BY y
58 SELECT y, count(*) FROM t1 GROUP BY temp.t1.y ORDER BY y
63 SELECT y, count(*) FROM t1 GROUP BY z(y) ORDER BY y
69 SELECT y, count(*) FROM t1 GROUP BY y HAVING count(*)<3 ORDER BY y
75 SELECT y, count(*) FROM t1 GROUP BY y HAVING z(y)<3 ORDER BY y
81 SELECT y, count(*) FROM t1 GROUP BY y HAVING count(*)<z ORDER BY y
[all …]
H A Drowvalue9.test42 CREATE TABLE a2(x BLOB, y BLOB);
43 INSERT INTO a2(x, y) VALUES(1, 1);
44 INSERT INTO a2(x, y) VALUES(2, '2');
45 INSERT INTO a2(x, y) VALUES('3', 3);
50 SELECT x, typeof(x), y, typeof(y) FROM a2 ORDER BY rowid
126 CREATE TABLE c2(x BLOB, y BLOB);
152 CREATE TABLE d2(x BLOB, y BLOB);
174 CREATE INDEX idx1 ON d2(x, y);
224 CREATE TABLE e2(x BLOB, y BLOB);
275 CREATE TABLE g2(x, y);
[all …]
H A DmallocF.test32 CREATE TABLE t1(x,y);
43 CREATE TABLE t1(x PRIMARY KEY,y UNIQUE);
49 WHERE y=1 OR y=2 OR y=3 OR y=4 OR y=5
50 OR y=6 OR y=7 OR y=8 OR y=9 OR y=10
51 OR y=11 OR y=12 OR y=13 OR y=14 OR y=15
52 OR y=x
56 CREATE TABLE t1(x PRIMARY KEY,y UNIQUE);
61 SELECT x FROM t1 WHERE y BETWEEN 10 AND 29
H A Dminmax3.test41 CREATE TABLE t1(x, y, z);
78 count { SELECT max(y) FROM t1 WHERE x = '2' AND y != 'V'; }
81 count { SELECT max(y) FROM t1 WHERE x = '2' AND y < 'V'; }
111 count { SELECT min(y) FROM t1; }
114 # Index i1 optimizes the min(y)
116 count { SELECT min(y) FROM t1; }
119 # Index i1 optimizes the min(y)
121 count { SELECT min(y) FROM t1; }
130 # Index i1 optimizes the max(y)
135 # Index i1 optimizes the max(y)
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5ac.test28 0 {p o q e z k z p n f y u z y n y} {l o o l v v k}
31 3 {x g y m y m h p} {k j j b r e y y a k y}
36 8 {y g w u b q p o m j y b p a e k} {r i d k y w o z q m a t p}
53 25 {d i x y x x k i y f s d j h z p n} {l l q m e t c w g y h t s v g}
61 33 {c g n f u d o y o b} {e y o h x x y y i z s b h a j}
62 34 {v y h c q u u s q y x x k s q} {d n r m y k n t i r n w e}
89 61 {s a z i e r f i w c n y v z t k s} {y y i r y n l s b w i e k n}
96 68 {y a h u h i m a y q} {d d r x h e v q n z y c j}
102 74 {g d y n o h p s y q z j d w n h w} {x o d l t j i b r d o r y}
189 4.4 "{y y}:b"
[all …]
H A Dfts5auto.test28 {w v i y r} {i p y s}
29 {a o q v e n q r} {q v g u c y a z y}
63 {o u d n w o m o o s n t r h} {k p e u y p e z d j r y g}
76 {v u d c} {v y y j s g}
81 {d o c u k f o} {r y s x z s p p h g t p y c}
113 {t v o d w} {w e q w h y c y y i j b a m}
220 {q u s y b w u g y g f o} {y}
257 y m z m
321 set b [replace_elems $bigdoc 20 y 21 x 887 x 888 y]
332 2 y
[all …]
/sqlite-3.40.0/mptest/
H A Dmultiwrite01.test175 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
179 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
185 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
189 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
195 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
199 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
205 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
209 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
215 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
219 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
[all …]
/sqlite-3.40.0/ext/lsm1/
H A Dlsm_varint.c70 z[0] = (unsigned char)(y>>24); in lsmVarintWrite32()
72 z[2] = (unsigned char)(y>>8); in lsmVarintWrite32()
73 z[3] = (unsigned char)(y); in lsmVarintWrite32()
82 unsigned int w, y; in lsmSqlite4PutVarint64() local
100 y = (unsigned int)x; in lsmSqlite4PutVarint64()
103 if( y<=16777215 ){ in lsmSqlite4PutVarint64()
111 lsmVarintWrite32(z+1, y); in lsmSqlite4PutVarint64()
117 lsmVarintWrite32(z+2, y); in lsmSqlite4PutVarint64()
124 lsmVarintWrite32(z+3, y); in lsmSqlite4PutVarint64()
132 lsmVarintWrite32(z+4, y); in lsmSqlite4PutVarint64()
[all …]
/sqlite-3.40.0/ext/rtree/
H A DrtreeF.test20 # CREATE TABLE t2(y);
37 CREATE TABLE t2(y);
49 SELECT y FROM t2 ORDER BY y;
52 DELETE FROM t2 WHERE y=3;
56 SELECT y FROM t2 ORDER BY y;
60 DELETE FROM t2 WHERE y=5;
64 SELECT y FROM t2 ORDER BY y;
68 DELETE FROM t2 WHERE y=5;
72 SELECT y FROM t2 ORDER BY y;
75 DELETE FROM t2 WHERE y=2;
[all …]

12345678910>>...27