← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/show_check.result

  • Committer: Brian Aker
  • Date: 2009-08-17 01:44:23 UTC
  • mto: This revision was merged to the branch mainline in revision 1118.
  • Revision ID: brian@gaz-20090817014423-jxi2qonsumm8mndf
Remove SQL level reference for DELAY (just now done correctly by default in
engine).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/show_check.result
230
230
Database        Table   In_use  Name_locked
231
231
test    t1      0       0
232
232
drop table t1;
233
 
create temporary table t1 (a int not null, b VARCHAR(10), INDEX (b) ) AVG_ROW_LENGTH=10 CHECKSUM=1 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 DELAY_KEY_WRITE=1 ROW_FORMAT=fixed;
 
233
create temporary table t1 (a int not null, b VARCHAR(10), INDEX (b) ) AVG_ROW_LENGTH=10 CHECKSUM=1 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 ROW_FORMAT=fixed;
234
234
show create table t1;
235
235
Table   Create Table
236
236
t1      CREATE TEMPORARY TABLE `t1` (
237
237
  `a` int NOT NULL,
238
238
  `b` varchar(10) DEFAULT NULL,
239
239
  KEY `b` (`b`)
240
 
) ENGINE=MyISAM MIN_ROWS=10 MAX_ROWS=100 AVG_ROW_LENGTH=10 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=FIXED COMMENT='test'
 
240
) ENGINE=MyISAM MIN_ROWS=10 MAX_ROWS=100 AVG_ROW_LENGTH=10 PACK_KEYS=1 CHECKSUM=1 ROW_FORMAT=FIXED COMMENT='test'
241
241
alter table t1 MAX_ROWS=200 ROW_FORMAT=dynamic PACK_KEYS=0;
242
242
show create table t1;
243
243
Table   Create Table
245
245
  `a` int NOT NULL,
246
246
  `b` varchar(10) DEFAULT NULL,
247
247
  KEY `b` (`b`)
248
 
) ENGINE=MyISAM MIN_ROWS=10 MAX_ROWS=200 AVG_ROW_LENGTH=10 PACK_KEYS=0 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='test'
249
 
ALTER TABLE t1 AVG_ROW_LENGTH=0 CHECKSUM=0 COMMENT="" MIN_ROWS=0 MAX_ROWS=0 PACK_KEYS=DEFAULT DELAY_KEY_WRITE=0 ROW_FORMAT=default;
 
248
) ENGINE=MyISAM MIN_ROWS=10 MAX_ROWS=200 AVG_ROW_LENGTH=10 PACK_KEYS=0 CHECKSUM=1 ROW_FORMAT=DYNAMIC COMMENT='test'
 
249
ALTER TABLE t1 AVG_ROW_LENGTH=0 CHECKSUM=0 COMMENT="" MIN_ROWS=0 MAX_ROWS=0 PACK_KEYS=DEFAULT ROW_FORMAT=default;
250
250
show create table t1;
251
251
Table   Create Table
252
252
t1      CREATE TEMPORARY TABLE `t1` (
288
288
type_set enum ('red', 'green', 'blue'),
289
289
type_blob blob,
290
290
index(type_int)
291
 
) AVG_ROW_LENGTH=10 CHECKSUM=1 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 DELAY_KEY_WRITE=1 ROW_FORMAT=fixed;
 
291
) AVG_ROW_LENGTH=10 CHECKSUM=1 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 ROW_FORMAT=fixed;
292
292
show create table t1;
293
293
Table   Create Table
294
294
t1      CREATE TEMPORARY TABLE `t1` (
306
306
  `type_set` enum('red','green','blue') DEFAULT NULL,
307
307
  `type_blob` blob,
308
308
  KEY `type_int` (`type_int`)
309
 
) ENGINE=MyISAM MIN_ROWS=10 MAX_ROWS=100 AVG_ROW_LENGTH=10 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=FIXED COMMENT='test'
 
309
) ENGINE=MyISAM MIN_ROWS=10 MAX_ROWS=100 AVG_ROW_LENGTH=10 PACK_KEYS=1 CHECKSUM=1 ROW_FORMAT=FIXED COMMENT='test'
310
310
insert into t1 (type_timestamp) values ("2003-02-07 10:00:01");
311
311
select * from t1;
312
312
type_int        type_bigint     type_decimal    type_numeric    empty_char      type_char       type_varchar    type_timestamp  type_date       type_datetime   type_enum       type_set        type_blob