diff options
author | Matthias Leich <mleich@mysql.com> | 2008-08-22 19:49:51 +0200 |
---|---|---|
committer | Matthias Leich <mleich@mysql.com> | 2008-08-22 19:49:51 +0200 |
commit | 82aa8e2129a34cc41d231ef7e50d2b87d8227e09 (patch) | |
tree | dbc81d24fa5072b1becd2a5d3579f1ea7ad7382f /mysql-test | |
parent | 9bc9ddd56ee48fd656596385efbb97e8871a0975 (diff) | |
download | mariadb-git-82aa8e2129a34cc41d231ef7e50d2b87d8227e09.tar.gz |
Fix for
Bug#26687 rpl_ddl test fails if run with --innodb option
Details:
- The current test + the expected results do only fit
if the slave uses MyISAM for mysqltest1.t1.
Therefore skip the test if we do not meet these
conditions.
- The solution for 5.1 will look quite different
because "ps_ddl" is already much improved in
MySQL 5.1.
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/t/rpl_ddl.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_ddl.test b/mysql-test/t/rpl_ddl.test index d2a41a305b6..23841ee3491 100644 --- a/mysql-test/t/rpl_ddl.test +++ b/mysql-test/t/rpl_ddl.test @@ -55,6 +55,18 @@ DROP DATABASE IF EXISTS mysqltest3; CREATE DATABASE mysqltest1; CREATE DATABASE mysqltest2; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB"; +# Prevent Bug#26687 rpl_ddl test fails if run with --innodb option +# The current testscripts + the expected result need that the slave uses MyISAM +# for the table mysqltest.t1. +sync_slave_with_master; +connection slave; +if (`SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES + WHERE TABLE_SCHEMA = 'mysqltest1' AND TABLE_NAME = 't1' + AND ENGINE <> 'MyISAM'`) +{ + skip This test needs on slave side: InnoDB disabled, default engine: MyISAM; +} +connection master; INSERT INTO mysqltest1.t1 SET f1= 0; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB"; |