Home
last modified time | relevance | path

Searched refs:JOIN (Results 1 – 25 of 73) sorted by relevance

123

/external/chromium_org/third_party/sqlite/src/test/
Djoin6.test14 # use of USING or NATURAL JOIN. For such joins, the USING and
15 # NATURAL JOIN processing needs to search all tables to the left
34 SELECT * FROM t1 LEFT JOIN t2 USING(a) LEFT JOIN t3 USING(a);
40 FROM t1 LEFT JOIN t2 ON t1.a=t2.a LEFT JOIN t3 ON t2.a=t3.a;
46 FROM t1 LEFT JOIN t2 ON t1.a=t2.a LEFT JOIN t3 ON t1.a=t3.a;
70 SELECT * FROM t1 JOIN t2 USING (y) JOIN t3 USING(x);
75 SELECT * FROM t1 NATURAL JOIN t2 NATURAL JOIN t3;
98 SELECT * FROM t1 NATURAL JOIN t2 NATURAL JOIN t3;
103 SELECT * FROM t1 JOIN t2 NATURAL JOIN t3;
108 SELECT * FROM t1 JOIN t2 USING(y) NATURAL JOIN t3;
[all …]
Dboundary3.test118 SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='00ffffffffffffff'
123 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
140 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
147 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
154 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
161 SELECT t2.a FROM t1 JOIN t2 USING(a)
167 SELECT t2.a FROM t2 NATURAL JOIN t1
173 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
[all …]
Djoin.test41 SELECT * FROM t1 NATURAL JOIN t2;
46 SELECT * FROM t2 NATURAL JOIN t1;
51 SELECT * FROM t2 AS x NATURAL JOIN t1;
56 SELECT * FROM t2 NATURAL JOIN t1 AS y;
61 SELECT b FROM t1 NATURAL JOIN t2;
68 SELECT t2.* FROM t2 NATURAL JOIN t1
73 SELECT xyzzy.* FROM t2 AS xyzzy NATURAL JOIN t1
78 SELECT t1.* FROM t2 NATURAL JOIN t1
83 SELECT xyzzy.* FROM t2 NATURAL JOIN t1 AS xyzzy
88 SELECT aaa.*, bbb.* FROM t2 AS aaa NATURAL JOIN t1 AS bbb
[all …]
Dwhere6.test13 # a LEFT OUTER JOIN are not used with indices. See ticket #3015.
30 SELECT * FROM t1 LEFT JOIN t2 ON b=x AND c=1;
35 SELECT * FROM t1 LEFT JOIN t2 ON x=b AND c=1;
40 SELECT * FROM t1 LEFT JOIN t2 ON x=b AND 1=c;
45 SELECT * FROM t1 LEFT JOIN t2 ON b=x AND 1=c;
51 explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON x=b AND 1=c}
52 } [explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON b=x AND c=1}]
54 explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON x=b WHERE 1=c}
55 } [explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON b=x WHERE c=1}]
60 SELECT * FROM t1 LEFT JOIN t2 ON b=x WHERE c=1;
[all …]
Dvtab6.test69 SELECT * FROM t1 NATURAL JOIN t2;
74 SELECT * FROM t2 NATURAL JOIN t1;
79 SELECT * FROM t2 AS x NATURAL JOIN t1;
84 SELECT * FROM t2 NATURAL JOIN t1 AS y;
89 SELECT b FROM t1 NATURAL JOIN t2;
94 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
99 SELECT * FROM t1 AS x INNER JOIN t2 USING(b,c);
104 SELECT * FROM t1 INNER JOIN t2 AS y USING(b,c);
109 SELECT * FROM t1 AS x INNER JOIN t2 AS y USING(b,c);
114 SELECT b FROM t1 JOIN t2 USING(b);
[all …]
Dtkt1537.test28 SELECT * FROM t1 LEFT JOIN t2 ON a1=b OR a2=+b;
33 SELECT * FROM t1 LEFT JOIN t2 ON a1=b OR a2=b;
38 SELECT * FROM t2 LEFT JOIN t1 ON a1=b OR a2=b;
44 SELECT * FROM t1 LEFT JOIN t2 ON b IN (a1,a2);
49 SELECT * FROM t2 LEFT JOIN t1 ON b IN (a2,a1);
58 SELECT * FROM t1 LEFT JOIN t2 ON a1=b OR a2=b;
63 SELECT * FROM t2 LEFT JOIN t1 ON a1=b OR a2=b;
70 SELECT * FROM t1 LEFT JOIN t2 ON b IN (a1,a2);
75 SELECT * FROM t2 LEFT JOIN t1 ON b IN (a2,a1);
88 SELECT * FROM t1 LEFT JOIN t2 ON b BETWEEN a1 AND a2;
[all …]
De_select2.test80 # If the -left option is present, the join is done LEFT JOIN style.
347 # EVIDENCE-OF: R-46122-14930 If the join-op is "CROSS JOIN", "INNER
348 # JOIN", "JOIN" or a comma (",") and there is no ON or USING clause,
353 # JOIN", "JOIN" and "," join operators.
355 # EVIDENCE-OF: R-07544-24155 The "CROSS JOIN" join operator produces the
356 # same data as the "INNER JOIN", "JOIN" and "," operators
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}
363 test_join $tn.1.6 "t2 INNER JOIN t3" {t2 t3}
[all …]
Dtkt3935.test28 execsql { SELECT j1.b FROM ( SELECT * FROM t1 INNER JOIN t2 ON a=c ) AS j1 }
31 execsql { SELECT j1.b FROM (t1 INNER JOIN t2 ON a=c) AS j1 }
37 } {1 {a JOIN clause is required before ON}}
40 } {1 {a JOIN clause is required before ON}}
43 } {1 {a JOIN clause is required before ON}}
46 } {1 {a JOIN clause is required before ON}}
49 } {1 {a JOIN clause is required before ON}}
52 } {1 {a JOIN clause is required before ON}}
55 } {1 {a JOIN clause is required before USING}}
Djoin2.test51 t1 NATURAL JOIN t2 NATURAL JOIN t3
57 t1 NATURAL JOIN t2 NATURAL LEFT OUTER JOIN t3
63 t1 NATURAL LEFT OUTER JOIN t2 NATURAL JOIN t3
70 t1 NATURAL LEFT OUTER JOIN (t2 NATURAL JOIN t3)
Djoin5.test73 execsql {SELECT * FROM xy LEFT JOIN ab ON 0}
76 execsql {SELECT * FROM xy LEFT JOIN ab ON 1}
79 execsql {SELECT * FROM xy LEFT JOIN ab ON NULL}
82 execsql {SELECT * FROM xy LEFT JOIN ab ON 0 WHERE 0}
85 execsql {SELECT * FROM xy LEFT JOIN ab ON 1 WHERE 0}
88 execsql {SELECT * FROM xy LEFT JOIN ab ON NULL WHERE 0}
91 execsql {SELECT * FROM xy LEFT JOIN ab ON 0 WHERE 1}
94 execsql {SELECT * FROM xy LEFT JOIN ab ON 1 WHERE 1}
97 execsql {SELECT * FROM xy LEFT JOIN ab ON NULL WHERE 1}
100 execsql {SELECT * FROM xy LEFT JOIN ab ON 0 WHERE NULL}
[all …]
Dtkt3911.test29 SELECT * FROM t1 JOIN t2 USING(b);
34 SELECT * FROM t1 JOIN (t2) AS x USING (b);
39 SELECT * FROM t1 JOIN (SELECT * FROM t2) AS x USING (b);
49 SELECT * FROM t3 JOIN (SELECT * FROM t1 NATURAL JOIN t2) AS x USING(a);
54 SELECT * FROM t3 JOIN (SELECT * FROM t1 JOIN t2 USING (b)) AS x USING(a);
Dwhere3.test13 # in cases that include a LEFT JOIN.
44 SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x WHERE p=2 AND a=q;
50 explain_no_trace {SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x
52 } [explain_no_trace {SELECT * FROM t1, t2 LEFT JOIN t3 ON x=q
58 # This is similar to the above but with the LEFT JOIN on the
84 LEFT OUTER JOIN child1 ON child1.child1key = parent1.child1key
85 INNER JOIN child2 ON child2.child2key = parent1.child2key;
94 LEFT OUTER JOIN child1 ON child1.child1key = parent1.child1key
95 INNER JOIN child2 ON child2.child2key = parent1.child2key;
100 LEFT OUTER JOIN child1 ON parent1.child1key = child1.child1key
[all …]
Dautoindex1.test39 SELECT b, d FROM t1 JOIN t2 ON a=c ORDER BY b;
54 SELECT b, d FROM t1 JOIN t2 ON a=c ORDER BY b;
96 db eval {SELECT b, d FROM t1 JOIN t2 ON (c=a)} {
127 JOIN t4 AS x2 ON x2.a=x1.b
128 JOIN t4 AS x3 ON x3.a=x2.b
129 JOIN t4 AS x4 ON x4.a=x3.b
130 JOIN t4 AS x5 ON x5.a=x4.b
131 JOIN t4 AS x6 ON x6.a=x5.b
132 JOIN t4 AS x7 ON x7.a=x6.b
133 JOIN t4 AS x8 ON x8.a=x7.b
[all …]
De_select.test58 # "CROSS JOIN" or "INNER JOIN" join-op, the string %JOIN% must be
63 # * s/%JOIN%/,/
64 # * s/%JOIN%/JOIN/
65 # * s/%JOIN%/INNER JOIN/
66 # * s/%JOIN%/CROSS JOIN/
71 foreach {tn2 joinop} [list 1 , 2 "CROSS JOIN" 3 "INNER JOIN"] {
72 set S [string map [list %JOIN% $joinop] $select]
84 SELECT count(*) FROM t1 %JOIN% t2 ON (t1.a=t2.a)
87 SELECT count(*) FROM t1 %JOIN% t2 USING (a)
90 SELECT count(*) FROM t1 %JOIN% t2
[all …]
Dtkt3357.test36 INNER JOIN b ON a.b_id = b.id WHERE b.bvalue = 'btest'
38 LEFT OUTER JOIN b dd ON cc.b_id = dd.id
49 LEFT OUTER JOIN b dd ON cc.b_id = dd.id
60 LEFT OUTER JOIN b dd ON cc.b_id = dd.id
Dtkt2141.test36 FROM tab1 t1 LEFT JOIN tab2 t2 ON t1.t1_id = t2.t2_id_t1
45 FROM tab1 t1 LEFT JOIN tab2 t2 ON t1.t1_id = t2.t2_id_t1
54 FROM tab1 t1 LEFT JOIN tab2 t2
Dwhere4.test138 SELECT * FROM t2 LEFT JOIN t3 ON a=x WHERE +y IS NULL;
143 SELECT * FROM t2 LEFT JOIN t3 ON a=x WHERE y IS NULL;
159 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1
165 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1
171 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1
177 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1
191 FROM t2 LEFT JOIN t4 b1
192 LEFT JOIN t4 b2 ON b2.x=b1.x AND b2.y IN (b1.y);
Dtkt2640.test64 FROM persons p CROSS JOIN directors d
76 FROM directors d CROSS JOIN persons p
100 FROM persons p CROSS JOIN directors d
112 FROM directors d CROSS JOIN persons p
Dtkt3522.test32 JOIN tab4 AS cor1 USING ( col4, col3, col2, col1, col0 );
39 SELECT cor0.* FROM tab1 NATURAL JOIN tab2 AS cor0;
Dwhere2.test280 SELECT * FROM t2249b CROSS JOIN t2249a WHERE a=b;
288 SELECT * FROM t2249b CROSS JOIN t2249a WHERE a=+b;
294 SELECT * FROM t2249b CROSS JOIN t2249a WHERE +b=a
302 SELECT * FROM t2249b CROSS JOIN t2249a WHERE +a=+b;
309 SELECT * FROM t2249b CROSS JOIN t2249a WHERE a=b OR a='hello';
315 SELECT * FROM t2249b CROSS JOIN t2249a WHERE b=a OR a='hello';
321 SELECT * FROM t2249b CROSS JOIN t2249a WHERE 'hello'=a OR b=a;
327 SELECT * FROM t2249b CROSS JOIN t2249a WHERE a='hello' OR b=a;
341 SELECT * FROM t2249b CROSS JOIN t2249a WHERE a=+b OR a='hello';
349 SELECT * FROM t2249b CROSS JOIN t2249a WHERE a='hello' OR +b=a;
[all …]
Dtkt3493.test43 LEFT OUTER JOIN A_B ON B.id = A_B.B_id
44 LEFT OUTER JOIN A ON A.id = A_B.A_id
56 LEFT OUTER JOIN A_B ON B.id = A_B.B_id
57 LEFT OUTER JOIN A ON A.id = A_B.A_id
/external/clang/test/CodeGen/
Ddllimport.c9 #define JOIN(x, y) JOIN2(x, y) macro
10 #define USEVAR(var) int JOIN(use, __LINE__)() { return var; }
11 #define USE(func) void JOIN(use, __LINE__)() { func(); }
/external/chromium_org/tools/valgrind/
Dsuppressions.py42 JOIN = os.path.join
46 supp_filename = JOIN(suppressions_root, "memcheck", "suppressions.txt")
48 supp_filename = JOIN(suppressions_root, "tsan", "suppressions.txt")
52 supp_filename = JOIN(suppressions_root, "memcheck", "suppressions_linux.txt")
54 supp_filename = JOIN(suppressions_root, "tsan", "suppressions_linux.txt")
58 supp_filename = JOIN(suppressions_root, "memcheck", "suppressions_mac.txt")
60 supp_filename = JOIN(suppressions_root, "tsan", "suppressions_mac.txt")
64 supp_filename = JOIN(suppressions_root, "tsan", "suppressions_win32.txt")
68 supp_filename = JOIN(suppressions_root, "drmemory", "suppressions.txt")
70 supp_filename = JOIN(suppressions_root, "drmemory", "suppressions_full.txt")
/external/clang/test/CXX/dcl.decl/dcl.meaning/dcl.ref/
Dp6-0x.cpp13 #define JOIN(X,Y) JOIN2(X,Y) macro
15 int JOIN(array,__LINE__)[is_same<T1, T2>::value? 1 : -1]
/external/clang/test/Sema/
D__try.c4 #define JOIN(x,y) JOIN2(x,y) macro
5 #define TEST2(name) JOIN(name,__LINE__)

123