~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/alter_table.result

  • Committer: Brian Aker
  • Date: 2010-02-23 22:10:47 UTC
  • mto: (1273.13.97 build)
  • mto: This revision was merged to the branch mainline in revision 1309.
  • Revision ID: brian@gaz-20100223221047-uehdt5fcwx1z3c9p
Enabled more tests.

Show diffs side-by-side

added added

removed removed

Lines of Context:
49
49
NAME varchar(80) DEFAULT '' NOT NULL,
50
50
PRIMARY KEY (GROUP_ID,LANG_ID),
51
51
KEY NAME (NAME));
 
52
show table status like "t1";
 
53
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
 
54
t1      InnoDB  0       DEFAULT 0       0       0       0       0       0       0       0       0       0       utf8_general_ci 0               
52
55
ALTER TABLE t1 CHANGE NAME NAME CHAR(80) not null;
53
56
show COLUMNS FROM t1;
54
57
Field   Type    Null    Default Default is NULL On Update