diff options
author | Philip Stoev <philip.stoev@galeracluster.com> | 2016-11-03 04:05:05 -0700 |
---|---|---|
committer | Sachin Setiya <sachin.setiya@mariadb.com> | 2017-04-06 15:41:54 +0530 |
commit | f94c9b02cf91bd3ffb5381e7168ab554d3657c83 (patch) | |
tree | 4be66b5207b61bb52d0c6d7a313cfc7318993508 /mysql-test/suite/galera/r/galera_account_management.result | |
parent | 0f6aa6ba6609c135b0f69aa56b45f9ebe80c4258 (diff) | |
download | mariadb-git-f94c9b02cf91bd3ffb5381e7168ab554d3657c83.tar.gz |
Galera MTR Tests: MW-305 , re-enable the test for ALTER USER
Diffstat (limited to 'mysql-test/suite/galera/r/galera_account_management.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_account_management.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_account_management.result b/mysql-test/suite/galera/r/galera_account_management.result index 9b3ae9ba46e..4fa33a63064 100644 --- a/mysql-test/suite/galera/r/galera_account_management.result +++ b/mysql-test/suite/galera/r/galera_account_management.result @@ -2,6 +2,13 @@ CREATE USER user1, user2 IDENTIFIED BY 'password'; SELECT COUNT(*) = 2 FROM mysql.user WHERE user IN ('user1', 'user2'); COUNT(*) = 2 1 +ALTER USER user1 PASSWORD EXPIRE; +SELECT password_expired = 'Y' FROM mysql.user WHERE user = 'user1'; +password_expired = 'Y' +1 +SELECT password_expired = 'Y' FROM mysql.user WHERE user = 'user1'; +password_expired = 'Y' +1 RENAME USER user2 TO user3; SELECT COUNT(*) = 0 FROM mysql.user WHERE user = 'user2'; COUNT(*) = 0 |