Debian Codegraph @

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

raw
1 SET @start_value = @@global.slave_max_allowed_packet;
2 SELECT @start_value;
3 @start_value
4 1073741824
5 '#--------------------FN_DYNVARS_072_01------------------------#'
6 SET @@global.slave_max_allowed_packet = 5000;
7 Warnings:
8 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '5000'
9 SET @@global.slave_max_allowed_packet = DEFAULT;
10 SELECT @@global.slave_max_allowed_packet;
11 @@global.slave_max_allowed_packet
12 1073741824
13 '#---------------------FN_DYNVARS_072_02-------------------------#'
14 SET @@global.slave_max_allowed_packet = @start_value;
15 SELECT @@global.slave_max_allowed_packet = 1073741824;
16 @@global.slave_max_allowed_packet = 1073741824
17 1
18 'Bug# 34876: Incorrect Default Value is assigned to variable';
19 '#--------------------FN_DYNVARS_072_03------------------------#'
20 SET @@global.slave_max_allowed_packet = 1024;
21 SELECT @@global.slave_max_allowed_packet;
22 @@global.slave_max_allowed_packet
23 1024
24 SET @@global.slave_max_allowed_packet = 1073741824;
25 SELECT @@global.slave_max_allowed_packet;
26 @@global.slave_max_allowed_packet
27 1073741824
28 SET @@global.slave_max_allowed_packet = 1073741824;
29 SELECT @@global.slave_max_allowed_packet;
30 @@global.slave_max_allowed_packet
31 1073741824
32 SET @@global.slave_max_allowed_packet = 1025;
33 Warnings:
34 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '1025'
35 SELECT @@global.slave_max_allowed_packet;
36 @@global.slave_max_allowed_packet
37 1024
38 SET @@global.slave_max_allowed_packet = 65535;
39 Warnings:
40 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '65535'
41 SELECT @@global.slave_max_allowed_packet;
42 @@global.slave_max_allowed_packet
43 64512
44 'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
45 '#--------------------FN_DYNVARS_072_04-------------------------#'
46 SET @@global.slave_max_allowed_packet = -1;
47 Warnings:
48 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '-1'
49 SELECT @@global.slave_max_allowed_packet;
50 @@global.slave_max_allowed_packet
51 1024
52 SET @@global.slave_max_allowed_packet = 100000000000;
53 Warnings:
54 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '100000000000'
55 SELECT @@global.slave_max_allowed_packet;
56 @@global.slave_max_allowed_packet
57 1073741824
58 SET @@global.slave_max_allowed_packet = 10000.01;
59 ERROR 42000: Incorrect argument type to variable 'slave_max_allowed_packet'
60 SELECT @@global.slave_max_allowed_packet;
61 @@global.slave_max_allowed_packet
62 1073741824
63 SET @@global.slave_max_allowed_packet = -1024;
64 Warnings:
65 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '-1024'
66 SELECT @@global.slave_max_allowed_packet;
67 @@global.slave_max_allowed_packet
68 1024
69 SET @@global.slave_max_allowed_packet = 4294967296;
70 Warnings:
71 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '4294967296'
72 SELECT @@global.slave_max_allowed_packet;
73 @@global.slave_max_allowed_packet
74 1073741824
75 SET @@global.slave_max_allowed_packet = 1023;
76 Warnings:
77 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '1023'
78 SELECT @@global.slave_max_allowed_packet;
79 @@global.slave_max_allowed_packet
80 1024
81 'Bug # 34837: Errors are not coming on assigning invalid values to variable';
82 SET @@global.slave_max_allowed_packet = ON;
83 ERROR 42000: Incorrect argument type to variable 'slave_max_allowed_packet'
84 SELECT @@global.slave_max_allowed_packet;
85 @@global.slave_max_allowed_packet
86 1024
87 SET @@global.slave_max_allowed_packet = 'test';
88 ERROR 42000: Incorrect argument type to variable 'slave_max_allowed_packet'
89 SELECT @@global.slave_max_allowed_packet;
90 @@global.slave_max_allowed_packet
91 1024
92 '#-------------------FN_DYNVARS_072_05----------------------------#'
93 SET @@session.slave_max_allowed_packet = 4096;
94 ERROR HY000: Variable 'slave_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
95 SELECT @@session.slave_max_allowed_packet;
96 ERROR HY000: Variable 'slave_max_allowed_packet' is a GLOBAL variable
97 '#----------------------FN_DYNVARS_072_06------------------------#'
98 SELECT @@global.slave_max_allowed_packet = VARIABLE_VALUE
99 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
100 WHERE VARIABLE_NAME='slave_max_allowed_packet';
101 @@global.slave_max_allowed_packet = VARIABLE_VALUE
102 1
103 SELECT @@slave_max_allowed_packet = VARIABLE_VALUE
104 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
105 WHERE VARIABLE_NAME='slave_max_allowed_packet';
106 @@slave_max_allowed_packet = VARIABLE_VALUE
107 1
108 '#---------------------FN_DYNVARS_072_07----------------------#'
109 SET @@global.slave_max_allowed_packet = TRUE;
110 Warnings:
111 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '1'
112 SELECT @@global.slave_max_allowed_packet;
113 @@global.slave_max_allowed_packet
114 1024
115 SET @@global.slave_max_allowed_packet = FALSE;
116 Warnings:
117 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '0'
118 SELECT @@global.slave_max_allowed_packet;
119 @@global.slave_max_allowed_packet
120 1024
121 '#---------------------FN_DYNVARS_072_08----------------------#'
122 SET @@global.slave_max_allowed_packet = 5000;
123 Warnings:
124 Warning 1292 Truncated incorrect slave_max_allowed_packet value: '5000'
125 SELECT @@slave_max_allowed_packet = @@global.slave_max_allowed_packet;
126 @@slave_max_allowed_packet = @@global.slave_max_allowed_packet
127 1
128 '#---------------------FN_DYNVARS_072_09----------------------#'
129 SET slave_max_allowed_packet = 6000;
130 ERROR HY000: Variable 'slave_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
131 SELECT @@slave_max_allowed_packet;
132 @@slave_max_allowed_packet
133 4096
134 SELECT local.slave_max_allowed_packet;
135 ERROR 42S02: Unknown table 'local' in SELECT
136 SELECT global.slave_max_allowed_packet;
137 ERROR 42S02: Unknown table 'global' in SELECT
138 SELECT slave_max_allowed_packet = @@session.slave_max_allowed_packet;
139 ERROR 42S22: Unknown column 'slave_max_allowed_packet' in 'SELECT'
140 SET @@global.slave_max_allowed_packet = @start_value;
141 SELECT @@global.slave_max_allowed_packet;
142 @@global.slave_max_allowed_packet
143 1073741824