diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-01-13 11:50:33 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-01-13 11:50:33 +0400 |
| commit | 1f0ad6c6b3421a815ea6373c66aaf693852342cf (patch) | |
| tree | b5362aa495d81fd8940e0c299a15d374e41b433e /mysql-test/t/create_drop_binlog.test | |
| parent | a68ad5d50f5a3a6f7ef4d573e889aa97cfc6d749 (diff) | |
| download | mariadb-git-1f0ad6c6b3421a815ea6373c66aaf693852342cf.tar.gz | |
MDEV-7288 USER/ROLE: CREATE OR REPLACE, CREATE IF NOT EXISTS, DROP IF EXISTS
Diffstat (limited to 'mysql-test/t/create_drop_binlog.test')
| -rw-r--r-- | mysql-test/t/create_drop_binlog.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/t/create_drop_binlog.test b/mysql-test/t/create_drop_binlog.test index 655a54308d6..5bcd7832dc5 100644 --- a/mysql-test/t/create_drop_binlog.test +++ b/mysql-test/t/create_drop_binlog.test @@ -95,3 +95,27 @@ DROP VIEW IF EXISTS v1; --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 ROLE r1; +CREATE OR REPLACE ROLE r1; +DROP ROLE r1; +CREATE ROLE IF NOT EXISTS r1; +CREATE ROLE IF NOT EXISTS r1; +DROP ROLE IF EXISTS r1; +DROP ROLE IF EXISTS r1; +--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 USER u1@localhost; +CREATE OR REPLACE USER u1@localhost; +DROP USER u1@localhost; +CREATE USER IF NOT EXISTS u1@localhost; +CREATE USER IF NOT EXISTS u1@localhost; +DROP USER IF EXISTS u1@localhost; +DROP USER IF EXISTS u1@localhost; +--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; |