← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/subselect3.test

  • Committer: Brian Aker
  • Date: 2011-02-04 09:29:39 UTC
  • mfrom: (2139.3.6 catalogs)
  • mto: This revision was merged to the branch mainline in revision 2144.
  • Revision ID: brian@tangent.org-20110204092939-nlwrimamw0fxxhgl
Main bit of this patch is that Inno now just uses the identifier so we only
have one spot to make changes for paths.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/subselect3.test
225
225
 
226
226
# Then check that we do turn off 'ref' scans in the subquery
227
227
create table t4 (x int);
228
 
insert into t4 select A.a + 10*B.a from t1 A CROSS JOIN t1 B;
 
228
insert into t4 select A.a + 10*B.a from t1 A, t1 B;
229
229
explain extended 
230
230
  select a,b, oref, 
231
231
         (a,b) in (select a,b from t1,t4 where c=t2.oref) Z