diff options
| author | Alexander Barkov <bar@mariadb.org> | 2014-12-10 13:41:14 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2014-12-10 13:41:14 +0400 |
| commit | 822eb6ca3da3e1e93d4cf4845f3123fa4762e8cc (patch) | |
| tree | 8b6a32be44147e4d9fd5aad462649015ffaf8da5 /mysql-test/t/create_drop_binlog.test | |
| parent | 14cfb0acb83b3c9a4a1ae424f80a7bff1a8058b2 (diff) | |
| download | mariadb-git-822eb6ca3da3e1e93d4cf4845f3123fa4762e8cc.tar.gz | |
MDEV-7285 SERVER: CREATE OR REPLACE and CREATE IF NOT EXISTS
Diffstat (limited to 'mysql-test/t/create_drop_binlog.test')
| -rw-r--r-- | mysql-test/t/create_drop_binlog.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/create_drop_binlog.test b/mysql-test/t/create_drop_binlog.test index 105222f7e05..de8bc7a4933 100644 --- a/mysql-test/t/create_drop_binlog.test +++ b/mysql-test/t/create_drop_binlog.test @@ -19,6 +19,22 @@ DROP DATABASE IF EXISTS d1; RESET MASTER; USE test; +--echo # +--echo # CREATE SERVER is not logged +--echo # +CREATE OR REPLACE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test'); +CREATE OR REPLACE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test'); +DROP SERVER s1; +CREATE SERVER IF NOT EXISTS s1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test'); +CREATE SERVER IF NOT EXISTS s1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test'); +DROP SERVER IF EXISTS s1; +DROP SERVER IF EXISTS s1; +--replace_column 1 # 2 # 5 # +--replace_regex /xid=[0-9]+/xid=XX/ /GTID [0-9]+-[0-9]+-[0-9]+/GTID #-#-#/ /Server.ver.*/VER/ +SHOW BINLOG EVENTS; +RESET MASTER; + + CREATE OR REPLACE VIEW v1 AS SELECT 1; CREATE OR REPLACE VIEW v1 AS SELECT 1; |