~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/subselect_sj.test

  • Committer: Mark Atwood
  • Date: 2011-10-27 05:08:12 UTC
  • mfrom: (2445.1.11 rf)
  • Revision ID: me@mark.atwood.name-20111027050812-1icvs72lb0u4xdc4
mergeĀ lp:~olafvdspek/drizzle/refactor8

Show diffs side-by-side

added added

removed removed

Lines of Context:
81
81
where t1.a < 5;
82
82
 
83
83
# Try I2O orders
84
 
insert into t1 select (A.a + 10 * B.a),1 from t0 A, t0 B;
 
84
insert into t1 select (A.a + 10 * B.a),1 from t0 A CROSS JOIN t0 B;
85
85
explain extended select * from t1 where a in (select pk from t10 where pk<3);
86
86
 
87
87
drop table t0, t1;