← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/join_nested.result

  • Committer: Lee Bieber
  • Date: 2010-12-23 23:11:00 UTC
  • mfrom: (2024.1.1 clean)
  • Revision ID: kalebral@gmail.com-20101223231100-0rqirgz7ugkl10yp
Merge Brian - session list cleanup

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/join_nested.result
37
37
4       2
38
38
SELECT t3.a,t3.b,t4.a,t4.b
39
39
FROM t3,t4;
40
 
ERROR HY000: Implicit cartesian join attempted.
 
40
a       b       a       b
 
41
1       2       3       2
 
42
1       2       4       2
 
43
2       2       3       2
 
44
2       2       4       2
41
45
SELECT t2.a,t2.b,t3.a,t3.b,t4.a,t4.b
42
46
FROM t2
43
47
LEFT JOIN              
103
107
3       3
104
108
SELECT t3.a,t3.b,t4.a,t4.b,t5.a,t5.b
105
109
FROM t3,t4,t5;
106
 
ERROR HY000: Implicit cartesian join attempted.
 
110
a       b       a       b       a       b
 
111
1       2       3       2       2       2
 
112
1       2       3       2       3       1
 
113
1       2       3       2       3       3
 
114
1       2       4       2       2       2
 
115
1       2       4       2       3       1
 
116
1       2       4       2       3       3
 
117
2       2       3       2       2       2
 
118
2       2       3       2       3       1
 
119
2       2       3       2       3       3
 
120
2       2       4       2       2       2
 
121
2       2       4       2       3       1
 
122
2       2       4       2       3       3
107
123
SELECT t2.a,t2.b,t3.a,t3.b,t4.a,t4.b,t5.a,t5.b
108
124
FROM t2
109
125
LEFT JOIN              
192
208
1       1
193
209
2       2
194
210
SELECT t6.a,t6.b,t7.a,t7.b
195
 
FROM t6 CROSS JOIN t7;
 
211
FROM t6,t7;
196
212
a       b       a       b
197
213
3       2       1       1
198
214
3       2       2       2
750
766
2       2       4       2       2       2
751
767
2       2       5       3       NULL    NULL
752
768
SELECT t3.a,t3.b,t4.a,t4.b
753
 
FROM t3 CROSS JOIN t4;
 
769
FROM t3,t4;
754
770
a       b       a       b
755
771
1       2       3       2
756
772
2       2       3       2
1307
1323
create table t1 (a int);
1308
1324
insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1309
1325
create table t2 (a int, filler char(100), key(a));
1310
 
insert into t2 select A.a + 10*B.a, '' from t1 A CROSS JOIN t1 B;
 
1326
insert into t2 select A.a + 10*B.a, '' from t1 A, t1 B;
1311
1327
create table t3 like t2;
1312
1328
insert into t3 select * from t2;
1313
1329
explain select * from t1 left join