1
SET @start_global_value = @@global.old_passwords;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.old_passwords;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_114_01-------------------------#'
10
SET @@global.old_passwords = 1;
11
SET @@global.old_passwords = DEFAULT;
12
SELECT @@global.old_passwords;
13
@@global.old_passwords
15
SET @@session.old_passwords = 1;
16
SET @@session.old_passwords = DEFAULT;
17
SELECT @@session.old_passwords;
18
@@session.old_passwords
20
'#--------------------FN_DYNVARS_114_02-------------------------#'
21
SET @@global.old_passwords = DEFAULT;
22
SELECT @@global.old_passwords = FALSE;
23
@@global.old_passwords = FALSE
25
SET @@session.old_passwords = DEFAULT;
26
SELECT @@session.old_passwords = FALSE;
27
@@session.old_passwords = FALSE
29
'#--------------------FN_DYNVARS_114_03-------------------------#'
30
SET @@global.old_passwords = 0;
31
SELECT @@global.old_passwords;
32
@@global.old_passwords
34
SET @@global.old_passwords = 1;
35
SELECT @@global.old_passwords;
36
@@global.old_passwords
38
'#--------------------FN_DYNVARS_114_04-------------------------#'
39
SELECT @@session.old_passwords;
40
@@session.old_passwords
42
SET @@session.old_passwords = 0;
43
SELECT @@session.old_passwords;
44
@@session.old_passwords
46
SET @@session.old_passwords = 1;
47
SELECT @@session.old_passwords;
48
@@session.old_passwords
50
'#------------------FN_DYNVARS_114_05-----------------------#'
51
SET @@global.old_passwords = -1024;
53
Warning 1292 Truncated incorrect old_passwords value: '-1024'
54
SELECT @@global.old_passwords;
55
@@global.old_passwords
57
SET @@global.old_passwords = 65536;
59
Warning 1292 Truncated incorrect old_passwords value: '65536'
60
SELECT @@global.old_passwords;
61
@@global.old_passwords
63
SET @@global.old_passwords = 65530.34;
64
ERROR 42000: Incorrect argument type to variable 'old_passwords'
65
SELECT @@global.old_passwords;
66
@@global.old_passwords
68
SET @@session.old_passwords = test;
69
ERROR 42000: Incorrect argument type to variable 'old_passwords'
70
'#------------------FN_DYNVARS_114_06-----------------------#'
71
SELECT IF(@@global.old_passwords, "1", "0") = VARIABLE_VALUE
72
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
73
WHERE VARIABLE_NAME='old_passwords';
74
IF(@@global.old_passwords, "1", "0") = VARIABLE_VALUE
76
'#------------------FN_DYNVARS_114_07-----------------------#'
77
SELECT IF(@@session.old_passwords, "1", "0") = VARIABLE_VALUE
78
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
79
WHERE VARIABLE_NAME='old_passwords';
80
IF(@@session.old_passwords, "1", "0") = VARIABLE_VALUE
82
'#---------------------FN_DYNVARS_114_08----------------------#'
83
SET @@old_passwords = 0;
84
SET @@global.old_passwords = 1;
85
SELECT @@old_passwords = @@global.old_passwords;
86
@@old_passwords = @@global.old_passwords
88
'#---------------------FN_DYNVARS_114_09----------------------#'
89
SET @@old_passwords = 1;
90
SELECT @@old_passwords = @@local.old_passwords;
91
@@old_passwords = @@local.old_passwords
93
SELECT @@local.old_passwords = @@session.old_passwords;
94
@@local.old_passwords = @@session.old_passwords
96
'#---------------------FN_DYNVARS_114_10----------------------#'
97
SET old_passwords = 1;
98
SELECT @@old_passwords;
101
SELECT local.old_passwords;
102
ERROR 42S02: Unknown table 'local' in field list
103
SELECT session.old_passwords;
104
ERROR 42S02: Unknown table 'session' in field list
105
SELECT old_passwords = @@session.old_passwords;
106
ERROR 42S22: Unknown column 'old_passwords' in 'field list'
107
SET @@global.old_passwords = @start_global_value;
108
SELECT @@global.old_passwords;
109
@@global.old_passwords
111
SET @@session.old_passwords = @start_session_value;
112
SELECT @@session.old_passwords;
113
@@session.old_passwords