← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/subselect_mat.test

  • Committer: Stewart Smith
  • Date: 2009-06-16 01:15:37 UTC
  • mto: (1119.2.6 merge)
  • mto: This revision was merged to the branch mainline in revision 1124.
  • Revision ID: stewart@flamingspork.com-20090616011537-4dzzcjq1zfyl0rja
make subselect_mat test not leave tables behind

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/subselect_mat.test
243
243
      (a1, a2) in (select c1, c2 from t3 t3c
244
244
                   where (c1, c2) in (select b1, b2 from t2i where b2 > '0' or b2 = a2));
245
245
 
 
246
DROP TABLE t1i, t2i, t3i;
 
247
 
246
248
# subquery has no tables
247
249
--replace_column 9 #
248
250
explain extended
277
279
select * from t1 order by (select col from columns limit 1);
278
280
select * from t1 order by (select col from columns limit 1);
279
281
 
 
282
DROP TABLE columns;
 
283
 
280
284
/******************************************************************************
281
285
* Column types/sizes that affect materialization.
282
286
******************************************************************************/