← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/join_nested.test

  • Committer: Brian Aker
  • Date: 2011-02-12 10:32:50 UTC
  • Revision ID: brian@tangent.org-20110212103250-q8y7zqan2948uban
Merge in a possible fix for Solaris

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/join_nested.test
35
35
SELECT t4.a,t4.b
36
36
  FROM t4;
37
37
 
38
 
--sorted_result
 
38
--error ER_CARTESIAN_JOIN_ATTEMPTED
39
39
SELECT t3.a,t3.b,t4.a,t4.b
40
40
  FROM t3,t4;
41
41
 
76
76
SELECT t5.a,t5.b
77
77
  FROM t5;
78
78
 
79
 
--sorted_result
 
79
--error ER_CARTESIAN_JOIN_ATTEMPTED
80
80
SELECT t3.a,t3.b,t4.a,t4.b,t5.a,t5.b
81
81
  FROM t3,t4,t5;
82
82
 
126
126
 
127
127
--sorted_result
128
128
SELECT t6.a,t6.b,t7.a,t7.b
129
 
  FROM t6,t7;
 
129
  FROM t6 CROSS JOIN t7;
130
130
 
131
131
SELECT t8.a,t8.b
132
132
  FROM t8;
426
426
    WHERE t1.a <= 2;
427
427
 
428
428
SELECT t3.a,t3.b,t4.a,t4.b
429
 
  FROM t3,t4;
 
429
  FROM t3 CROSS JOIN t4;
430
430
 
431
431
SELECT t2.a,t2.b,t3.a,t3.b,t4.a,t4.b
432
432
  FROM t2 
771
771
create table t1 (a int);
772
772
insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
773
773
create table t2 (a int, filler char(100), key(a));
774
 
insert into t2 select A.a + 10*B.a, '' from t1 A, t1 B;
 
774
insert into t2 select A.a + 10*B.a, '' from t1 A CROSS JOIN t1 B;
775
775
create table t3 like t2;
776
776
insert into t3 select * from t2;
777
777