############################################################################### # # # File containing basic tests for passsord lifetime variable # # # ############################################################################### --echo # Default values SELECT @@GLOBAL.default_password_lifetime; --error ER_INCORRECT_GLOBAL_LOCAL_VAR SELECT @@SESSION.default_password_lifetime; SET @saved_value = @@global.default_password_lifetime; --echo # Valid values SET GLOBAL default_password_lifetime = 0; SET GLOBAL default_password_lifetime = 1; SET GLOBAL default_password_lifetime = 65535; SET GLOBAL default_password_lifetime = 9999; --echo # Invalid values: there shall be warnings about truncation SET GLOBAL default_password_lifetime = -1; SET GLOBAL default_password_lifetime = -1024; SET GLOBAL default_password_lifetime = 65536; SET GLOBAL default_password_lifetime = 99999; SET GLOBAL default_password_lifetime = @saved_value;