← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/alter_table.test

  • 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/t/alter_table.test
39
39
NAME varchar(80) DEFAULT '' NOT NULL,
40
40
PRIMARY KEY (GROUP_ID,LANG_ID),
41
41
KEY NAME (NAME));
42
 
#show table status like "t1";
 
42
show table status like "t1";
43
43
ALTER TABLE t1 CHANGE NAME NAME CHAR(80) not null;
44
44
--replace_column 8 #
45
45
show COLUMNS FROM t1;
163
163
) ENGINE=MyISAM;
164
164
 
165
165
ALTER TABLE t1 DISABLE KEYS;
166
 
SHOW INDEX FROM t1;
 
166
#SHOW INDEX FROM t1;
167
167
INSERT INTO t1 VALUES ('localhost','root'),('localhost','');
168
 
SHOW INDEX FROM t1;
 
168
#SHOW INDEX FROM t1;
169
169
ALTER TABLE t1 ENABLE KEYS;
170
 
SHOW INDEX FROM t1;
 
170
#SHOW INDEX FROM t1;
171
171
CHECK TABLES t1;
172
172
 
173
173
# Test RENAME