Searched refs:JOIN (Results 1 – 25 of 71) sorted by relevance
123
14 # use of USING or NATURAL JOIN. For such joins, the USING and15 # NATURAL JOIN processing needs to search all tables to the left34 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 …]
118 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=17128 SELECT t2.a FROM t1 JOIN t2 USING(a)134 SELECT t2.a FROM t2 NATURAL JOIN t1140 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r147 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r154 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r161 SELECT t2.a FROM t1 JOIN t2 USING(a)167 SELECT t2.a FROM t2 NATURAL JOIN t1173 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r[all …]
13 # 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 …]
41 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 t173 SELECT xyzzy.* FROM t2 AS xyzzy NATURAL JOIN t178 SELECT t1.* FROM t2 NATURAL JOIN t183 SELECT xyzzy.* FROM t2 NATURAL JOIN t1 AS xyzzy88 SELECT aaa.*, bbb.* FROM t2 AS aaa NATURAL JOIN t1 AS bbb[all …]
69 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 …]
28 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 …]
80 # 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", "INNER348 # 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 the356 # same data as the "INNER JOIN", "JOIN" and "," operators359 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 …]
28 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}}
51 t1 NATURAL JOIN t2 NATURAL JOIN t357 t1 NATURAL JOIN t2 NATURAL LEFT OUTER JOIN t363 t1 NATURAL LEFT OUTER JOIN t2 NATURAL JOIN t370 t1 NATURAL LEFT OUTER JOIN (t2 NATURAL JOIN t3)
73 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 …]
29 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);
13 # 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=x52 } [explain_no_trace {SELECT * FROM t1, t2 LEFT JOIN t3 ON x=q58 # This is similar to the above but with the LEFT JOIN on the84 LEFT OUTER JOIN child1 ON child1.child1key = parent1.child1key85 INNER JOIN child2 ON child2.child2key = parent1.child2key;94 LEFT OUTER JOIN child1 ON child1.child1key = parent1.child1key95 INNER JOIN child2 ON child2.child2key = parent1.child2key;100 LEFT OUTER JOIN child1 ON parent1.child1key = child1.child1key [all …]
39 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.b128 JOIN t4 AS x3 ON x3.a=x2.b129 JOIN t4 AS x4 ON x4.a=x3.b130 JOIN t4 AS x5 ON x5.a=x4.b131 JOIN t4 AS x6 ON x6.a=x5.b132 JOIN t4 AS x7 ON x7.a=x6.b133 JOIN t4 AS x8 ON x8.a=x7.b[all …]
58 # "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 …]
36 INNER JOIN b ON a.b_id = b.id WHERE b.bvalue = 'btest'38 LEFT OUTER JOIN b dd ON cc.b_id = dd.id49 LEFT OUTER JOIN b dd ON cc.b_id = dd.id60 LEFT OUTER JOIN b dd ON cc.b_id = dd.id
36 FROM tab1 t1 LEFT JOIN tab2 t2 ON t1.t1_id = t2.t2_id_t145 FROM tab1 t1 LEFT JOIN tab2 t2 ON t1.t1_id = t2.t2_id_t154 FROM tab1 t1 LEFT JOIN tab2 t2
138 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.col1165 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1171 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1177 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1191 FROM t2 LEFT JOIN t4 b1192 LEFT JOIN t4 b2 ON b2.x=b1.x AND b2.y IN (b1.y);
64 FROM persons p CROSS JOIN directors d76 FROM directors d CROSS JOIN persons p100 FROM persons p CROSS JOIN directors d112 FROM directors d CROSS JOIN persons p
32 JOIN tab4 AS cor1 USING ( col4, col3, col2, col1, col0 );39 SELECT cor0.* FROM tab1 NATURAL JOIN tab2 AS cor0;
280 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=a302 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 …]
43 LEFT OUTER JOIN A_B ON B.id = A_B.B_id 44 LEFT OUTER JOIN A ON A.id = A_B.A_id56 LEFT OUTER JOIN A_B ON B.id = A_B.B_id 57 LEFT OUTER JOIN A ON A.id = A_B.A_id
64 FROM Element JOIN ElemAnd ON ElemAnd.CodeAnd=Element.Code77 FROM ElemOr JOIN Element ON Element.Code=ElemOr.CodeOr104 JOIN ElemView1 AS InnerElem
42 JOIN = os.path.join46 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, "..", "heapcheck", "suppressions.txt")71 supp_filename = JOIN(suppressions_root, "drmemory", "suppressions.txt")[all …]
14 #define JOIN(X,Y) JOIN2(X,Y) macro16 int JOIN(array,__LINE__)[is_same<T1, T2>::value? 1 : -1]
4 #define JOIN(x,y) JOIN2(x,y) macro5 #define TEST2(name) JOIN(name,__LINE__)