Debian Codegraph @

mysql-test/suite/sys_vars/r/default_password_lifetime_basic.result

raw
1 # Default values
2 SELECT @@GLOBAL.default_password_lifetime;
3 @@GLOBAL.default_password_lifetime
4 0
5 SELECT @@SESSION.default_password_lifetime;
6 ERROR HY000: Variable 'default_password_lifetime' is a GLOBAL variable
7 SET @saved_value = @@global.default_password_lifetime;
8 # Valid values
9 SET GLOBAL default_password_lifetime = 0;
10 SET GLOBAL default_password_lifetime = 1;
11 SET GLOBAL default_password_lifetime = 65535;
12 SET GLOBAL default_password_lifetime = 9999;
13 # Invalid values: there shall be warnings about truncation
14 SET GLOBAL default_password_lifetime = -1;
15 Warnings:
16 Warning 1292 Truncated incorrect default_password_lifetime value: '-1'
17 SET GLOBAL default_password_lifetime = -1024;
18 Warnings:
19 Warning 1292 Truncated incorrect default_password_lifetime value: '-1024'
20 SET GLOBAL default_password_lifetime = 65536;
21 Warnings:
22 Warning 1292 Truncated incorrect default_password_lifetime value: '65536'
23 SET GLOBAL default_password_lifetime = 99999;
24 Warnings:
25 Warning 1292 Truncated incorrect default_password_lifetime value: '99999'
26 SET GLOBAL default_password_lifetime = @saved_value;