← Back to branch summary

~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-19 18:26:26 UTC
  • mto: (1223.1.4 push) (1226.1.2 push)
  • mto: This revision was merged to the branch mainline in revision 1224.
  • Revision ID: brian@gaz-20091119182626-5w98h5vnf1819sco
Fix engines to not rely on HA_CREATE_INFO.

There were a number of test cases where Innodb was accepting the wrong
ROW_FORMAT and just tossing warnings. It would cause the DFE to then be
different then the actual table definition.

Show diffs side-by-side

added added

removed removed

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