WL#7112: Migrate federated test suite to run with innodb storage engine
Status: Complete — Priority: Medium
We have switched the default engine to innodb in MTR and added a line force_myisam_default.inc to all existing tests. This WL will migrate the tests in federated suite to actually run with innodb.
1)Migrate federated test suite i.e remove force_myisam_default.inc after verifying that these are not MyISAM specific tests. 2)If there are any failures observed they should be fixed.
1) removed "--source include/force_myisam_default.inc" line from all the federated suite tests. 2) When federated test suite tests were run with InnoDB as default engine, only one test failure was observed ( federated.test ). Following was the failure seen : CURRENT_TEST: federated.federated --- /home/akhila/work/repo/mysql-trunk/mysql-test/suite/federated/federated.result 2013-06-03 15:52:03.138288000 +0300 +++ /home/akhila/work/repo/mysql-trunk/mysql-test/var/log/federated.reject 2013-06-25 09:26:50.352442625 +0300 @@ -1152,6 +1152,9 @@ int, i983 int, i984 int, i985 int, i986 int, i987 int, i988 int, i989 int, i990 int, i991 int, i992 int, i993 int, i994 int, i995 int, i996 int, i997 int, i998 int, i999 int, i1000 int, b varchar(256)) row_format=dynamic; +Warnings: +Warning 1478 InnoDB: ROW_FORMAT=DYNAMIC requires innodb_file_format > Antelope. +Warning 1478 InnoDB: assuming ROW_FORMAT=COMPACT. DROP TABLE IF EXISTS federated.t1; CREATE TABLE federated.t1 (i1 int, i2 int, i3 int, i4 int, i5 int, i6 int, i7 int, i8 mysqltest: Result content mismatch In the test there is a table that is created with dynamic row_format. So when this test runs with innodb engine, a warning would be shown saying that it requires innodb_file_format > Antelope. But the default value of innodb_file_format is Antelope. Hence to fix this failure, the innodb_file_format is changed to Barracuda before creating the table and set back to default value (Antelope) after dropping the table.
Copyright (c) 2000, 2017, Oracle Corporation and/or its affiliates. All rights reserved.