From f94c9b02cf91bd3ffb5381e7168ab554d3657c83 Mon Sep 17 00:00:00 2001 From: Philip Stoev Date: Thu, 3 Nov 2016 04:05:05 -0700 Subject: Galera MTR Tests: MW-305 , re-enable the test for ALTER USER --- mysql-test/suite/galera/r/galera_account_management.result | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'mysql-test/suite/galera/r/galera_account_management.result') 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 -- cgit v1.2.1