Home
last modified time | relevance | path

Searched refs:t1 (Results 1 – 25 of 1148) sorted by relevance

12345678910>>...46

/sqlite-3.40.0/test/
H A Drandexpr1.test401 …t1.a*t1.e when 17 then coalesce((select +t1.b from t1 where t1.c<>t1.c and e between +(abs(case b+…
404 …t1.a*t1.e when 17 then coalesce((select +t1.b from t1 where t1.c<>t1.c and e between +(abs(case b+…
950 …t1.c)<=a-11*t1.e)) then t1.b else a end | ((abs(b*(abs(t1.e | +c)/abs(11)))/abs(t1.a))) FROM t1 WH…
1490 …t1.c*f from t1 where t1.f-+coalesce((select max(t1.d) from t1 where - -t1.e in (select f from t1 …
1649 …t1.f-t1.b | coalesce((select max((select max(case -case when t1.f>coalesce((select max(case when …
1652 …t1.f-t1.b | coalesce((select max((select max(case -case when t1.f>coalesce((select max(case when …
1655 …t1.f-t1.b & coalesce((select max((select max(case -case when t1.f>coalesce((select max(case when …
2849 …t1.d*case when case when ~ -t1.d+17-b-13*t1.f*(abs(t1.b+13)/abs(t1.a))+a*t1.e*t1.a+c*t1.d-t1.a in …
2852 …t1.d*case when case when ~ -t1.d+17-b-13*t1.f*(abs(t1.b+13)/abs(t1.a))+a*t1.e*t1.a+c*t1.d-t1.a in …
6068 …t1.b-coalesce((select max(t1.f) from t1 where +t1.c=e or coalesce((select max(t1.a) from t1 where …
[all …]
H A Dboundary3.test260 SELECT t1.* FROM t1, t2 WHERE t1.rowid=16384 AND t2.a=t1.a
463 SELECT t1.* FROM t1, t2 WHERE t1.rowid=4294967296 AND t2.a=t1.a
666 SELECT t1.* FROM t1, t2 WHERE t1.rowid=16777216 AND t2.a=t1.a
869 SELECT t1.* FROM t1, t2 WHERE t1.rowid=-32769 AND t2.a=t1.a
1219 SELECT t1.* FROM t1, t2 WHERE t1.rowid=2 AND t2.a=t1.a
1422 SELECT t1.* FROM t1, t2 WHERE t1.rowid=4 AND t2.a=t1.a
1772 SELECT t1.* FROM t1, t2 WHERE t1.rowid=256 AND t2.a=t1.a
4634 SELECT t1.* FROM t1, t2 WHERE t1.rowid=-3 AND t2.a=t1.a
4837 SELECT t1.* FROM t1, t2 WHERE t1.rowid=0 AND t2.a=t1.a
5040 SELECT t1.* FROM t1, t2 WHERE t1.rowid=-1 AND t2.a=t1.a
[all …]
H A DjoinD.test82 FROM t1 INNER JOIN t2 ON t1.b=t2.b
94 FROM t1 INNER JOIN t2 ON t1.b=t2.b
166 FROM t1 INNER JOIN t2 ON t1.b=t2.b
190 FROM t1 INNER JOIN t2 ON t1.b=t2.b
202 FROM t1 INNER JOIN t2 ON t1.b=t2.b
329 FROM t1 INNER JOIN t2 ON t1.b=t2.b
353 FROM t1 INNER JOIN t2 ON t1.b=t2.b
485 FROM t1 INNER JOIN t2 ON t1.b=t2.b
509 FROM t1 INNER JOIN t2 ON t1.b=t2.b
533 FROM t1 INNER JOIN t2 ON t1.b=t2.b
[all …]
H A Dnotnull.test27 CREATE TABLE t1 (
34 SELECT * FROM t1;
39 DELETE FROM t1;
46 DELETE FROM t1;
54 DELETE FROM t1;
61 DELETE FROM t1;
69 DELETE FROM t1;
77 DELETE FROM t1;
84 DELETE FROM t1;
91 DELETE FROM t1;
[all …]
H A Dexpr.test399 test_expr expr-3.1 {t1='abc', t2='xyz'} {t1<t2} 1
400 test_expr expr-3.2 {t1='xyz', t2='abc'} {t1<t2} 0
401 test_expr expr-3.3 {t1='abc', t2='abc'} {t1<t2} 0
405 test_expr expr-3.7 {t1='abc', t2='xyz'} {t1>t2} 0
406 test_expr expr-3.8 {t1='xyz', t2='abc'} {t1>t2} 1
407 test_expr expr-3.9 {t1='abc', t2='abc'} {t1>t2} 0
446 test_expr expr-4.1 {t1='abc', t2='Abc'} {t1<t2} 0
447 test_expr expr-4.2 {t1='abc', t2='Abc'} {t1>t2} 1
448 test_expr expr-4.3 {t1='abc', t2='Bbc'} {t1<t2} 0
450 test_expr expr-4.5 {t1='0', t2='0.0'} {t1==t2} 0
[all …]
H A Dboundary1.test26 CREATE TABLE t1(a,x);
91 CREATE INDEX t1i1 ON t1(a);
92 CREATE INDEX t1i2 ON t1(x);
97 SELECT count(*) FROM t1
112 SELECT rowid, x FROM t1 WHERE a=17
217 SELECT * FROM t1 WHERE rowid=16384
227 SELECT rowid, x FROM t1 WHERE a=16
457 SELECT rowid, x FROM t1 WHERE a=6
792 SELECT * FROM t1 WHERE rowid=2
907 SELECT * FROM t1 WHERE rowid=4
[all …]
H A Dtkt2927.test29 CREATE TABLE t1(a, b);
35 SELECT * FROM t1;
42 SELECT a, b FROM t1
44 SELECT a, b FROM t1
50 SELECT a, b FROM t1
57 SELECT a, b FROM t1
64 SELECT a, b FROM t1
73 SELECT a, b FROM t1
101 SELECT a, b FROM t1
129 SELECT a, b FROM t1
[all …]
H A Dboundary2.test91 CREATE INDEX t1i1 ON t1(r);
92 CREATE INDEX t1i2 ON t1(a);
93 CREATE INDEX t1i3 ON t1(x);
98 SELECT count(*) FROM t1
113 SELECT r, x FROM t1 WHERE a=17
218 SELECT * FROM t1 WHERE r=16384
228 SELECT r, x FROM t1 WHERE a=16
458 SELECT r, x FROM t1 WHERE a=6
793 SELECT * FROM t1 WHERE r=2
908 SELECT * FROM t1 WHERE r=4
[all …]
H A Dnormalize.test243 {SELECT * FROM t1 WHERE x IN (SELECT x FROM t1);}
245 {0 {SELECT*FROM t1 WHERE x IN(SELECT x FROM t1);}}
248 {SELECT * FROM t1 WHERE x IN ((SELECT x FROM t1));}
250 {0 {SELECT*FROM t1 WHERE x IN((SELECT x FROM t1));}}
278 {SELECT * FROM t1 WHERE x IN (SELECT x FROM t1);}
280 {0 {SELECT*FROM t1 WHERE x IN(SELECT x FROM t1);}}
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 (
297 …{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…
300 {SELECT x FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (
[all …]
H A Dindex4.test24 INSERT INTO t1 SELECT randomblob(102) FROM t1; -- 2
25 INSERT INTO t1 SELECT randomblob(102) FROM t1; -- 4
26 INSERT INTO t1 SELECT randomblob(102) FROM t1; -- 8
27 INSERT INTO t1 SELECT randomblob(102) FROM t1; -- 16
28 INSERT INTO t1 SELECT randomblob(102) FROM t1; -- 32
29 INSERT INTO t1 SELECT randomblob(102) FROM t1; -- 64
30 INSERT INTO t1 SELECT randomblob(102) FROM t1; -- 128
31 INSERT INTO t1 SELECT randomblob(102) FROM t1; -- 256
32 INSERT INTO t1 SELECT randomblob(102) FROM t1; -- 512
33 INSERT INTO t1 SELECT randomblob(102) FROM t1; -- 1024
[all …]
H A DanalyzeE.test39 } {/SCAN t1/}
71 } {/SCAN t1/}
79 } {/SCAN t1/}
91 } {/SCAN t1/}
123 } {/SCAN t1/}
131 } {/SCAN t1/}
148 } {/SCAN t1/}
180 } {/SCAN t1/}
188 } {/SCAN t1/}
200 } {/SCAN t1/}
[all …]
H A Dsavepointfault.test21 CREATE TABLE t1(a, b, c);
27 DELETE FROM t1;
36 INSERT INTO t1 SELECT
38 INSERT INTO t1
40 INSERT INTO t1
42 INSERT INTO t1
44 INSERT INTO t1
46 INSERT INTO t1
48 INSERT INTO t1
50 INSERT INTO t1
[all …]
H A Dwherelimit.test24 DROP TABLE IF EXISTS t1;
25 CREATE TABLE t1(x int, y int);
41 execsql { CREATE TABLE t1(x, y) }
65 catchsql {UPDATE t1 AS a SET y=1 WHERE t1.x=1}
66 } {1 {no such column: t1.x}}
76 execsql { DROP TABLE t1 }
84 execsql {DELETE FROM t1}
309 CREATE TABLE t1(a int);
310 INSERT INTO t1 VALUES(1);
311 INSERT INTO t1 VALUES(2);
[all …]
H A DcorruptM.test45 } {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 |}
88 } {table t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
99 } {view t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
122 } {table t1 t1 | table i1 t1 | view v2 v2 | trigger r1 t1 |}
133 } {table t1 t1 | view i1 t1 | view v2 v2 | trigger r1 t1 |}
145 } {table t1 t1 | index i1 t1 | table v2 v2 | trigger r1 t1 |}
156 } {table t1 t1 | index i1 t1 | view v3 v3 | trigger r1 t1 |}
[all …]
H A Dsavepoint4.test37 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
38 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
39 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
40 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
41 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
42 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
43 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
44 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
45 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
96 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
[all …]
H A Dwhere9.test310 FROM t1 LEFT JOIN t2 ON (t1.c=t2.c AND t1.d=t2.d) OR t1.f=t2.f
318 FROM t1 LEFT JOIN t2 ON (t1.c+1=t2.c AND t1.d=t2.d) OR (t1.f||'x')=t2.f
326 FROM t1 LEFT JOIN t2 ON (t1.c=t2.c AND t1.d=t2.d) OR (t1.f)=t2.f
327 WHERE t1.a=80 OR t1.b=880 OR (t1.c=27027 AND round(t1.d)==80)
334 FROM t1 LEFT JOIN t2 ON (t1.c+1=t2.c AND t1.d=t2.d) OR (t1.f||'x')=t2.f
335 WHERE t1.a=80 OR t1.b=880 OR (t1.c=27027 AND round(t1.d)==80)
344 WHERE t1.a=t3.y OR t1.b=t3.y*11 OR (t1.c=27027 AND round(t1.d)==80)
352 t1 LEFT JOIN t2 ON (t1.c=t2.c AND t1.d=t2.d) OR (t1.f)=t2.f
353 WHERE t1.a=t3.y OR t1.b=t3.y*11 OR (t1.c=27027 AND round(t1.d)==80)
362 WHERE t1.a=80 AND ((t1.c=t2.c AND t1.d=t2.d) OR t1.f=t2.f)
[all …]
H A Dupsert1.test23 SELECT * FROM t1;
26 DELETE FROM t1;
29 SELECT * FROM t1;
32 DELETE FROM t1;
51 DELETE FROM t1;
57 DROP TABLE t1;
68 DELETE FROM t1;
75 DELETE FROM t1;
108 DROP TABLE t1;
120 DROP TABLE t1;
[all …]
H A Dmisc2.test88 SELECT t1.b+t2.b AS a, t1.a, t2.a FROM t1, t2 WHERE a==10
157 SELECT * FROM t1;
194 DELETE FROM t1;
209 DELETE FROM t1;
224 DELETE FROM t1;
239 DELETE FROM t1;
254 DELETE FROM t1;
294 DELETE FROM t1;
309 DELETE FROM t1;
324 DELETE FROM t1;
[all …]
H A Dorderby3.test39 SELECT t1.a
45 SELECT t1.a
51 SELECT t1.a
57 SELECT t1.a
63 SELECT t1.a
69 SELECT t1.a
75 SELECT t1.a
81 SELECT t1.a
87 SELECT t1.a
93 SELECT t1.a
[all …]
H A Dupsert5.test30 DELETE FROM t1;
40 DELETE FROM t1;
50 DELETE FROM t1;
60 DELETE FROM t1;
70 DELETE FROM t1;
80 DELETE FROM t1;
90 DELETE FROM t1;
100 DELETE FROM t1;
110 DELETE FROM t1;
120 DELETE FROM t1;
[all …]
H A DwhereF.test60 1 "SELECT * FROM t1, t2 WHERE t1.a=t2.e AND t2.d<t1.b AND t1.c!=10"
61 2 "SELECT * FROM t2, t1 WHERE t1.a=t2.e AND t2.d<t1.b AND t1.c!=10"
62 3 "SELECT * FROM t2 CROSS JOIN t1 WHERE t1.a=t2.e AND t2.d<t1.b AND t1.c!=10"
81 1 "SELECT * FROM t1, t2 WHERE t1.a>? AND t2.d>t1.c AND t1.b=t2.e"
82 2 "SELECT * FROM t2, t1 WHERE t1.a>? AND t2.d>t1.c AND t1.b=t2.e"
83 3 "SELECT * FROM t2 CROSS JOIN t1 WHERE t1.a>? AND t2.d>t1.c AND t1.b=t2.e"
101 1 {SELECT t1.a, t1.b, t2.d, t2.e FROM t1, t2
102 WHERE t2.d=t1.b AND t1.a=(t2.d+1) AND t1.b = (t2.e+1)}
104 2 {SELECT t1.a, t1.b, t2.d, t2.e FROM t2, t1
105 WHERE t2.d=t1.b AND t1.a=(t2.d+1) AND t1.b = (t2.e+1)}
[all …]
H A Dfts2a.test31 CREATE VIRTUAL TABLE t1 USING fts2(content);
32 INSERT INTO t1(content) VALUES('one');
33 INSERT INTO t1(content) VALUES('two');
34 INSERT INTO t1(content) VALUES('one two');
35 INSERT INTO t1(content) VALUES('three');
36 INSERT INTO t1(content) VALUES('one three');
39 INSERT INTO t1(content) VALUES('four');
40 INSERT INTO t1(content) VALUES('one four');
41 INSERT INTO t1(content) VALUES('two four');
47 INSERT INTO t1(content) VALUES('five');
[all …]
H A Dmultiplex2.test35 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 2
36 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 4
37 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 8
38 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 16
39 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 32
40 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 64
41 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 128
42 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 256
43 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 512
54 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 2
[all …]
H A Dioerr.test353 INSERT INTO t1 SELECT x FROM t1;
354 INSERT INTO t1 SELECT x FROM t1;
355 INSERT INTO t1 SELECT x FROM t1;
356 INSERT INTO t1 SELECT x FROM t1;
357 INSERT INTO t1 SELECT x FROM t1;
358 INSERT INTO t1 SELECT x FROM t1; /* 64 entries in t1 */
359 INSERT INTO t1 SELECT x FROM t1 LIMIT 14; /* 78 entries in t1 */
447 INSERT INTO t1 SELECT x FROM t1;
448 INSERT INTO t1 SELECT x FROM t1;
449 INSERT INTO t1 SELECT x FROM t1;
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5simple2.test27 SELECT rowid FROM t1('c a b')
132 do_execsql_test 8.1.0 { INSERT INTO t1(t1) VALUES('optimize') }
152 INSERT INTO t1(t1) VALUES('integrity-check');
163 INSERT INTO t1(t1) VALUES('integrity-check');
185 INSERT INTO t1(t1) VALUES('integrity-check');
193 INSERT INTO t1(t1, rank) VALUES('pgsz', 32);
202 SELECT rowid FROM t1;
210 INSERT INTO t1(t1) VALUES('integrity-check');
265 SELECT fts5_test_poslist(t1) FROM t1('b') ORDER BY rank;
280 execsql { INSERT INTO t1(t1) VALUES('integrity-check') }
[all …]

12345678910>>...46