1
SET @global_start_value = @@global.slave_compressed_protocol;
2
SELECT @global_start_value;
5
'#--------------------FN_DYNVARS_147_01------------------------#'
6
SET @@global.slave_compressed_protocol = 1;
7
SET @@global.slave_compressed_protocol = DEFAULT;
8
SELECT @@global.slave_compressed_protocol;
9
@@global.slave_compressed_protocol
11
'#---------------------FN_DYNVARS_147_02-------------------------#'
12
SET slave_compressed_protocol = 1;
13
ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable and should be set with SET GLOBAL
14
SELECT @@slave_compressed_protocol;
15
@@slave_compressed_protocol
17
SELECT global.slave_compressed_protocol;
18
ERROR 42S02: Unknown table 'global' in field list
19
SET global slave_compressed_protocol = 1;
20
SELECT @@global.slave_compressed_protocol;
21
@@global.slave_compressed_protocol
23
'#--------------------FN_DYNVARS_147_03------------------------#'
24
SET @@global.slave_compressed_protocol = 0;
25
SELECT @@global.slave_compressed_protocol;
26
@@global.slave_compressed_protocol
28
SET @@global.slave_compressed_protocol = 1;
29
SELECT @@global.slave_compressed_protocol;
30
@@global.slave_compressed_protocol
32
'#--------------------FN_DYNVARS_147_04-------------------------#'
33
SET @@global.slave_compressed_protocol = -1;
34
ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of '-1'
35
SET @@global.slave_compressed_protocol = 2;
36
ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of '2'
37
SET @@global.slave_compressed_protocol = "1.00";
38
ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of '1.00'
39
SET @@global.slave_compressed_protocol = "Y";
40
ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of 'Y'
41
SET @@global.slave_compressed_protocol = YES;
42
ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of 'YES'
43
SET @@global.slave_compressed_protocol = ONN;
44
ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of 'ONN'
45
SET @@global.slave_compressed_protocol = 0FF;
46
ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of '0FF'
47
SET @@global.slave_compressed_protocol = ' 1';
48
ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of ' 1'
49
SET @@global.slave_compressed_protocol = NO;
50
ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of 'NO'
51
'#-------------------FN_DYNVARS_147_05----------------------------#'
52
SET @@session.slave_compressed_protocol = 0;
53
ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable and should be set with SET GLOBAL
54
SET @@slave_compressed_protocol = 0;
55
ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable and should be set with SET GLOBAL
56
SET @@local.slave_compressed_protocol = 0;
57
ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable and should be set with SET GLOBAL
58
SELECT @@session.slave_compressed_protocol;
59
ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable
60
SELECT @@local.slave_compressed_protocol;
61
ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable
62
'#----------------------FN_DYNVARS_147_06------------------------#'
63
SELECT count(VARIABLE_VALUE)
64
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
65
WHERE VARIABLE_NAME='slave_compressed_protocol';
68
'#----------------------FN_DYNVARS_147_07------------------------#'
69
SELECT @@global.slave_compressed_protocol = VARIABLE_VALUE
70
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
71
WHERE VARIABLE_NAME='slave_compressed_protocol';
72
@@global.slave_compressed_protocol = VARIABLE_VALUE
74
SELECT @@global.slave_compressed_protocol;
75
@@global.slave_compressed_protocol
78
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
79
WHERE VARIABLE_NAME='slave_compressed_protocol';
82
'#---------------------FN_DYNVARS_147_08-------------------------#'
83
SET @@global.slave_compressed_protocol = OFF;
84
SELECT @@global.slave_compressed_protocol;
85
@@global.slave_compressed_protocol
87
SET @@global.slave_compressed_protocol = ON;
88
SELECT @@global.slave_compressed_protocol;
89
@@global.slave_compressed_protocol
91
'#---------------------FN_DYNVARS_147_09----------------------#'
92
SET @@global.slave_compressed_protocol = TRUE;
93
SELECT @@global.slave_compressed_protocol;
94
@@global.slave_compressed_protocol
96
SET @@global.slave_compressed_protocol = FALSE;
97
SELECT @@global.slave_compressed_protocol;
98
@@global.slave_compressed_protocol
100
SET @@global.slave_compressed_protocol = @global_start_value;
101
SELECT @@global.slave_compressed_protocol;
102
@@global.slave_compressed_protocol