← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/alter_table_rename_plus.result

  • Committer: Stewart Smith
  • Date: 2011-03-01 10:38:16 UTC
  • mto: (2241.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 2242.
  • Revision ID: stewart@flamingspork.com-20110301103816-hv3z7o047gz5qe43
add a utterly insane test of combination of renaming table and disable/enable keys to alter_table_rename_plus test

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/alter_table_rename_plus.result
36
36
  `c` INT DEFAULT NULL,
37
37
  PRIMARY KEY (`a`)
38
38
) ENGINE=InnoDB COLLATE = utf8_general_ci
39
 
DROP TABLE t4;
 
39
ALTER TABLE t4 ENABLE KEYS, RENAME t5, DISABLE KEYS, RENAME t6, ENABLE KEYS;
 
40
Warnings:
 
41
Note    1031    Table storage engine for 't4' doesn't have this option
 
42
show tables;
 
43
Tables_in_test
 
44
t6
 
45
show create table t6;
 
46
Table   Create Table
 
47
t6      CREATE TABLE `t6` (
 
48
  `a` INT NOT NULL,
 
49
  `b` INT DEFAULT NULL,
 
50
  `c` INT DEFAULT NULL,
 
51
  PRIMARY KEY (`a`)
 
52
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
53
DROP TABLE t6;