mysql-test/suite/roles/set_default_role_ps-6960.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

#
# MDEV-6960 Server crashes in check_alter_user on setting a default role via PS
#

--source include/not_embedded.inc

select priv into @root_priv from mysql.global_priv where user='root' and host='localhost';

create role r1;
prepare stmt from "set password = '11111111111111111111111111111111111111111'";
execute stmt;
prepare stmt from "set default role r1";
execute stmt;

set password = '';
set default role NONE;
drop role r1;

#cleanup
update mysql.global_priv set priv=@root_priv where user='root' and host='localhost';