diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2016-03-25 10:36:33 +0100 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2016-03-25 10:36:33 +0100 |
commit | 2481ed22455d430bce889cb25865b1f878c348ae (patch) | |
tree | 5e3dbd5c8f6d12bba0717aeb4244903a77919d36 /mysql-test/suite/binlog | |
parent | 3be95ee061b8695922981c67480b80167fb3f492 (diff) | |
parent | 9f5b285662ed8c13d6e87d8baf2f0ad4484d4a85 (diff) | |
download | mariadb-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.result | 52 | ||||
-rw-r--r-- | mysql-test/suite/binlog/t/binlog_concurrent_drop_create.test | 85 |
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 - |