← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/alter_table.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.result
366
366
t1      CREATE TABLE `t1` (
367
367
  `a` INT NOT NULL,
368
368
  `b` INT DEFAULT NULL,
369
 
  UNIQUE KEY `b` (`b`)
 
369
  UNIQUE KEY `b` (`b`) USING BTREE
370
370
) ENGINE=DEFAULT COLLATE = utf8_general_ci
371
371
ALTER TABLE t1 DROP PRIMARY KEY;
372
372
ERROR 42000: Can't DROP 'PRIMARY'; check that column/key exists
537
537
Table   Create Table
538
538
t1      CREATE TABLE `t1` (
539
539
  `a` INT DEFAULT NULL,
540
 
  KEY `i1` (`a`)
 
540
  KEY `i1` (`a`) USING BTREE
541
541
) ENGINE=DEFAULT ROW_FORMAT='COMPACT' COLLATE = utf8_general_ci
542
542
DROP INDEX i1 ON t1;
543
543
SHOW CREATE TABLE t1;