EVOLUTION-MANAGER

Edit File: rpl_create_drop_role.result

include/master-slave.inc [connection master] connection master; CREATE ROLE role_1; connection slave; SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User; User role_1 connection master; CREATE ROLE IF NOT EXISTS role_1; Warnings: Note 1975 Can't create role 'role_1'; it already exists CREATE ROLE IF NOT EXISTS role_2; connection slave; SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User; User role_1 role_2 connection master; CREATE OR REPLACE ROLE IF NOT EXISTS role_3; ERROR HY000: Incorrect usage of OR REPLACE and IF NOT EXISTS CREATE OR REPLACE ROLE role_3; CREATE OR REPLACE ROLE role_2; connection slave; SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User; User role_1 role_2 role_3 connection master; CREATE ROLE role_2; ERROR HY000: Operation CREATE ROLE failed for 'role_2' connection slave; SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User; User role_1 role_2 role_3 connection master; DROP ROLE role_1; DROP ROLE IF EXISTS role_2; DROP ROLE IF EXISTS role_3; DROP ROLE IF EXISTS role_4; Warnings: Note 1976 Can't drop role 'role_4'; it doesn't exist DROP ROLE role_4; ERROR HY000: Operation DROP ROLE failed for 'role_4' connection slave; SELECT User FROM mysql.user WHERE is_role='Y' ORDER BY User; User include/rpl_end.inc