← 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: 2010-10-20 20:26:18 UTC
  • mfrom: (1859.2.13 refactor)
  • Revision ID: brian@tangent.org-20101020202618-9222n39lm329urv5
Merge for Brian 

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 
618
618
 
619
619
create table t1 (a int, b decimal(13, 3)); 
620
620
insert into t1 values (1, 0.123);
621
 
system rm -f $DRIZZLETEST_VARDIR/subselect.out.file.1;
622
 
--replace_result $DRIZZLETEST_VARDIR DRIZZLETEST_VARDIR
623
 
eval select a, (select max(b) from t1) into outfile "$DRIZZLETEST_VARDIR/subselect.out.file.1" from t1;
 
621
select a, (select max(b) from t1) into outfile "subselect.out.file.1" from t1;
624
622
delete from t1;
625
 
--replace_result $DRIZZLETEST_VARDIR DRIZZLETEST_VARDIR
626
 
eval load data infile "$DRIZZLETEST_VARDIR/subselect.out.file.1" into table t1;
 
623
load data infile "subselect.out.file.1" into table t1;
627
624
select * from t1;
628
625
drop table t1;
629
626