~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb.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:
2048
2048
  `v` varchar(10) DEFAULT NULL
2049
2049
) ENGINE=InnoDB
2050
2050
drop table t1;
2051
 
create  table t1 (v varchar(10), c char(10)) row_format=fixed;
2052
 
Warnings:
2053
 
Warning 1478    InnoDB: assuming ROW_FORMAT=COMPACT.
 
2051
create  table t1 (v varchar(10), c char(10));
2054
2052
show create table t1;
2055
2053
Table   Create Table
2056
2054
t1      CREATE TABLE `t1` (
2057
2055
  `v` varchar(10) DEFAULT NULL,
2058
2056
  `c` varchar(10) DEFAULT NULL
2059
 
) ENGINE=InnoDB ROW_FORMAT=FIXED
 
2057
) ENGINE=InnoDB
2060
2058
insert into t1 values('a','a'),('a ','a ');
2061
2059
select concat('*',v,'*',c,'*') from t1;
2062
2060
concat('*',v,'*',c,'*')