Description:
Now that we again build a "classic" configuration in 5.0,
we get failing tests because they assume InnoDB to be configured:
-------------------------------------------------------
*** r/create.result
--- r/create.reject
***************
*** 770,775
create table t1(f1 varchar(800) binary not null, key(f1)) engine = innodb
character set utf8 collate utf8_general_ci;
Warnings:
! Warning 1071 Specified key was too long; max key length is 765 bytes
insert into t1 values('aaa');
drop table t1;
--- 770,776
create table t1(f1 varchar(800) binary not null, key(f1)) engine = innodb
character set utf8 collate utf8_general_ci;
Warnings:
! Warning 1266 Using storage engine MyISAM for table 't1'
! Warning 1071 Specified key was too long; max key length is 999 bytes
insert into t1 values('aaa');
drop table t1;
-------------------------------------------------------
-------------------------------------------------------
*** r/lock_multi.result
--- r/lock_multi.reject
***************
*** 83,88
--- 83,90
UNLOCK TABLES;
DROP TABLE t1;
create table t1 (f1 int(12) unsigned not null auto_increment, primary key(f1)) engine=innodb;
+ Warnings:
+ Warning 1266 Using storage engine MyISAM for table 't1'
lock tables t1 write;
alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_i
ncrement=0; alter table t1 auto_increment=0; //
alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_i
ncrement=0; alter table t1 auto_increment=0; //
-------------------------------------------------------
-------------------------------------------------------
*** r/sp.result
--- r/sp.reject
***************
*** 4787,4792
--- 4787,4794
drop table t3|
drop procedure bug16887|
create table t3 (f1 int, f2 varchar(3), primary key(f1)) engine=innodb|
+ Warnings:
+ Warning 1266 Using storage engine MyISAM for table 't3'
insert into t3 values (1,'aaa'),(2,'bbb'),(3,'ccc')|
CREATE FUNCTION bug13575 ( p1 integer )
returns varchar(3)
-------------------------------------------------------
-------------------------------------------------------
*** r/view.result
--- r/view.reject
***************
*** 1981,1986
--- 1981,1988
drop table t1;
set sql_mode='strict_all_tables';
CREATE TABLE t1 (col1 INT NOT NULL, col2 INT NOT NULL) ENGINE = INNODB;
+ Warnings:
+ Warning 1266 Using storage engine MyISAM for table 't1'
CREATE VIEW v1 (vcol1) AS SELECT col1 FROM t1;
CREATE VIEW v2 (vcol1) AS SELECT col1 FROM t1 WHERE col2 > 2;
INSERT INTO t1 (col1) VALUES(12);
***************
*** 2033,2038
--- 2035,2042
drop view v1;
drop table t1;
CREATE TABLE t1 (f1 char) ENGINE = innodb;
+ Warnings:
+ Warning 1266 Using storage engine MyISAM for table 't1'
INSERT INTO t1 VALUES ('A');
CREATE VIEW v1 AS SELECT * FROM t1;
INSERT INTO t1 VALUES('B');
-------------------------------------------------------
How to repeat:
Build "classic" and test it.
Suggested fix:
Split these tests into a general part and one requiring InnoDB,
or make them completely requiring InnoDB.
Description: Now that we again build a "classic" configuration in 5.0, we get failing tests because they assume InnoDB to be configured: ------------------------------------------------------- *** r/create.result --- r/create.reject *************** *** 770,775 create table t1(f1 varchar(800) binary not null, key(f1)) engine = innodb character set utf8 collate utf8_general_ci; Warnings: ! Warning 1071 Specified key was too long; max key length is 765 bytes insert into t1 values('aaa'); drop table t1; --- 770,776 create table t1(f1 varchar(800) binary not null, key(f1)) engine = innodb character set utf8 collate utf8_general_ci; Warnings: ! Warning 1266 Using storage engine MyISAM for table 't1' ! Warning 1071 Specified key was too long; max key length is 999 bytes insert into t1 values('aaa'); drop table t1; ------------------------------------------------------- ------------------------------------------------------- *** r/lock_multi.result --- r/lock_multi.reject *************** *** 83,88 --- 83,90 UNLOCK TABLES; DROP TABLE t1; create table t1 (f1 int(12) unsigned not null auto_increment, primary key(f1)) engine=innodb; + Warnings: + Warning 1266 Using storage engine MyISAM for table 't1' lock tables t1 write; alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_i ncrement=0; alter table t1 auto_increment=0; // alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_increment=0; alter table t1 auto_i ncrement=0; alter table t1 auto_increment=0; // ------------------------------------------------------- ------------------------------------------------------- *** r/sp.result --- r/sp.reject *************** *** 4787,4792 --- 4787,4794 drop table t3| drop procedure bug16887| create table t3 (f1 int, f2 varchar(3), primary key(f1)) engine=innodb| + Warnings: + Warning 1266 Using storage engine MyISAM for table 't3' insert into t3 values (1,'aaa'),(2,'bbb'),(3,'ccc')| CREATE FUNCTION bug13575 ( p1 integer ) returns varchar(3) ------------------------------------------------------- ------------------------------------------------------- *** r/view.result --- r/view.reject *************** *** 1981,1986 --- 1981,1988 drop table t1; set sql_mode='strict_all_tables'; CREATE TABLE t1 (col1 INT NOT NULL, col2 INT NOT NULL) ENGINE = INNODB; + Warnings: + Warning 1266 Using storage engine MyISAM for table 't1' CREATE VIEW v1 (vcol1) AS SELECT col1 FROM t1; CREATE VIEW v2 (vcol1) AS SELECT col1 FROM t1 WHERE col2 > 2; INSERT INTO t1 (col1) VALUES(12); *************** *** 2033,2038 --- 2035,2042 drop view v1; drop table t1; CREATE TABLE t1 (f1 char) ENGINE = innodb; + Warnings: + Warning 1266 Using storage engine MyISAM for table 't1' INSERT INTO t1 VALUES ('A'); CREATE VIEW v1 AS SELECT * FROM t1; INSERT INTO t1 VALUES('B'); ------------------------------------------------------- How to repeat: Build "classic" and test it. Suggested fix: Split these tests into a general part and one requiring InnoDB, or make them completely requiring InnoDB.