diff options
Diffstat (limited to 'mysql-test/main/system_mysql_db_507.result')
| -rw-r--r-- | mysql-test/main/system_mysql_db_507.result | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/main/system_mysql_db_507.result b/mysql-test/main/system_mysql_db_507.result index bf4d3115da5..767b8fee102 100644 --- a/mysql-test/main/system_mysql_db_507.result +++ b/mysql-test/main/system_mysql_db_507.result @@ -186,5 +186,38 @@ show create user user1@localhost; CREATE USER for user1@localhost CREATE USER 'user1'@'localhost' # +# Test password expiration fields are loaded correctly +# +create user user@localhost; +show create user user@localhost; +CREATE USER for user@localhost +CREATE USER 'user'@'localhost' +alter user user@localhost password expire; +show create user user@localhost; +CREATE USER for user@localhost +CREATE USER 'user'@'localhost' PASSWORD EXPIRE +set password for user@localhost= password(''); +alter user user@localhost password expire default; +show create user user@localhost; +CREATE USER for user@localhost +CREATE USER 'user'@'localhost' +alter user user@localhost password expire never; +show create user user@localhost; +CREATE USER for user@localhost +CREATE USER 'user'@'localhost' PASSWORD EXPIRE NEVER +alter user user@localhost password expire interval 123 day; +show create user user@localhost; +CREATE USER for user@localhost +CREATE USER 'user'@'localhost' PASSWORD EXPIRE INTERVAL 123 DAY +alter user user@localhost password expire; +show create user user@localhost; +CREATE USER for user@localhost +CREATE USER 'user'@'localhost' PASSWORD EXPIRE +set password for user@localhost= password(''); +show create user user@localhost; +CREATE USER for user@localhost +CREATE USER 'user'@'localhost' PASSWORD EXPIRE INTERVAL 123 DAY +drop user user@localhost; +# # Reset to final original state. # |