Lines Matching refs:join

18 # $Id: join.test,v 1.11 2003/09/27 13:39:40 drh Exp $
23 do_test join-1.1 {
32 do_test join-1.2 {
42 do_test join-1.3 {
47 do_test join-1.3.1 {
52 do_test join-1.4 {
57 do_test join-1.5 {
62 do_test join-1.6 {
67 do_test join-1.7 {
73 do_test join-1.8 {
78 do_test join-1.9 {
83 do_test join-1.10 {
88 do_test join-1.11 {
93 do_test join-1.12 {
95     SELECT * FROM t1 natural inner join t2;
98 do_test join-1.13 {
104 do_test join-1.14 {
111 do_test join-1.15 {
120 do_test join-1.16 {
122     SELECT * FROM t1 natural join t2 natural join t3;
125 do_test join-1.17 {
127     SELECT * FROM t1 natural join t2 natural join t3;
130 do_test join-1.18 {
139 do_test join-1.19 {
141     SELECT * FROM t1 natural join t2 natural join t4;
144 do_test join-1.19 {
146     SELECT * FROM t1 natural join t2 natural join t4;
149 do_test join-1.20 {
151     SELECT * FROM t1 natural join t2 natural join t3 WHERE t1.a=1
155 do_test join-2.1 {
160 do_test join-2.2 {
165 do_test join-2.3 {
170 do_test join-2.4 {
175 do_test join-2.5 {
180 do_test join-2.6 {
186 do_test join-3.1 {
190 } {1 {a NATURAL join may not have an ON or USING clause}}
191 do_test join-3.2 {
195 } {1 {a NATURAL join may not have an ON or USING clause}}
196 do_test join-3.3 {
200 } {1 {cannot have both ON and USING clauses in the same join}}
201 do_test join-3.4 {
205 } {1 {cannot join using column a - column not present in both tables}}
206 do_test join-3.5 {
211 do_test join-3.6 {
216 do_test join-3.7 {
220 } {1 {unknown or unsupported join type: INNER OUTER}}
221 do_test join-3.7 {
225 } {1 {unknown or unsupported join type: LEFT BOGUS}}
227 do_test join-4.1 {
246 do_test join-4.2 {
251 do_test join-4.3 {
256 do_test join-4.4 {
262 do_test join-4.6 {
267 do_test join-4.7 {
272 do_test join-4.8 {
278 do_test join-4.9 {
283 do_test join-4.10 {
289 do_test join-5.1 {
302     usuarios left outer join centros on usuarios.idcentro = centros.id;
308 do_test join-7.1 {
331 # Make sure a left join where the right table is really a view that
332 # is itself a join works right.  Ticket #306.
334 do_test join-8.1 {
351 do_test join-8.2 {
357 do_test join-8.3 {
364 # function correctly if the right table in the join is really
373 do_test join-9.1 {
387 do_test join-9.2 {