← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/myisam.test

  • Committer: Brian Aker
  • Date: 2010-02-23 22:10:47 UTC
  • mto: (1273.13.97 build)
  • mto: This revision was merged to the branch mainline in revision 1309.
  • Revision ID: brian@gaz-20100223221047-uehdt5fcwx1z3c9p
Enabled more tests.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/myisam.test
63
63
create TEMPORARY table t1 (a int not null auto_increment, b int not null, primary key (a), index(b)) ENGINE=MYISAM;
64
64
insert into t1 (b) values (1),(2),(2),(2),(2);
65
65
alter table t1 engine=MYISAM;
66
 
#show index from t1;
 
66
show index from t1;
67
67
alter table t1 engine=MyISAM;
68
 
#show index from t1;
 
68
show index from t1;
69
69
drop table t1;
70
70
 
71
71
#
345
345
create table t2 (a int not null, b int, c int, key(b), key(c), key(a));
346
346
INSERT into t2 values (1,1,1), (2,2,2);
347
347
alter table t1 ENGINE=MYISAM;
348
 
#show index from t1;
 
348
show index from t1;
349
349
explain select * from t1,t2 where t1.a=t2.a;
350
350
explain select * from t1,t2 force index(a) where t1.a=t2.a;
351
351
explain select * from t1 force index(a),t2 force index(a) where t1.a=t2.a;