diff options
Diffstat (limited to 'mysql-test/suite/roles/create_and_drop_role_invalid_user_table.result')
-rw-r--r-- | mysql-test/suite/roles/create_and_drop_role_invalid_user_table.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/suite/roles/create_and_drop_role_invalid_user_table.result b/mysql-test/suite/roles/create_and_drop_role_invalid_user_table.result new file mode 100644 index 00000000000..27149c4bf17 --- /dev/null +++ b/mysql-test/suite/roles/create_and_drop_role_invalid_user_table.result @@ -0,0 +1,28 @@ +use mysql; +alter table user drop column is_role; +alter table user drop column default_role; +alter table user drop column max_statement_time; +flush privileges; +create role test_role; +ERROR HY000: Column count of mysql.user is wrong. Expected 44, found 43. Created with MariaDB MYSQL_VERSION_ID, now running MYSQL_VERSION_ID. Please use mysql_upgrade to fix this error. +drop role test_role; +ERROR HY000: Operation DROP ROLE failed for 'test_role' +alter table user add column is_role enum('N', 'Y') default 'N' not null +COLLATE utf8_general_ci +after password_expired; +create role test_role; +create user test_user@localhost; +grant test_role to test_user@localhost; +set default role test_role for root@localhost; +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 mysql_upgrade to fix this error. +drop role test_role; +drop user test_user@localhost; +alter table user add column default_role char(80) binary default '' not null +COLLATE utf8_general_ci +after is_role; +alter table user add max_statement_time decimal(12,6) default 0 not null +after default_role; +update user set is_role='N'; +flush privileges; +create role test_role; +drop role test_role; |