Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.slave_compressed_protocol;
2 SELECT @global_start_value;
3 @global_start_value
4 0
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
10 0
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
16 0
17 SELECT global.slave_compressed_protocol;
18 ERROR 42S02: Unknown table 'global' in SELECT
19 SET global slave_compressed_protocol = 1;
20 SELECT @@global.slave_compressed_protocol;
21 @@global.slave_compressed_protocol
22 1
23 '#--------------------FN_DYNVARS_147_03------------------------#'
24 SET @@global.slave_compressed_protocol = 0;
25 SELECT @@global.slave_compressed_protocol;
26 @@global.slave_compressed_protocol
27 0
28 SET @@global.slave_compressed_protocol = 1;
29 SELECT @@global.slave_compressed_protocol;
30 @@global.slave_compressed_protocol
31 1
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';
66 count(VARIABLE_VALUE)
67 1
68 '#----------------------FN_DYNVARS_147_07------------------------#'
69 SELECT IF(@@global.slave_compressed_protocol, "ON", "OFF") = VARIABLE_VALUE
70 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
71 WHERE VARIABLE_NAME='slave_compressed_protocol';
72 IF(@@global.slave_compressed_protocol, "ON", "OFF") = VARIABLE_VALUE
73 1
74 SELECT @@global.slave_compressed_protocol;
75 @@global.slave_compressed_protocol
76 1
77 SELECT VARIABLE_VALUE
78 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
79 WHERE VARIABLE_NAME='slave_compressed_protocol';
80 VARIABLE_VALUE
81 ON
82 '#---------------------FN_DYNVARS_147_08-------------------------#'
83 SET @@global.slave_compressed_protocol = OFF;
84 SELECT @@global.slave_compressed_protocol;
85 @@global.slave_compressed_protocol
86 0
87 SET @@global.slave_compressed_protocol = ON;
88 SELECT @@global.slave_compressed_protocol;
89 @@global.slave_compressed_protocol
90 1
91 '#---------------------FN_DYNVARS_147_09----------------------#'
92 SET @@global.slave_compressed_protocol = TRUE;
93 SELECT @@global.slave_compressed_protocol;
94 @@global.slave_compressed_protocol
95 1
96 SET @@global.slave_compressed_protocol = FALSE;
97 SELECT @@global.slave_compressed_protocol;
98 @@global.slave_compressed_protocol
99 0
100 SET @@global.slave_compressed_protocol = @global_start_value;
101 SELECT @@global.slave_compressed_protocol;
102 @@global.slave_compressed_protocol
103 0