1SET @start_global_value = @@global.old_passwords;
2SELECT @start_global_value;
3@start_global_value
40
5SET @start_session_value = @@session.old_passwords;
6SELECT @start_session_value;
7@start_session_value
80
9'#--------------------FN_DYNVARS_114_01-------------------------#'
10SET @@global.old_passwords = ON;
11SET @@global.old_passwords = DEFAULT;
12SELECT @@global.old_passwords;
13@@global.old_passwords
140
15SET @@session.old_passwords = ON;
16SET @@session.old_passwords = DEFAULT;
17SELECT @@session.old_passwords;
18@@session.old_passwords
190
20'#--------------------FN_DYNVARS_114_02-------------------------#'
21SET @@global.old_passwords = DEFAULT;
22SELECT @@global.old_passwords = FALSE;
23@@global.old_passwords = FALSE
241
25SET @@session.old_passwords = DEFAULT;
26SELECT @@session.old_passwords = FALSE;
27@@session.old_passwords = FALSE
281
29'#--------------------FN_DYNVARS_114_03-------------------------#'
30SET @@global.old_passwords = ON;
31SELECT @@global.old_passwords;
32@@global.old_passwords
331
34SET @@global.old_passwords = OFF;
35SELECT @@global.old_passwords;
36@@global.old_passwords
370
38SET @@global.old_passwords = 0;
39SELECT @@global.old_passwords;
40@@global.old_passwords
410
42SET @@global.old_passwords = 1;
43SELECT @@global.old_passwords;
44@@global.old_passwords
451
46SET @@global.old_passwords = TRUE;
47SELECT @@global.old_passwords;
48@@global.old_passwords
491
50SET @@global.old_passwords = FALSE;
51SELECT @@global.old_passwords;
52@@global.old_passwords
530
54'#--------------------FN_DYNVARS_114_04-------------------------#'
55SET @@session.old_passwords = ON;
56SELECT @@session.old_passwords;
57@@session.old_passwords
581
59SET @@session.old_passwords = OFF;
60SELECT @@session.old_passwords;
61@@session.old_passwords
620
63SET @@session.old_passwords = 0;
64SELECT @@session.old_passwords;
65@@session.old_passwords
660
67SET @@session.old_passwords = 1;
68SELECT @@session.old_passwords;
69@@session.old_passwords
701
71SET @@session.old_passwords = TRUE;
72SELECT @@session.old_passwords;
73@@session.old_passwords
741
75SET @@session.old_passwords = FALSE;
76SELECT @@session.old_passwords;
77@@session.old_passwords
780
79'#------------------FN_DYNVARS_114_05-----------------------#'
80SET @@global.old_passwords = 'ONN';
81ERROR 42000: Variable 'old_passwords' can't be set to the value of 'ONN'
82SET @@global.old_passwords = "OFFF";
83ERROR 42000: Variable 'old_passwords' can't be set to the value of 'OFFF'
84SET @@global.old_passwords = TTRUE;
85ERROR 42000: Variable 'old_passwords' can't be set to the value of 'TTRUE'
86SET @@global.old_passwords = FELSE;
87ERROR 42000: Variable 'old_passwords' can't be set to the value of 'FELSE'
88SET @@global.old_passwords = -1024;
89ERROR 42000: Variable 'old_passwords' can't be set to the value of '-1024'
90SET @@global.old_passwords = 65536;
91ERROR 42000: Variable 'old_passwords' can't be set to the value of '65536'
92SET @@global.old_passwords = 65530.34;
93ERROR 42000: Incorrect argument type to variable 'old_passwords'
94SET @@global.old_passwords = test;
95ERROR 42000: Variable 'old_passwords' can't be set to the value of 'test'
96SET @@session.old_passwords = ONN;
97ERROR 42000: Variable 'old_passwords' can't be set to the value of 'ONN'
98SET @@session.old_passwords = ONF;
99ERROR 42000: Variable 'old_passwords' can't be set to the value of 'ONF'
100SET @@session.old_passwords = OF;
101ERROR 42000: Variable 'old_passwords' can't be set to the value of 'OF'
102SET @@session.old_passwords = 'OFN';
103ERROR 42000: Variable 'old_passwords' can't be set to the value of 'OFN'
104SET @@session.old_passwords = -2;
105ERROR 42000: Variable 'old_passwords' can't be set to the value of '-2'
106SET @@session.old_passwords = 65530.34;
107ERROR 42000: Incorrect argument type to variable 'old_passwords'
108SET @@session.old_passwords = 65550;
109ERROR 42000: Variable 'old_passwords' can't be set to the value of '65550'
110SET @@session.old_passwords = test;
111ERROR 42000: Variable 'old_passwords' can't be set to the value of 'test'
112'#------------------FN_DYNVARS_114_06-----------------------#'
113SELECT IF(@@global.old_passwords, "ON", "OFF") = VARIABLE_VALUE
114FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
115WHERE VARIABLE_NAME='old_passwords';
116IF(@@global.old_passwords, "ON", "OFF") = VARIABLE_VALUE
1171
118'#------------------FN_DYNVARS_114_07-----------------------#'
119SELECT IF(@@session.old_passwords, "ON", "OFF") = VARIABLE_VALUE
120FROM INFORMATION_SCHEMA.SESSION_VARIABLES
121WHERE VARIABLE_NAME='old_passwords';
122IF(@@session.old_passwords, "ON", "OFF") = VARIABLE_VALUE
1231
124'#---------------------FN_DYNVARS_114_08----------------------#'
125SET @@old_passwords = OFF;
126SET @@global.old_passwords = ON;
127SELECT @@old_passwords = @@global.old_passwords;
128@@old_passwords = @@global.old_passwords
1290
130'#---------------------FN_DYNVARS_114_09----------------------#'
131SET @@old_passwords = ON;
132SELECT @@old_passwords = @@local.old_passwords;
133@@old_passwords = @@local.old_passwords
1341
135SELECT @@local.old_passwords = @@session.old_passwords;
136@@local.old_passwords = @@session.old_passwords
1371
138'#---------------------FN_DYNVARS_114_10----------------------#'
139SET old_passwords = 1;
140SELECT @@old_passwords;
141@@old_passwords
1421
143SELECT local.old_passwords;
144ERROR 42S02: Unknown table 'local' in field list
145SELECT session.old_passwords;
146ERROR 42S02: Unknown table 'session' in field list
147SELECT old_passwords = @@session.old_passwords;
148ERROR 42S22: Unknown column 'old_passwords' in 'field list'
149SET @@global.old_passwords = @start_global_value;
150SELECT @@global.old_passwords;
151@@global.old_passwords
1520
153SET @@session.old_passwords = @start_session_value;
154SELECT @@session.old_passwords;
155@@session.old_passwords
1560
157