Debian Codegraph @

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

raw
1 SET @password_reuse_interval_save = @@global.password_reuse_interval;
2 SELECT @password_reuse_interval_save;
3 @password_reuse_interval_save
4 0
5 Default value must be 0 for global scope
6 SET @@global.password_reuse_interval = 1;
7 SET @@global.password_reuse_interval = DEFAULT;
8 SELECT @@global.password_reuse_interval;
9 @@global.password_reuse_interval
10 0
11 SET @@session.password_reuse_interval = 2;
12 ERROR HY000: Variable 'password_reuse_interval' is a GLOBAL variable and should be set with SET GLOBAL
13 SET @@session.password_reuse_interval = DEFAULT;
14 ERROR HY000: Variable 'password_reuse_interval' is a GLOBAL variable and should be set with SET GLOBAL
15 SELECT @@session.password_reuse_interval;
16 ERROR HY000: Variable 'password_reuse_interval' is a GLOBAL variable
17 SET @@global.password_reuse_interval = NULL;
18 ERROR 42000: Incorrect argument type to variable 'password_reuse_interval'
19 SET @@global.password_reuse_interval = '';
20 ERROR 42000: Incorrect argument type to variable 'password_reuse_interval'
21 SET @@global.password_reuse_interval = ' ';
22 ERROR 42000: Incorrect argument type to variable 'password_reuse_interval'
23 SET @@session.password_reuse_interval = NULL;
24 ERROR HY000: Variable 'password_reuse_interval' is a GLOBAL variable and should be set with SET GLOBAL
25 SET @@session.password_reuse_interval = '';
26 ERROR HY000: Variable 'password_reuse_interval' is a GLOBAL variable and should be set with SET GLOBAL
27 SET @@session.password_reuse_interval = ' ';
28 ERROR HY000: Variable 'password_reuse_interval' is a GLOBAL variable and should be set with SET GLOBAL
29 SET @@global.password_reuse_interval = 0;
30 SELECT @@global.password_reuse_interval;
31 @@global.password_reuse_interval
32 0
33 SET @@global.password_reuse_interval = 1;
34 SELECT @@global.password_reuse_interval;
35 @@global.password_reuse_interval
36 1
37 SET @@global.password_reuse_interval = TRUE;
38 SELECT @@global.password_reuse_interval;
39 @@global.password_reuse_interval
40 1
41 SET @@global.password_reuse_interval = FALSE;
42 SELECT @@global.password_reuse_interval;
43 @@global.password_reuse_interval
44 0
45 SET @@global.password_reuse_interval = 4294967295;
46 SELECT @@global.password_reuse_interval;
47 @@global.password_reuse_interval
48 4294967295
49 SET @@global.password_reuse_interval = DEFAULT;
50 SELECT @@global.password_reuse_interval;
51 @@global.password_reuse_interval
52 0
53 SET @@global.password_reuse_interval = -1;
54 Warnings:
55 Warning 1292 Truncated incorrect password_reuse_interval value: '-1'
56 SELECT @@global.password_reuse_interval;
57 @@global.password_reuse_interval
58 0
59 SET @@global.password_reuse_interval = 'ABC';
60 ERROR 42000: Incorrect argument type to variable 'password_reuse_interval'
61 SELECT @@global.password_reuse_interval;
62 @@global.password_reuse_interval
63 0
64 SET @@global.password_reuse_interval = ON;
65 ERROR 42000: Incorrect argument type to variable 'password_reuse_interval'
66 SELECT @@global.password_reuse_interval;
67 @@global.password_reuse_interval
68 0
69 SET @@global.password_reuse_interval = 'OFF';
70 ERROR 42000: Incorrect argument type to variable 'password_reuse_interval'
71 SELECT @@global.password_reuse_interval;
72 @@global.password_reuse_interval
73 0
74 SET @@global.password_reuse_interval = 2.14;
75 ERROR 42000: Incorrect argument type to variable 'password_reuse_interval'
76 SELECT @@global.password_reuse_interval;
77 @@global.password_reuse_interval
78 0
79 SET @@global.password_reuse_interval = NONE;
80 ERROR 42000: Incorrect argument type to variable 'password_reuse_interval'
81 SELECT @@global.password_reuse_interval;
82 @@global.password_reuse_interval
83 0
84 SET @@global.password_reuse_interval = -4294967295;
85 Warnings:
86 Warning 1292 Truncated incorrect password_reuse_interval value: '-4294967295'
87 SELECT @@global.password_reuse_interval;
88 @@global.password_reuse_interval
89 0
90 SET @@global.password_reuse_interval = 4294967296;
91 Warnings:
92 Warning 1292 Truncated incorrect password_reuse_interval value: '4294967296'
93 SELECT @@global.password_reuse_interval;
94 @@global.password_reuse_interval
95 4294967295
96 Must return 1
97 SELECT @@global.password_reuse_interval = VARIABLE_VALUE
98 FROM performance_schema.global_variables
99 WHERE VARIABLE_NAME='password_reuse_interval';
100 @@global.password_reuse_interval = VARIABLE_VALUE
101 1
102 SET GLOBAL password_reuse_interval = 1;
103 SET @@global.password_reuse_interval = 1;
104 SET global.password_reuse_interval = 1;
105 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.password_reuse_interval = 1' at line 1
106 SET @@password_reuse_interval = 1;
107 ERROR HY000: Variable 'password_reuse_interval' is a GLOBAL variable and should be set with SET GLOBAL
108 SET password_reuse_interval = 1;
109 ERROR HY000: Variable 'password_reuse_interval' is a GLOBAL variable and should be set with SET GLOBAL
110 SELECT global.password_reuse_interval;
111 ERROR 42S02: Unknown table 'global' in field list
112 SELECT GLOBAL password_reuse_interval;
113 ERROR 42S22: Unknown column 'GLOBAL' in 'field list'
114 SELECT @@password_reuse_interval;
115 @@password_reuse_interval
116 1
117 SET @@global.password_reuse_interval = @password_reuse_interval_save;