Home
last modified time | relevance | path

Searched refs:t2 (Results 1 – 25 of 701) sorted by relevance

12345678910>>...29

/sqlite-3.40.0/test/
H A Dboundary3.test123 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=17
128 SELECT t2.a FROM t1 JOIN t2 USING(a)
134 SELECT t2.a FROM t2 NATURAL JOIN t1
161 SELECT t2.a FROM t1 JOIN t2 USING(a)
167 SELECT t2.a FROM t2 NATURAL JOIN t1
200 SELECT t2.a FROM t2 NATURAL JOIN t1
233 SELECT t2.a FROM t2 NATURAL JOIN t1
270 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=16
473 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=36
676 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=6
[all …]
H A DjoinD.test60 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
118 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
130 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
142 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
154 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
178 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
272 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
283 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
401 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
425 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
[all …]
H A Dtkt1473.test176 INSERT INTO t2 SELECT x+2, y+2 FROM t2;
177 INSERT INTO t2 SELECT x+4, y+4 FROM t2;
178 INSERT INTO t2 SELECT x+8, y+8 FROM t2;
179 INSERT INTO t2 SELECT x+16, y+16 FROM t2;
180 INSERT INTO t2 SELECT x+32, y+32 FROM t2;
181 INSERT INTO t2 SELECT x+64, y+64 FROM t2;
640 SELECT 1 FROM t2 WHERE x=1 EXCEPT SELECT 2 FROM t2 WHERE y=2
646 SELECT 1 FROM t2 WHERE x=1 EXCEPT SELECT 2 FROM t2 WHERE y=2
653 SELECT 1 FROM t2 WHERE x=1 EXCEPT SELECT 2 FROM t2 WHERE y=2
660 SELECT 1 FROM t2 WHERE x=0 EXCEPT SELECT 2 FROM t2 WHERE y=2
[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
449 test_expr expr-4.4 {t1='abc', t2='Bbc'} {t1>t2} 1
[all …]
H A DjoinF.test37 CREATE TABLE t2(y INT);
46 FROM t1 INNER JOIN t2 ON true
54 FROM t1 INNER JOIN t2 ON true
63 FROM t1 INNER JOIN t2 ON true
71 FROM t1 INNER JOIN t2 ON true
80 FROM t1 INNER JOIN t2 ON true
89 FROM t1 INNER JOIN t2 ON true
98 FROM t1 INNER JOIN t2 ON true
106 FROM t1 INNER JOIN t2 ON true
559 # DROP TABLE IF EXISTS t2;
[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"
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)}
107 3 {SELECT t1.a, t1.b, t2.d, t2.e FROM t2 CROSS JOIN t1
[all …]
H A DjoinC.test53 t2 INNER JOIN (
67 t2 INNER JOIN (
81 t2 INNER JOIN (
95 t2 INNER JOIN (
109 t2 INNER JOIN (
124 t2 INNER JOIN (
139 t2 INNER JOIN (
154 t2 INNER JOIN (
285 t2 LEFT JOIN (
300 t2 LEFT JOIN (
[all …]
H A DwhereB.test32 CREATE TABLE t2(a, b TEXT); -- affinity of t2.b is TEXT
82 DROP TABLE t2;
87 CREATE TABLE t2(a, b BLOB); -- affinity of t2.b is NONE
137 DROP TABLE t2;
142 CREATE TABLE t2(a, b BLOB); -- affinity of t2.b is NONE
193 DROP TABLE t2;
259 CREATE TABLE t2(a, b INT); -- affinity of t2.b is INTEGER
319 CREATE TABLE t2(a, b REAL); -- affinity of t2.b is REAL
379 CREATE TABLE t2(a, b BLOB); -- affinity of t2.b is NONE
438 CREATE TABLE t2(a, b BLOB); -- affinity of t2.b is NONE
[all …]
H A Dtemptable.test99 SELECT * FROM t2;
111 SELECT * FROM t2;
145 DROP TABLE t2;
159 SELECT * FROM t2;
166 SELECT * FROM t2;
171 SELECT * FROM t2;
193 } {0 {t1 t2}}
202 SELECT * FROM t2;
215 SELECT * FROM t2;
220 DROP TABLE t2;
[all …]
H A Dorderby3.test41 WHERE t1.a=t2.c AND t2.b=t3.d
47 WHERE t1.a=t2.c AND t2.b=t3.d
53 WHERE t1.a=t2.c AND t2.b=t3.d
59 WHERE t1.a=t2.c AND t2.b=t3.d
65 WHERE t1.a=t2.c AND t2.b=t3.d
71 WHERE t1.a=t2.c AND t2.b=t3.d
77 WHERE t1.a=t2.c AND t2.b=t3.d
83 WHERE t1.a=t2.c AND t2.b=t3.d
89 WHERE t1.a=t2.c AND t2.b=t3.d
95 WHERE t1.a=t2.c AND t2.b=t3.d
[all …]
H A DselectB.test270 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
275 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
282 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
291 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
301 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
313 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
315 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
324 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
330 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
338 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
[all …]
H A DjoinB.test34 DROP TABLE IF EXISTS t2;
53 INNER JOIN t2 USING(a)
76 INNER JOIN t2 USING(a)
97 INNER JOIN t2 USING(a)
126 INNER JOIN t2 USING(a)
140 NATURAL INNER JOIN t2
151 INNER JOIN t2 USING(a)
174 INNER JOIN t2 USING(a)
197 INNER JOIN t2 USING(a)
241 NATURAL INNER JOIN t2
[all …]
H A Djoin7.test135 SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c ORDER BY +b;
143 SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c
151 SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c
160 SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c
170 SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c AND b>3 AND c>4
181 SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c AND b>3 WHERE c>4
187 SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c WHERE b>3 AND c>4
192 SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c WHERE b>3 OR c>4
199 SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c AND (b>3 OR c>4)
216 SELECT t1.*, t2.* FROM t2 LEFT OUTER JOIN t1 ON b=c ORDER BY +b;
[all …]
H A Djoin4.test31 insert into t2 values(2,'niban','ok');
35 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
52 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
58 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
63 create index i2 on t2(z);
66 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
71 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
76 select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
81 select * from t1 left outer join t2 on t1.a=t2.x and t2.z>='ok'
87 select * from t1 left outer join t2 on t1.a=t2.x where t2.z IN ('ok')
[all …]
H A Djoin8.test27 CREATE TABLE t2(x,y);
217 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
237 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
256 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
362 DROP TABLE t2;
386 CREATE TABLE t2(a INT); INSERT INTO t2 VALUES(0),(2);
393 SELECT * FROM t1 RIGHT JOIN t2 ON t2.a<>0 NATURAL LEFT JOIN t3;
405 SELECT * FROM t1 LEFT JOIN t2 ON t2.a<>0 NATURAL LEFT JOIN t3;
582 CREATE TABLE t2(x INT); INSERT INTO t2 VALUES (0);
669 CREATE TABLE t2(c INT); INSERT INTO t2 VALUES(NULL);
[all …]
H A Deqp.test52 `--SCAN t2
58 |--SCAN t2
208 |--SCAN t2
214 |--SCAN t2
218 det 2.2.6 "SELECT DISTINCT t2.x FROM t1, t2 ORDER BY t2.x" {
314 `--SCAN t2
518 # SELECT t1.*, t2.* FROM t1, t2 WHERE t1.a=1 AND t1.b>2;
529 # SELECT t1.*, t2.* FROM t2, t1 WHERE t1.a=1 AND t1.b>2;
671 2 0 0 SCAN t2
737 `--SCAN t2
[all …]
H A Dconflict2.test41 # t2 Content of "x" column of t2
57 DELETE FROM t2;
76 DROP TABLE t2;
89 # t2 Content of "x" column of t2
121 DROP TABLE t2;
134 # t2 Content of "x" column of t2
163 DROP TABLE t2;
176 # t2 Content of "x" column of t2
211 DROP TABLE t2;
224 # t2 Content of "x" column of t2
[all …]
H A Dconflict.test41 # t2 Content of "x" column of t2
57 DELETE FROM t2;
76 DROP TABLE t2;
89 # t2 Content of "x" column of t2
121 DROP TABLE t2;
134 # t2 Content of "x" column of t2
163 DROP TABLE t2;
176 # t2 Content of "x" column of t2
211 DROP TABLE t2;
224 # t2 Content of "x" column of t2
[all …]
H A De_select2.test358 test_join $tn.1.1 "t1, t2" {t1 t2}
359 test_join $tn.1.2 "t1 INNER JOIN t2" {t1 t2}
360 test_join $tn.1.3 "t1 CROSS JOIN t2" {t1 t2}
361 test_join $tn.1.4 "t1 JOIN t2" {t1 t2}
366 test_join $tn.1.9 "t2, t2 AS x" {t2 t2}
367 test_join $tn.1.10 "t2 INNER JOIN t2 AS x" {t2 t2}
368 test_join $tn.1.11 "t2 CROSS JOIN t2 AS x" {t2 t2}
369 test_join $tn.1.12 "t2 JOIN t2 AS x" {t2 t2}
376 test_join $tn.2.1 "t1, t2 ON (t1.a=t2.a)" {t1 t2 -on {te_equals a a}}
377 test_join $tn.2.2 "t2, t1 ON (t1.a=t2.a)" {t2 t1 -on {te_equals a a}}
[all …]
H A Dfts4noti.test125 do_execsql_test 3.3 { SELECT x FROM t2 WHERE t2 MATCH '2' } {}
126 do_execsql_test 3.4 { SELECT x FROM t2 WHERE t2 MATCH '1' } {2 3 4 5 6}
127 do_execsql_test 3.5 { SELECT x FROM t2 WHERE t2 MATCH 'x' } {1 2}
128 do_execsql_test 3.6 { SELECT x FROM t2 WHERE t2 MATCH 'x 1' } {2}
144 do_execsql_test 4.3 { SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'y' } {blob}
162 do_execsql_test 5.2 { SELECT docid FROM t2 WHERE t2 MATCH 'a' } {2}
163 do_execsql_test 5.3 { SELECT docid FROM t2 WHERE t2 MATCH 'b' } {1}
164 do_execsql_test 5.4 { SELECT docid FROM t2 WHERE t2 MATCH 'c' } {3}
225 SELECT count(*) FROM t2 WHERE t2 MATCH 'no';
226 SELECT count(*) FROM t2 WHERE t2 MATCH 'yes';
[all …]
H A Dwindow3.test57 ) FROM t2
343 FROM t2
1964 FROM t2
1983 FROM t2
2002 FROM t2
2596 FROM t2
4424 FROM t2
4443 FROM t2
4462 FROM t2
5116 FROM t2
[all …]
/sqlite-3.40.0/ext/session/
H A Dsession3.test105 S attach t2
108 DROP TABLE t2;
117 S attach t2
120 DROP TABLE t2;
129 DROP TABLE t2;
132 S attach t2
135 DROP TABLE t2;
147 S attach t2
163 S attach t2
180 S attach t2
[all …]
H A DsessionF.test71 S attach t2
81 DELETE FROM t2;
121 S attach t2
132 DELETE FROM t2;
141 DELETE FROM t2;
179 S attach t2
190 DELETE FROM t2;
199 DELETE FROM t2;
220 S attach t2
233 S attach t2
[all …]
/sqlite-3.40.0/mptest/
H A Dmultiwrite01.test44 INSERT INTO t2 SELECT a+2, randomblob(1500) FROM t2;
45 INSERT INTO t2 SELECT a+4, randomblob(1500) FROM t2;
46 INSERT INTO t2 SELECT a+8, randomblob(1500) FROM t2;
48 INSERT INTO t2 SELECT a+16, randomblob(1500) FROM t2;
50 INSERT INTO t2 SELECT a+32, randomblob(1500) FROM t2;
175 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
185 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
195 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
205 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
215 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5columnsize.test67 SELECT rowid FROM t2 WHERE t2 MATCH 'b'; SELECT '::';
68 SELECT rowid FROM t2 WHERE t2 MATCH 'e'; SELECT '::';
69 SELECT rowid FROM t2 WHERE t2 MATCH 'h';
73 SELECT rowid FROM t2 WHERE t2 MATCH 'b'; SELECT '::';
74 SELECT rowid FROM t2 WHERE t2 MATCH 'e'; SELECT '::';
75 SELECT rowid FROM t2 WHERE t2 MATCH 'h';
78 INSERT INTO t2(t2) VALUES('delete-all');
79 SELECT rowid FROM t2 WHERE t2 MATCH 'b'; SELECT '::';
80 SELECT rowid FROM t2 WHERE t2 MATCH 'e'; SELECT '::';
81 SELECT rowid FROM t2 WHERE t2 MATCH 'h';
[all …]

12345678910>>...29