summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--mysql-test/extra/rpl_tests/rpl_flsh_tbls.test4
-rw-r--r--mysql-test/r/rpl_sp004.result16
-rw-r--r--mysql-test/t/rpl_multi_engine.test3
-rw-r--r--mysql-test/t/rpl_row_basic_11bugs.test4
-rw-r--r--mysql-test/t/rpl_sp004.test16
5 files changed, 27 insertions, 16 deletions
diff --git a/mysql-test/extra/rpl_tests/rpl_flsh_tbls.test b/mysql-test/extra/rpl_tests/rpl_flsh_tbls.test
index cfa943228fa..8406c10af9b 100644
--- a/mysql-test/extra/rpl_tests/rpl_flsh_tbls.test
+++ b/mysql-test/extra/rpl_tests/rpl_flsh_tbls.test
@@ -3,6 +3,10 @@
# RENAME TABLE work with MERGE tables on the slave.
# Test of FLUSH NO_WRITE_TO_BINLOG by the way.
#
+
+# Merge will not work with a default ndb engine
+-- source include/not_ndb_default.inc
+
-- source include/master-slave.inc
create table t1 (a int);
diff --git a/mysql-test/r/rpl_sp004.result b/mysql-test/r/rpl_sp004.result
index dfc672d4cd7..1c0ed3cc50a 100644
--- a/mysql-test/r/rpl_sp004.result
+++ b/mysql-test/r/rpl_sp004.result
@@ -26,25 +26,25 @@ DROP TABLE IF EXISTS test.t2;
INSERT INTO test.t3 VALUES(NULL,11111111.233333,NOW());
END|
CALL test.p1();
-SELECT * FROM test.t1;
+SELECT * FROM test.t1 ORDER BY a;
a
1
2
3
12
-SELECT * FROM test.t2;
+SELECT * FROM test.t2 ORDER BY a;
a
1
2
3
8
-SELECT * FROM test.t1;
+SELECT * FROM test.t1 ORDER BY a;
a
1
2
3
12
-SELECT * FROM test.t2;
+SELECT * FROM test.t2 ORDER BY a;
a
1
2
@@ -62,25 +62,25 @@ t3
CALL test.p1();
Warnings:
Note 1050 Table 't3' already exists
-SELECT * FROM test.t1;
+SELECT * FROM test.t1 ORDER BY a;
a
1
2
3
12
-SELECT * FROM test.t2;
+SELECT * FROM test.t2 ORDER BY a;
a
1
2
3
8
-SELECT * FROM test.t1;
+SELECT * FROM test.t1 ORDER BY a;
a
1
2
3
12
-SELECT * FROM test.t2;
+SELECT * FROM test.t2 ORDER BY a;
a
1
2
diff --git a/mysql-test/t/rpl_multi_engine.test b/mysql-test/t/rpl_multi_engine.test
index 3f7b7b11c0d..9ebbdfe27de 100644
--- a/mysql-test/t/rpl_multi_engine.test
+++ b/mysql-test/t/rpl_multi_engine.test
@@ -1,5 +1,8 @@
# See if replication between MyISAM, MEMORY and InnoDB works.
+# Results files do not match when ndb is default
+-- source include/not_ndb_default.inc
+
-- source include/master-slave.inc
connection slave;
diff --git a/mysql-test/t/rpl_row_basic_11bugs.test b/mysql-test/t/rpl_row_basic_11bugs.test
index d098723644f..f0a66acc681 100644
--- a/mysql-test/t/rpl_row_basic_11bugs.test
+++ b/mysql-test/t/rpl_row_basic_11bugs.test
@@ -1,5 +1,9 @@
--source include/have_row_based.inc
--source include/have_binlog_format_row.inc
+
+# Show binlog events will cause failure when ndb is default
+-- source include/not_ndb_default.inc
+
--source include/master-slave.inc
# Bug#15942 (RBR ignores --binlog_ignore_db and tries to map to table
diff --git a/mysql-test/t/rpl_sp004.test b/mysql-test/t/rpl_sp004.test
index 335a17c7af0..055a13cc157 100644
--- a/mysql-test/t/rpl_sp004.test
+++ b/mysql-test/t/rpl_sp004.test
@@ -44,13 +44,13 @@ END|
delimiter ;|
CALL test.p1();
-SELECT * FROM test.t1;
-SELECT * FROM test.t2;
+SELECT * FROM test.t1 ORDER BY a;
+SELECT * FROM test.t2 ORDER BY a;
save_master_pos;
connection slave;
sync_with_master;
-SELECT * FROM test.t1;
-SELECT * FROM test.t2;
+SELECT * FROM test.t1 ORDER BY a;
+SELECT * FROM test.t2 ORDER BY a;
connection master;
CALL test.p2();
@@ -66,14 +66,14 @@ SHOW TABLES;
connection master;
CALL test.p1();
-SELECT * FROM test.t1;
-SELECT * FROM test.t2;
+SELECT * FROM test.t1 ORDER BY a;
+SELECT * FROM test.t2 ORDER BY a;
#SELECT * FROM test.t3;
save_master_pos;
connection slave;
sync_with_master;
-SELECT * FROM test.t1;
-SELECT * FROM test.t2;
+SELECT * FROM test.t1 ORDER BY a;
+SELECT * FROM test.t2 ORDER BY a;
#SELECT * FROM test.t3;
--exec $MYSQL_DUMP --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/sp004_master.sql