summaryrefslogtreecommitdiff
path: root/mysql-test/suite/binlog
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2016-03-25 10:36:33 +0100
committerOleksandr Byelkin <sanja@mariadb.com>2016-03-25 10:36:33 +0100
commit2481ed22455d430bce889cb25865b1f878c348ae (patch)
tree5e3dbd5c8f6d12bba0717aeb4244903a77919d36 /mysql-test/suite/binlog
parent3be95ee061b8695922981c67480b80167fb3f492 (diff)
parent9f5b285662ed8c13d6e87d8baf2f0ad4484d4a85 (diff)
downloadmariadb-git-2481ed22455d430bce889cb25865b1f878c348ae.tar.gz
Merge branch '10.1' into 10.2
Diffstat (limited to 'mysql-test/suite/binlog')
-rw-r--r--mysql-test/suite/binlog/r/binlog_concurrent_drop_create.result52
-rw-r--r--mysql-test/suite/binlog/t/binlog_concurrent_drop_create.test85
2 files changed, 0 insertions, 137 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_concurrent_drop_create.result b/mysql-test/suite/binlog/r/binlog_concurrent_drop_create.result
deleted file mode 100644
index 8db1dc4b75e..00000000000
--- a/mysql-test/suite/binlog/r/binlog_concurrent_drop_create.result
+++ /dev/null
@@ -1,52 +0,0 @@
-include/master-slave.inc
-[connection master]
-RESET MASTER;
-DROP DATABASE IF EXISTS db_717;
-DROP EVENT IF EXISTS test.e_x1;
-set @saved_global_binlog_format = @@global.binlog_format;
-set @saved_local_binlog_format = @@session.binlog_format;
-SET GLOBAL BINLOG_FORMAT = STATEMENT;
-SET SESSION BINLOG_FORMAT = STATEMENT;
-CREATE DATABASE db_717;
-CREATE FUNCTION db_717.f1() RETURNS INT RETURN 1;
-DROP DATABASE db_717;
-CREATE FUNCTION db_717.f2() RETURNS INT RETURN 1;
-CREATE DATABASE db_717;
-CREATE EVENT db_717.e_x1 ON SCHEDULE EVERY 1000 HOUR DO CREATE TABLE t1(id int);
-DROP DATABASE db_717;
-CREATE EVENT db_717.e_x2 ON SCHEDULE EVERY 1000 HOUR DO CREATE TABLE t1(id int);
-CREATE DATABASE db_717;
-CREATE EVENT test.e_x1 ON SCHEDULE EVERY 1000 HOUR DO CREATE TABLE t1(id int);
-DROP DATABASE db_717;
-ALTER EVENT test.e_x1 RENAME TO db_717.e_x2;
-DROP EVENT test.e_x1;
-include/show_binlog_events.inc
-Log_name Pos Event_type Server_id End_log_pos Info
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # DROP DATABASE IF EXISTS db_717
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # use `test`; DROP EVENT IF EXISTS test.e_x1
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # CREATE DATABASE db_717
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `db_717`.`f1`() RETURNS int(11)
-RETURN 1
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # DROP DATABASE db_717
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # CREATE DATABASE db_717
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT db_717.e_x1 ON SCHEDULE EVERY 1000 HOUR DO CREATE TABLE t1(id int)
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # DROP DATABASE db_717
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # CREATE DATABASE db_717
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT test.e_x1 ON SCHEDULE EVERY 1000 HOUR DO CREATE TABLE t1(id int)
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # DROP DATABASE db_717
-master-bin.000001 # Gtid # # GTID #-#-#
-master-bin.000001 # Query # # use `test`; DROP EVENT test.e_x1
-SET GLOBAL BINLOG_FORMAT = @saved_global_binlog_format;
-SET SESSION BINLOG_FORMAT = @saved_local_binlog_format;
-include/rpl_end.inc
diff --git a/mysql-test/suite/binlog/t/binlog_concurrent_drop_create.test b/mysql-test/suite/binlog/t/binlog_concurrent_drop_create.test
deleted file mode 100644
index c885a7291f7..00000000000
--- a/mysql-test/suite/binlog/t/binlog_concurrent_drop_create.test
+++ /dev/null
@@ -1,85 +0,0 @@
-# MDEV-717
-# DROP DATABASE and CREATE PROCEDURE|FUNCTION|EVENT
-# statements can appear in wrong order in the binlog.
-#
-# Note - the test can be undeterministic.
-
---source include/master-slave.inc
-RESET MASTER;
-
---disable_warnings
-DROP DATABASE IF EXISTS db_717;
-DROP EVENT IF EXISTS test.e_x1;
---enable_warnings
-
-set @saved_global_binlog_format = @@global.binlog_format;
-set @saved_local_binlog_format = @@session.binlog_format;
-SET GLOBAL BINLOG_FORMAT = STATEMENT;
-SET SESSION BINLOG_FORMAT = STATEMENT;
-
-# test function creation
-CREATE DATABASE db_717;
-
-CREATE FUNCTION db_717.f1() RETURNS INT RETURN 1;
-
---send
-
-DROP DATABASE db_717;
-
---connection master1
-
---error 0,ER_BAD_DB_ERROR
-
-CREATE FUNCTION db_717.f2() RETURNS INT RETURN 1;
-
---connection master
-
---reap
-
-# test event creation
-CREATE DATABASE db_717;
-
-CREATE EVENT db_717.e_x1 ON SCHEDULE EVERY 1000 HOUR DO CREATE TABLE t1(id int);
-
---send
-
-DROP DATABASE db_717;
-
---connection master1
-
---error 0,ER_BAD_DB_ERROR
-
-CREATE EVENT db_717.e_x2 ON SCHEDULE EVERY 1000 HOUR DO CREATE TABLE t1(id int);
-
---connection master
-
---reap
-
-# test event modification
-CREATE DATABASE db_717;
-
-CREATE EVENT test.e_x1 ON SCHEDULE EVERY 1000 HOUR DO CREATE TABLE t1(id int);
-
---send
-
-DROP DATABASE db_717;
-
---connection master1
-
---error 0,ER_BAD_DB_ERROR
-
-ALTER EVENT test.e_x1 RENAME TO db_717.e_x2;
-
---connection master
-
---reap
-
-DROP EVENT test.e_x1;
-
-source include/show_binlog_events.inc;
-
-SET GLOBAL BINLOG_FORMAT = @saved_global_binlog_format;
-SET SESSION BINLOG_FORMAT = @saved_local_binlog_format;
-
---source include/rpl_end.inc
-