Debian Codegraph @

mysql-test/suite/sys_vars/t/default_password_lifetime_basic.test

raw
1 ###############################################################################
2 # #
3 # File containing basic tests for passsord lifetime variable #
4 # #
5 ###############################################################################
6
7 --echo # Default values
8 SELECT @@GLOBAL.default_password_lifetime;
9 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
10 SELECT @@SESSION.default_password_lifetime;
11
12 SET @saved_value = @@global.default_password_lifetime;
13
14 --echo # Valid values
15 SET GLOBAL default_password_lifetime = 0;
16 SET GLOBAL default_password_lifetime = 1;
17 SET GLOBAL default_password_lifetime = 65535;
18 SET GLOBAL default_password_lifetime = 9999;
19
20 --echo # Invalid values: there shall be warnings about truncation
21 SET GLOBAL default_password_lifetime = -1;
22 SET GLOBAL default_password_lifetime = -1024;
23 SET GLOBAL default_password_lifetime = 65536;
24 SET GLOBAL default_password_lifetime = 99999;
25
26 SET GLOBAL default_password_lifetime = @saved_value;