← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/mix2.inc

  • Committer: Stewart Smith
  • Date: 2010-02-26 05:33:19 UTC
  • mfrom: (1283.13.5)
  • mto: (1283.11.6)
  • mto: This revision was merged to the branch mainline in revision 1449.
  • Revision ID: stewart@flamingspork.com-20100226053319-6dnlmghm0vq320ch
Merged embedded-innodb-init into embedded-innodb-dump-datadict-func.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/mix2.inc
113
113
select level,id,parent_id from t1 where level=1;
114
114
eval alter table t1 engine=$engine_type;
115
115
--replace_column 7 #
116
 
show keys from t1;
 
116
#show keys from t1;
117
117
drop table t1;
118
118
 
119
119
#
152
152
insert into t1 values (3,""), (4,"testing");
153
153
analyze table t1;
154
154
--replace_column 7 #
155
 
show keys from t1;
 
155
#show keys from t1;
156
156
drop table t1;
157
157
 
158
158
 
339
339
eval create $temp table t1 (a int not null, b int not null,c int not null,
340
340
key(a),primary key(a,b), unique(c),key(a),unique(b)) ENGINE = $engine_type;
341
341
--replace_column 7 #
342
 
show index from t1;
 
342
#show index from t1;
343
343
drop table t1;
344
344
 
345
345
#
518
518
select * from t1 order by b desc;
519
519
eval alter table t1 ENGINE=$engine_type;
520
520
--replace_column 7 #
521
 
show keys from t1;
 
521
#show keys from t1;
522
522
drop table t1;
523
523
 
524
524
#
687
687
#
688
688
 
689
689
eval create $temp table t1 (t int not null default 1, key (t)) engine=$engine_type;
690
 
desc t1;
 
690
#desc t1;
691
691
drop table t1;
692
692
 
693
693
#