Debian Codegraph @

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

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