~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/broken/r/pbxt/alter_table.result

  • Committer: Monty Taylor
  • Date: 2009-12-01 17:50:17 UTC
  • mto: (1235.1.1 push)
  • mto: This revision was merged to the branch mainline in revision 1236.
  • Revision ID: mordred@inaugust.com-20091201175017-o9yed6ssdiolghv4
Renamed instances of HEAP engine to MEMORY. Removed the alias.

Show diffs side-by-side

added added

removed removed

Lines of Context:
725
725
Field   Type    Null    Key     Default Extra
726
726
mycol   int     NO              NULL    
727
727
drop table t1;
728
 
create table t1(id int primary key auto_increment) engine=heap;
 
728
create table t1(id int primary key auto_increment) engine=MEMORY;
729
729
insert into t1 values (null);
730
730
insert into t1 values (null);
731
731
select * from t1;
740
740
1
741
741
2
742
742
50
743
 
alter table t1 engine = heap;
 
743
alter table t1 engine = MEMORY;
744
744
insert into t1 values (null);
745
745
select * from t1;
746
746
id