1
SET @global_start_value = @@global.secure_auth;
2
SELECT @global_start_value;
5
'#--------------------FN_DYNVARS_143_01------------------------#'
6
SET @@global.secure_auth = 1;
7
SET @@global.secure_auth = DEFAULT;
8
SELECT @@global.secure_auth;
11
'#---------------------FN_DYNVARS_143_02-------------------------#'
13
ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL
17
SELECT global.secure_auth;
18
ERROR 42S02: Unknown table 'global' in field list
19
SET global secure_auth = 1;
20
SELECT @@global.secure_auth;
23
'#--------------------FN_DYNVARS_143_03------------------------#'
24
SET @@global.secure_auth = 0;
25
SELECT @@global.secure_auth;
28
SET @@global.secure_auth = 1;
29
SELECT @@global.secure_auth;
32
'#--------------------FN_DYNVARS_143_04-------------------------#'
33
SET @@global.secure_auth = -1;
34
ERROR 42000: Variable 'secure_auth' can't be set to the value of '-1'
35
SET @@global.secure_auth = 2;
36
ERROR 42000: Variable 'secure_auth' can't be set to the value of '2'
37
SET @@global.secure_auth = "T";
38
ERROR 42000: Variable 'secure_auth' can't be set to the value of 'T'
39
SET @@global.secure_auth = "Y";
40
ERROR 42000: Variable 'secure_auth' can't be set to the value of 'Y'
41
SET @@global.secure_auth = YES;
42
ERROR 42000: Variable 'secure_auth' can't be set to the value of 'YES'
43
SET @@global.secure_auth = ONN;
44
ERROR 42000: Variable 'secure_auth' can't be set to the value of 'ONN'
45
SET @@global.secure_auth = OOF;
46
ERROR 42000: Variable 'secure_auth' can't be set to the value of 'OOF'
47
SET @@global.secure_auth = 0FF;
48
ERROR 42000: Variable 'secure_auth' can't be set to the value of '0FF'
49
SET @@global.secure_auth = ' 1';
50
ERROR 42000: Variable 'secure_auth' can't be set to the value of ' 1'
51
SET @@global.secure_auth = NO;
52
ERROR 42000: Variable 'secure_auth' can't be set to the value of 'NO'
53
'#-------------------FN_DYNVARS_143_05----------------------------#'
54
SET @@session.secure_auth = 0;
55
ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL
56
SET @@secure_auth = 0;
57
ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL
58
SET @@local.secure_auth = 0;
59
ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL
60
SELECT @@session.secure_auth;
61
ERROR HY000: Variable 'secure_auth' is a GLOBAL variable
62
SELECT @@local.secure_auth;
63
ERROR HY000: Variable 'secure_auth' is a GLOBAL variable
64
'#----------------------FN_DYNVARS_143_06------------------------#'
65
SELECT count(VARIABLE_VALUE)
66
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
67
WHERE VARIABLE_NAME='secure_auth';
70
'#----------------------FN_DYNVARS_143_07------------------------#'
71
SELECT @@global.secure_auth = VARIABLE_VALUE
72
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
73
WHERE VARIABLE_NAME='secure_auth';
74
@@global.secure_auth = VARIABLE_VALUE
76
SELECT @@global.secure_auth;
80
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
81
WHERE VARIABLE_NAME='secure_auth';
84
'#---------------------FN_DYNVARS_143_08-------------------------#'
85
SET @@global.secure_auth = OFF;
86
SELECT @@global.secure_auth;
89
SET @@global.secure_auth = ON;
90
SELECT @@global.secure_auth;
93
'#---------------------FN_DYNVARS_143_09----------------------#'
94
SET @@global.secure_auth = TRUE;
95
SELECT @@global.secure_auth;
98
SET @@global.secure_auth = FALSE;
99
SELECT @@global.secure_auth;
102
SET @@global.secure_auth = @global_start_value;
103
SELECT @@global.secure_auth;