← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/heap.result

  • Committer: Brian Aker
  • Date: 2010-02-23 21:18:15 UTC
  • mto: (1273.13.97 build)
  • mto: This revision was merged to the branch mainline in revision 1309.
  • Revision ID: brian@gaz-20100223211815-ckwo3eun67ikzu1e
This restores temporary tables back to being viewable via show/select.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/heap.result
4
4
delete from t1 where a=1 or a=0;
5
5
show table status like "t1";
6
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              0       DEFAULT 0       0       0       0       0       0       0       0       0       0               0               
 
7
t1      MEMORY  0       DEFAULT 0       0       0       0       0       0       0       0       0       0       utf8_general_ci 0               
8
8
select * from t1;
9
9
a       b
10
10
2       2
34
34
alter table t1 modify a int not null auto_increment, engine=innodb, comment="new innodb table";
35
35
show table status like "t1";
36
36
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
37
 
t1              0       DEFAULT 0       0       0       0       0       0       0       0       0       0               0               
 
37
t1      InnoDB  0       DEFAULT 0       0       0       0       0       0       0       0       0       0       utf8_general_ci 0               
38
38
select * from t1;
39
39
a       b
40
40
1       1
697
697
create temporary table t2 (c varchar(10)) engine=memory;
698
698
show table status like 't_';
699
699
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
700
 
t1              #       DEFAULT 0       0       0       #       0       0       0       0       0       0               0               
701
 
t2              #       DEFAULT 0       0       0       #       0       0       0       0       0       0               0               
 
700
t1      MEMORY  #       DEFAULT 0       0       0       #       0       0       0       0       0       0       utf8_general_ci 0               
 
701
t2      MEMORY  #       DEFAULT 0       0       0       #       0       0       0       0       0       0       utf8_general_ci 0               
702
702
drop table t1, t2;
703
703
CREATE TEMPORARY TABLE t1(a VARCHAR(1), b VARCHAR(2), c VARCHAR(256),
704
704
KEY(a), KEY(b), KEY(c)) ENGINE=MEMORY;