← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/show_check.test

  • Committer: Brian Aker
  • Date: 2009-08-17 06:21:44 UTC
  • mto: This revision was merged to the branch mainline in revision 1118.
  • Revision ID: brian@gaz-20090817062144-8lxn1sg93pd8nhev
Remove PACK_KEYS

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/show_check.test
116
116
show open tables;
117
117
drop table t1;
118
118
 
119
 
create temporary table t1 (a int not null, b VARCHAR(10), INDEX (b) ) AVG_ROW_LENGTH=10 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 ROW_FORMAT=fixed;
120
 
show create table t1;
121
 
alter table t1 MAX_ROWS=200 ROW_FORMAT=dynamic PACK_KEYS=0;
122
 
show create table t1;
123
 
ALTER TABLE t1 AVG_ROW_LENGTH=0 COMMENT="" MIN_ROWS=0 MAX_ROWS=0 PACK_KEYS=DEFAULT ROW_FORMAT=default;
 
119
create temporary table t1 (a int not null, b VARCHAR(10), INDEX (b) ) AVG_ROW_LENGTH=10 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 ROW_FORMAT=fixed;
 
120
show create table t1;
 
121
alter table t1 MAX_ROWS=200 ROW_FORMAT=dynamic;
 
122
show create table t1;
 
123
ALTER TABLE t1 AVG_ROW_LENGTH=0 COMMENT="" MIN_ROWS=0 MAX_ROWS=0 ROW_FORMAT=default;
124
124
show create table t1;
125
125
drop table t1;
126
126
 
147
147
type_set enum ('red', 'green', 'blue'),
148
148
type_blob blob,
149
149
index(type_int)
150
 
) AVG_ROW_LENGTH=10 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 ROW_FORMAT=fixed;
 
150
) AVG_ROW_LENGTH=10 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 ROW_FORMAT=fixed;
151
151
 
152
152
# Not tested above: RAID_# UNION INSERT_METHOD DATA DIRECTORY INDEX DIRECTORY
153
153
show create table t1;