Debian Codegraph @

mysql-test/suite/roles/create_and_drop_current.result

raw
1 create user foo@localhost;
2 grant create user on *.* to foo@localhost;
3 create user current_user;
4 ERROR HY000: Operation CREATE USER failed for CURRENT_USER
5 create user current_role;
6 ERROR HY000: Operation CREATE USER failed for CURRENT_ROLE
7 create role current_user;
8 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'current_user' at line 1
9 create role current_role;
10 ERROR HY000: Operation CREATE ROLE failed for CURRENT_ROLE
11 drop user current_user;
12 drop user current_role;
13 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'current_role' at line 1
14 drop role current_user;
15 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'current_user' at line 1
16 drop role current_role;
17 ERROR HY000: Operation DROP ROLE failed for CURRENT_ROLE
18 show warnings;
19 Level Code Message
20 Error 1446 Invalid definer
21 Error 1396 Operation DROP ROLE failed for CURRENT_ROLE
22 create role r1;
23 grant r1 to current_user;
24 set role r1;
25 select current_role();
26 current_role()
27 r1
28 create user current_role;
29 ERROR HY000: Operation CREATE USER failed for CURRENT_ROLE
30 create role current_role;
31 ERROR HY000: Operation CREATE ROLE failed for CURRENT_ROLE
32 drop user current_role;
33 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'current_role' at line 1
34 drop role current_role;