Home
last modified time | relevance | path

Searched refs:x (Results 1 – 25 of 1134) sorted by relevance

12345678910>>...46

/sqlite-3.40.0/test/
H A Dfts3offsets.test71 2 {(A) x x C x x x C}
81 INSERT INTO xx(rowid, x) VALUES(5, 'A x x x x x x x x x C');
82 INSERT INTO xx(rowid, x) VALUES(6, 'A x x x x x x x x x x x B');
91 4 {(A) (B) (C) x x x x x x x B}
92 5 {(A) x x x x x x x x x C}
93 6 {(A) x x x x x x x x x x x B}
104 INSERT INTO xx(rowid, x) VALUES(3, 'A x x x x x x x x x C');
105 INSERT INTO xx(rowid, x) VALUES(2, 'A x x x x x x x x x x x B');
115 4 {(A) (B) (C) x x x x x x x B}
116 3 {(A) x x x x x x x x x C}
[all …]
H A Dselect4.test704 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
713 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
718 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
727 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
732 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
741 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
746 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
755 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
769 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
780 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
[all …]
H A Dlike2.test24 INSERT INTO t1(x,y) VALUES(1,CAST(x'01' AS TEXT));
25 INSERT INTO t1(x,y) VALUES(2,CAST(x'02' AS TEXT));
26 INSERT INTO t1(x,y) VALUES(3,CAST(x'03' AS TEXT));
27 INSERT INTO t1(x,y) VALUES(4,CAST(x'04' AS TEXT));
28 INSERT INTO t1(x,y) VALUES(5,CAST(x'05' AS TEXT));
29 INSERT INTO t1(x,y) VALUES(6,CAST(x'06' AS TEXT));
30 INSERT INTO t1(x,y) VALUES(7,CAST(x'07' AS TEXT));
31 INSERT INTO t1(x,y) VALUES(8,CAST(x'08' AS TEXT));
32 INSERT INTO t1(x,y) VALUES(9,CAST(x'09' AS TEXT));
33 INSERT INTO t1(x,y) VALUES(10,CAST(x'0a' AS TEXT));
[all …]
H A Dtkt-9a8b09f8e6.test61 SELECT x FROM t1 WHERE x IN (1);
67 SELECT x FROM t1 WHERE x IN (1.0);
73 SELECT x FROM t1 WHERE x IN ('1');
85 SELECT x FROM t1 WHERE 1 IN (x);
91 SELECT x FROM t1 WHERE 1.0 IN (x);
97 SELECT x FROM t1 WHERE '1' IN (x);
109 SELECT x FROM t2 WHERE x IN (1);
133 SELECT x FROM t2 WHERE 1 IN (x);
157 SELECT x FROM t3 WHERE x IN (1);
181 SELECT x FROM t3 WHERE 1 IN (x);
[all …]
H A Dnormalize.test288 {SELECT * FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (x));}
290 {0 {SELECT*FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(x));}}
293 {SELECT x FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (
294 SELECT x FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (
295 SELECT x FROM t1 WHERE x IN (x)))));}
297 … {SELECT x FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(SELECT x FRO…
300 {SELECT x FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (
301 SELECT x FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (
304 …{0 {SELECT x FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(SELECT x F…
307 {SELECT x FROM t1 WHERE x IN (1) UNION ALL SELECT x FROM t1 WHERE x IN (1);}
[all …]
H A Dwidetab1.test85 x+00, x+01, x+02, x+03, x+04, x+05, x+06, x+07, x+08, x+09,
86 x+10, x+11, x+12, x+13, x+14, x+15, x+16, x+17, x+18, x+19,
87 x+20, x+21, x+22, x+23, x+24, x+25, x+26, x+27, x+28, x+29,
88 x+30, x+31, x+32, x+33, x+34, x+35, x+36, x+37, x+38, x+39,
89 x+40, x+41, x+42, x+43, x+44, x+45, x+46, x+47, x+48, x+49,
90 x+50, x+51, x+52, x+53, x+54, x+55, x+56, x+57, x+58, x+59,
91 x+60, x+61, x+62, x+63, x+64, x+65, x+66, x+67, x+68, x+69,
92 x+70, x+71, x+72, x+73, x+74, x+75, x+76, x+77, x+78, x+79,
93 x+80, x+81, x+82, x+83, x+84, x+85, x+86, x+87, x+88, x+89,
94 x+90, x+91, x+92, x+93, x+94, x+95, x+96, x+97, x+98, x+99,
[all …]
H A Dbadutf.test24 } {0 {x 80}}
27 } {0 {x 81}}
30 } {0 {x BF}}
33 } {0 {x C0}}
36 } {0 {x E0}}
39 } {0 {x F0}}
42 } {0 {x FF}}
94 } {0 {x 1}}
97 } {0 {x 3}}
100 } {0 {x 3}}
[all …]
H A Dfts3misc.test141 SELECT * FROM t3 WHERE t3 MATCH '"a* b* x* a*"'
183 INSERT INTO t5 VALUES('a x x x x b x x x x c');
184 INSERT INTO t5 VALUES('a x x x x b x x x x c');
185 INSERT INTO t5 VALUES('a x x x x b x x x x c');
214 INSERT INTO t6 SELECT 'x x x x x x x x x x x' FROM s;
216 INSERT INTO t6 VALUES('x x x x x x x x x x x A');
217 INSERT INTO t6 VALUES('x x x x x x x x x x x B');
218 INSERT INTO t6 VALUES('x x x x x x x x x x x A');
219 INSERT INTO t6 VALUES('x x x x x x x x x x x B');
222 INSERT INTO t6 SELECT 'x x x x x x x x x x x' FROM s;
[all …]
H A Dwith6.test26 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
77 SELECT c1.x||c2.x||c3.x
84 SELECT c1.x||c2.x||c3.x
113 SELECT c1.x||c2.x||c3.x
120 SELECT c1.x||c2.x||c3.x
141 SELECT c1.x||c2.x||c3.x
148 SELECT c1.x||c2.x||c3.x
169 SELECT c2.x + 100*(SELECT sum(x+1) FROM c WHERE c.x<=c2.x)
174 SELECT c2.x + 100*(SELECT sum(x+1) FROM c WHERE c.x<=c2.x)
187 SELECT c2.x + 100*(SELECT sum(x+1) FROM c WHERE c.x<=c2.x)
[all …]
H A Dboundary4.tcl30 foreach x {
40 set x [expr {wide($x)}]
64 foreach x $y {
84 set mn $x
122 set t1rx($r) $x
123 set t1xr($x) $r
180 set r $t1xr($x)
184 maketest 1.12 {SELECT rowid, a, x FROM t1 ORDER BY x} $ans
192 maketest 1.14 {SELECT rowid, a, x FROM t1 ORDER BY x DESC} $ans
232 maketest 2.12 {SELECT a, rowid, x FROM t1 ORDER BY x} $ans
[all …]
H A Dlike3.test22 # INSERT INTO t1(x) VALUES(x'616263');
81 SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x;
84 SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x DESC;
87 SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY +x DESC;
90 SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x ASC;
93 SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY +x ASC;
100 SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x;
103 SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x DESC;
106 SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY +x DESC;
109 SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x ASC;
[all …]
H A Dlike.test570 SELECT x FROM t2 WHERE x LIKE 'zz%';
575 SELECT x FROM t2 WHERE x LIKE 'zZ%';
580 SELECT x FROM t2 WHERE x LIKE 'Zz%';
585 SELECT x FROM t2 WHERE x LIKE 'ZZ%';
652 SELECT 2, x FROM t8 WHERE x LIKE '%h%' ESCAPE 'x';
661 SELECT 2, x FROM t8 WHERE x LIKE '%h%' ESCAPE 'x';
668 SELECT 2, x FROM t8 WHERE x LIKE '%h%' ESCAPE 'x';
675 SELECT 2, x FROM t8 WHERE x LIKE '%h%' ESCAPE 'x';
692 SELECT x FROM t2 WHERE x LIKE 'x%'
716 SELECT substr(x,2) AS x FROM t2 WHERE +x LIKE '%ff%25'
[all …]
H A Dtkt-4dd95f6943.test19 CREATE TABLE t1(x);
31 SELECT x FROM t1 WHERE x IN(2, 4, 5) ORDER BY x ASC;
35 SELECT x FROM t1 WHERE x IN(2, 4, 5) ORDER BY x DESC;
75 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
[all …]
H A Dnan.test42 db eval {SELECT x, typeof(x) FROM t1}
77 UPDATE t1 SET x=x-x;
78 SELECT x, typeof(x) FROM t1;
131 UPDATE t1 SET x=x-x;
167 SELECT x, typeof(x) FROM t1
329 SELECT x, typeof(x) FROM t1;
336 SELECT x, typeof(x) FROM t1;
344 SELECT x, typeof(x) FROM t1;
351 SELECT x, typeof(x) FROM t1;
358 SELECT x, typeof(x) FROM t1;
[all …]
H A Dwhere5.test24 CREATE TABLE t1(x TEXT);
25 CREATE TABLE t2(x INTEGER);
34 SELECT * FROM t1 WHERE x<0
44 SELECT * FROM t1 WHERE x=0
54 SELECT * FROM t1 WHERE x>0
249 SELECT x<NULL FROM t3
254 SELECT x<=NULL FROM t3
259 SELECT x==NULL FROM t3
264 SELECT x>NULL FROM t3
269 SELECT x>=NULL FROM t3
[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';
86 SELECT '-9223372036854775807x'-'1x';
89 SELECT '9223372036854775806x'+'1x';
[all …]
H A Dwith5.test49 SELECT x FROM closure ORDER BY x;
59 SELECT x FROM closure ORDER BY x;
69 SELECT x FROM closure ORDER BY x;
81 SELECT x FROM closure ORDER BY x;
93 SELECT x FROM closure ORDER BY x;
106 SELECT x FROM closure ORDER BY x;
118 SELECT x FROM closure ORDER BY x;
123 SELECT 1 AS x
134 SELECT 1 AS x
168 SELECT x FROM closure ORDER BY +x;
[all …]
H A DmallocK.test22 for {set x 1} {$x<5} {incr x} {
31 for {set x 1} {$x<5} {incr x} {
39 for {set x 1} {$x<5} {incr x} {
47 for {set x 1} {$x<5} {incr x} {
60 for {set x 1} {$x<5} {incr x} {
84 INSERT INTO t3 VALUES('one', '..x.x', 5);
88 INSERT INTO t3 VALUES('one', '.x..x', 9);
89 INSERT INTO t3 VALUES('one', '.x.x.', 10);
97 INSERT INTO t3 VALUES('two', 'x...x', 17);
98 INSERT INTO t3 VALUES('two', 'x..x.', 18);
[all …]
H A Dlimit.test41 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
50 execsql {SELECT x FROM t1 ORDER BY x+1 LIMIT 2, -5}
59 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
167 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
175 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
183 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x ORDER BY x DESC LIMIT 31;
197 SELECT count(*), sum(x), sum(y), min(x), max(x), min(y), max(y) FROM t5;
426 SELECT x FROM t1 WHERE x<10 LIMIT :limit;
433 SELECT x FROM t1 WHERE x<10 LIMIT :limit;
441 SELECT x FROM t1 WHERE x<10 LIMIT :limit;
[all …]
H A Dfunc4.test377 x INTEGER CHECK(tointeger(x) IS NOT NULL)
382 INSERT INTO t1 (x) VALUES (NULL);
387 INSERT INTO t1 (x) VALUES (NULL);
392 INSERT INTO t1 (x) VALUES ('');
412 INSERT INTO t1 (x) VALUES (1234);
437 INSERT INTO t1 (x) VALUES (X'');
473 SELECT x FROM t1 WHERE x>0 ORDER BY x;
479 x REAL CHECK(toreal(x) IS NOT NULL)
494 INSERT INTO t2 (x) VALUES ('');
553 SELECT x FROM t2 ORDER BY x;
[all …]
H A Dwindow6.test56 set A(%x) x
153 SELECT LIKE('!', '', '!') x WHERE x;
217 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
218 SELECT x, group_concat(x) OVER (ORDER BY x ROWS 2 PRECEDING)
224 # WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
225 # SELECT x, group_concat(x) OVER (ORDER BY x RANGE 2 PRECEDING)
230 # WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
236 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
241 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
246 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
[all …]
H A Dtkt1473.test174 CREATE TABLE t2(x,y);
187 SELECT 1 FROM t2 WHERE x=0
189 SELECT 2 FROM t2 WHERE x=1
191 SELECT 3 FROM t2 WHERE x=2
193 SELECT 4 FROM t2 WHERE x=3
195 SELECT 5 FROM t2 WHERE x=4
211 SELECT 1 FROM t2 WHERE x=0
213 SELECT 2 FROM t2 WHERE x=1
215 SELECT 3 FROM t2 WHERE x=2
217 SELECT 4 FROM t2 WHERE x=3
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5fault5.test31 db eval { CREATE VIRTUAL TABLE abc USING fts5(x,y) }
43 CREATE VIRTUAL TABLE tt USING fts5(x);
73 CREATE VIRTUAL TABLE tt USING fts5(x);
111 0 x 1 {} 1 x 1 {} 10 x 1 {} 11 x 1 {} 12 x 1 {} 13 x 1 {}
112 14 x 1 {} 15 x 1 {} 16 x 1 {} 17 x 1 {} 18 x 1 {} 19 x 1 {}
113 2 x 1 {} 3 x 1 {} 4 x 1 {} 5 x 1 {} 6 x 1 {} 7 x 1 {} 8 x 1 {}
114 9 x 1 {}
122 0 x 1 {} 1 x 1 {} 10 x 1 {} 11 x 1 {} 12 x 1 {} 13 x 1 {} \
123 14 x 1 {} 15 x 1 {} 16 x 1 {} 17 x 1 {} 18 x 1 {} 19 x 1 {} \
124 2 x 1 {} 3 x 1 {} 4 x 1 {} 5 x 1 {} 6 x 1 {} 7 x 1 {} 8 x 1 {} \
[all …]
/sqlite-3.40.0/src/
H A Drandom.c41 u32 x[16]; in chacha_block() local
42 memcpy(x, in, 64); in chacha_block()
44 QR(x[0], x[4], x[ 8], x[12]); in chacha_block()
45 QR(x[1], x[5], x[ 9], x[13]); in chacha_block()
46 QR(x[2], x[6], x[10], x[14]); in chacha_block()
47 QR(x[3], x[7], x[11], x[15]); in chacha_block()
48 QR(x[0], x[5], x[10], x[15]); in chacha_block()
49 QR(x[1], x[6], x[11], x[12]); in chacha_block()
50 QR(x[2], x[7], x[ 8], x[13]); in chacha_block()
51 QR(x[3], x[4], x[ 9], x[14]); in chacha_block()
[all …]
/sqlite-3.40.0/
H A Dinstall-sh57 while [ x"$1" != x ]; do
94 *) if [ x"$src" = x ]
107 if [ x"$src" = x ]
115 if [ x"$dir_arg" != x ]; then
139 if [ x"$dst" = x ]
193 if [ x"$dir_arg" != x ]
197 if [ x"$chowncmd" != x ]; then $doit $chowncmd $dst; else true ; fi &&
198 if [ x"$chgrpcmd" != x ]; then $doit $chgrpcmd $dst; else true ; fi &&
200 if [ x"$chmodcmd" != x ]; then $doit $chmodcmd $dst; else true ; fi
205 if [ x"$transformarg" = x ]
[all …]

12345678910>>...46