Debian Codegraph @

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

raw
1 #
2 # MDEV-6960 Server crashes in check_alter_user on setting a default role via PS
3 #
4
5 --source include/not_embedded.inc
6
7 --disable_cursor_protocol
8 select priv into @root_priv from mysql.global_priv where user='root' and host='localhost';
9 --enable_cursor_protocol
10
11 create role r1;
12 prepare stmt from "set password = '11111111111111111111111111111111111111111'";
13 execute stmt;
14 prepare stmt from "set default role r1";
15 execute stmt;
16
17 set password = '';
18 set default role NONE;
19 drop role r1;
20
21 #cleanup
22 update mysql.global_priv set priv=@root_priv where user='root' and host='localhost';