← Back to branch summary

~jaypipes/drizzle/replication-to-transaction

« back to all changes in this revision

Viewing changes to tests/t/heap_btree.test

  • Committer: Brian Aker
  • Date: 2010-03-09 22:58:27 UTC
  • mfrom: (1320.1.18 build)
  • Revision ID: brian@gaz-20100309225827-7igxztca4lrj3fx3
Merge in show status work.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/heap_btree.test
9
9
create temporary table t1 (a int not null,b int not null, primary key using BTREE (a)) engine=MEMORY comment="testing heaps";
10
10
insert into t1 values(1,1),(2,2),(3,3),(4,4);
11
11
delete from t1 where a=1 or a=0;
 
12
--replace_column 1 #  6 # 7 # 8 # 9 # 10 #
12
13
show table status like "t1";
13
14
show keys from t1;
14
15
select * from t1;
29
30
create temporary table t1 (a int not null,b int not null, primary key using BTREE (a)) engine=MEMORY comment="testing heaps";
30
31
insert into t1 values(1,1),(2,2),(3,3),(4,4);
31
32
alter table t1 modify a int not null auto_increment, engine=innodb, comment="new innodb table";
 
33
--replace_column 1 #  6 # 7 # 8 # 9 # 10 #
32
34
show table status like "t1";
33
35
select * from t1;
34
36
drop table t1;