summaryrefslogtreecommitdiff
path: root/mysql-test/suite/roles/set_default_role_for.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/roles/set_default_role_for.test')
-rw-r--r--mysql-test/suite/roles/set_default_role_for.test2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/suite/roles/set_default_role_for.test b/mysql-test/suite/roles/set_default_role_for.test
index de35b529ce6..985eaa16e3d 100644
--- a/mysql-test/suite/roles/set_default_role_for.test
+++ b/mysql-test/suite/roles/set_default_role_for.test
@@ -66,7 +66,7 @@ show grants;
select user, host, default_role from mysql.user where user like 'user_%';
# Make sure the default role setting worked from root.
-insert into mysql.user (user, host) values ('someuser', 'somehost');
+insert ignore into mysql.user (user, host) values ('someuser', 'somehost');
# Since we have update privileges on the mysql.user table, we should
# be able to set a default role for a different user.
set default role NONE for user_a@localhost;