← 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: Olaf van der Spek
  • Date: 2011-08-04 08:13:04 UTC
  • mfrom: (2384 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2385.
  • Revision ID: olafvdspek@gmail.com-20110804081304-rlejjpvoos17bjdf
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/alter_table_rename_plus.result
8
8
t2      CREATE TABLE `t2` (
9
9
  `a` INT NOT NULL,
10
10
  `b` INT DEFAULT NULL,
11
 
  PRIMARY KEY (`a`)
 
11
  PRIMARY KEY (`a`) USING BTREE
12
12
) ENGINE=InnoDB COLLATE = utf8_general_ci
13
13
ALTER TABLE t2 ADD COLUMN c int, rename t3;
14
14
show tables;
20
20
  `a` INT NOT NULL,
21
21
  `b` INT DEFAULT NULL,
22
22
  `c` INT DEFAULT NULL,
23
 
  PRIMARY KEY (`a`)
 
23
  PRIMARY KEY (`a`) USING BTREE
24
24
) ENGINE=InnoDB COLLATE = utf8_general_ci
25
25
ALTER TABLE t3 DISABLE KEYS, RENAME t4;
26
26
Warnings:
34
34
  `a` INT NOT NULL,
35
35
  `b` INT DEFAULT NULL,
36
36
  `c` INT DEFAULT NULL,
37
 
  PRIMARY KEY (`a`)
 
37
  PRIMARY KEY (`a`) USING BTREE
38
38
) ENGINE=InnoDB COLLATE = utf8_general_ci
39
39
ALTER TABLE t4 ENABLE KEYS, RENAME t5, DISABLE KEYS, RENAME t6, ENABLE KEYS;
40
40
Warnings:
48
48
  `a` INT NOT NULL,
49
49
  `b` INT DEFAULT NULL,
50
50
  `c` INT DEFAULT NULL,
51
 
  PRIMARY KEY (`a`)
 
51
  PRIMARY KEY (`a`) USING BTREE
52
52
) ENGINE=InnoDB COLLATE = utf8_general_ci
53
53
DROP TABLE t6;