Debian Codegraph @

mysql-test/suite/roles/create_and_drop_role_invalid_user_table.result

raw
1 # switching from mysql.global_priv to mysql.user
2 connect mysql, localhost, root,,;
3 use mysql;
4 alter table user drop column is_role;
5 alter table user drop column default_role;
6 alter table user drop column max_statement_time;
7 flush privileges;
8 create role test_role;
9 ERROR HY000: Column count of mysql.user is wrong. Expected 45, found 44. Created with MariaDB MYSQL_VERSION_ID, now running MYSQL_VERSION_ID. Please use mariadb-upgrade to fix this error
10 drop role test_role;
11 ERROR HY000: Operation DROP ROLE failed for 'test_role'
12 alter table user add column is_role enum('N', 'Y') default 'N' not null
13 COLLATE utf8_general_ci
14 after password_expired;
15 create role test_role;
16 create user test_user@localhost;
17 grant test_role to test_user@localhost;
18 set default role test_role for root@localhost;
19 drop role test_role;
20 drop user test_user@localhost;
21 alter table user add column default_role char(80) default '' not null
22 COLLATE utf8_general_ci
23 after is_role;
24 alter table user add max_statement_time decimal(12,6) default 0 not null
25 after default_role;
26 update user set is_role='N';
27 flush privileges;
28 create role test_role;
29 drop role test_role;
30 # switching back from mysql.user to mysql.global_priv