← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/heap_btree.result

  • Committer: Brian Aker
  • Date: 2010-02-25 07:54:52 UTC
  • mfrom: (1273.13.101 build)
  • Revision ID: brian@gaz-20100225075452-19eozreshbrerypu
Merge of all patches in build.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/heap_btree.result
2
2
create temporary table t1 (a int not null,b int not null, primary key using BTREE (a)) engine=MEMORY comment="testing heaps";
3
3
insert into t1 values(1,1),(2,2),(3,3),(4,4);
4
4
delete from t1 where a=1 or a=0;
 
5
show table status like "t1";
 
6
Name    Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
 
7
t1      MEMORY  0       DEFAULT 0       0       0       0       0       0       0       0       0       0       utf8_general_ci 0               
5
8
show keys from t1;
6
 
Table   Non_unique      Key_name        Seq_in_index    Column_name     Collation       Cardinality     Sub_part        Packed  Null    Index_type      Comment Index_Comment
7
 
t1      0       PRIMARY 1       a       A       NULL    NULL    NULL            BTREE           
 
9
Table   Key_name        Seq_in_index    Column_name
 
10
t1      PRIMARY 0       a
8
11
select * from t1;
9
12
a       b
10
13
2       2
32
35
create temporary table t1 (a int not null,b int not null, primary key using BTREE (a)) engine=MEMORY comment="testing heaps";
33
36
insert into t1 values(1,1),(2,2),(3,3),(4,4);
34
37
alter table t1 modify a int not null auto_increment, engine=innodb, comment="new innodb table";
 
38
show table status like "t1";
 
39
Name    Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
 
40
t1      InnoDB  0       DEFAULT 0       0       0       0       0       0       0       0       0       0       utf8_general_ci 0               
35
41
select * from t1;
36
42
a       b
37
43
1       1