diff options
| author | Philip Stoev <philip.stoev@galeracluster.com> | 2016-11-03 04:05:05 -0700 |
|---|---|---|
| committer | Sachin Setiya <sachinsetia1001@gmail.com> | 2017-03-14 07:13:22 +0530 |
| commit | 395c420f0fbbd675d2bc32f195bfc2ce7b730d5e (patch) | |
| tree | 160fa04609427cf0644387fa9305d403e2e6fdba /mysql-test/suite | |
| parent | 0a06347333092b54a5545f1c3ce51cd527f7571d (diff) | |
| download | mariadb-git-395c420f0fbbd675d2bc32f195bfc2ce7b730d5e.tar.gz | |
Galera MTR Tests: MW-305 , re-enable the test for ALTER USER
Diffstat (limited to 'mysql-test/suite')
| -rw-r--r-- | mysql-test/suite/galera/r/galera_account_management.result | 7 | ||||
| -rw-r--r-- | mysql-test/suite/galera/t/galera_account_management.test | 14 |
2 files changed, 13 insertions, 8 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 diff --git a/mysql-test/suite/galera/t/galera_account_management.test b/mysql-test/suite/galera/t/galera_account_management.test index 357319ad106..6dea0fcfa9e 100644 --- a/mysql-test/suite/galera/t/galera_account_management.test +++ b/mysql-test/suite/galera/t/galera_account_management.test @@ -18,14 +18,12 @@ SELECT COUNT(*) = 2 FROM mysql.user WHERE user IN ('user1', 'user2'); # ALTER USER # -# LP bug 1376269 -# -#--connection node_1 -#ALTER USER user1 PASSWORD EXPIRE; -#SELECT password_expired = 'Y' FROM mysql.user WHERE user = 'user1'; -# -#--connection node_2 -#SELECT password_expired = 'Y' FROM mysql.user WHERE user = 'user1'; +--connection node_1 +ALTER USER user1 PASSWORD EXPIRE; +SELECT password_expired = 'Y' FROM mysql.user WHERE user = 'user1'; + +--connection node_2 +SELECT password_expired = 'Y' FROM mysql.user WHERE user = 'user1'; # # RENAME USER |