~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/alter_table.result

  • Committer: Brian Aker
  • Date: 2009-11-20 19:07:14 UTC
  • mfrom: (1223.1.5 push)
  • Revision ID: brian@gaz-20091120190714-dhr3lgqxrt7dq1fc
Collected Merge.

Show diffs side-by-side

added added

removed removed

Lines of Context:
532
532
alter table test.t1 rename test.t1;
533
533
use test;
534
534
drop table t1;
535
 
CREATE TABLE t1(a INT) ROW_FORMAT=FIXED;
536
 
Warnings:
537
 
Warning 1478    InnoDB: assuming ROW_FORMAT=COMPACT.
 
535
CREATE TABLE t1(a INT) ROW_FORMAT=COMPACT;
538
536
CREATE INDEX i1 ON t1(a);
539
537
SHOW CREATE TABLE t1;
540
538
Table   Create Table
541
539
t1      CREATE TABLE `t1` (
542
540
  `a` int DEFAULT NULL,
543
541
  KEY `i1` (`a`)
544
 
) ENGINE=DEFAULT ROW_FORMAT=FIXED
 
542
) ENGINE=DEFAULT ROW_FORMAT=COMPACT
545
543
DROP INDEX i1 ON t1;
546
544
SHOW CREATE TABLE t1;
547
545
Table   Create Table
548
546
t1      CREATE TABLE `t1` (
549
547
  `a` int DEFAULT NULL
550
 
) ENGINE=DEFAULT ROW_FORMAT=FIXED
 
548
) ENGINE=DEFAULT ROW_FORMAT=COMPACT
551
549
DROP TABLE t1;
552
550
DROP TABLE IF EXISTS bug24219;
553
551
DROP TABLE IF EXISTS bug24219_2;