Debian Codegraph @

mysql-test/suite/sys_vars/t/slave_max_allowed_packet_basic.test

raw
1 ############## mysql-test\t\slave_max_allowed_packet_basic.test ##################
2 # #
3 # Variable Name: slave_max_allowed_packet #
4 # Scope: GLOBAL #
5 # Access Type: Dynamic #
6 # Data Type: numeric #
7 # Default Value:1073741824 #
8 # Range: 1024 - 1073741824 #
9 # #
10 # #
11 # #
12 # Description: Test Cases of Dynamic System Variable slave_max_allowed_packet #
13 # that checks the behavior of this variable in the following ways#
14 # * Default Value #
15 # * Valid & Invalid values #
16 # * Scope & Access method #
17 # * Data Integrity #
18 # #
19 ###############################################################################
20
21 --source include/load_sysvars.inc
22
23 ########################################################################
24 # START OF slave_max_allowed_packet TESTS #
25 ########################################################################
26
27
28 ###########################################################################
29 # Saving initial value of slave_max_allowed_packet in a temporary variable#
30 ###########################################################################
31
32 SET @start_value = @@global.slave_max_allowed_packet;
33 SELECT @start_value;
34
35
36 --echo '#--------------------FN_DYNVARS_072_01------------------------#'
37 ########################################################################
38 # Display the DEFAULT value of slave_max_allowed_packet #
39 ########################################################################
40
41 SET @@global.slave_max_allowed_packet = 5000;
42 SET @@global.slave_max_allowed_packet = DEFAULT;
43 SELECT @@global.slave_max_allowed_packet;
44
45
46 --echo '#---------------------FN_DYNVARS_072_02-------------------------#'
47 ###############################################
48 # Verify default value of variable #
49 ###############################################
50
51 SET @@global.slave_max_allowed_packet = @start_value;
52 SELECT @@global.slave_max_allowed_packet = 1073741824;
53 --echo 'Bug# 34876: Incorrect Default Value is assigned to variable';
54
55 --echo '#--------------------FN_DYNVARS_072_03------------------------#'
56 ########################################################################
57 # Change the value of slave_max_allowed_packet to a valid value #
58 ########################################################################
59
60 SET @@global.slave_max_allowed_packet = 1024;
61 SELECT @@global.slave_max_allowed_packet;
62 SET @@global.slave_max_allowed_packet = 1073741824;
63 SELECT @@global.slave_max_allowed_packet;
64 SET @@global.slave_max_allowed_packet = 1073741824;
65 SELECT @@global.slave_max_allowed_packet;
66 SET @@global.slave_max_allowed_packet = 1025;
67 SELECT @@global.slave_max_allowed_packet;
68 SET @@global.slave_max_allowed_packet = 65535;
69 SELECT @@global.slave_max_allowed_packet;
70 --echo 'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
71
72
73 --echo '#--------------------FN_DYNVARS_072_04-------------------------#'
74 ###########################################################################
75 # Change the value of slave_max_allowed_packet to invalid value #
76 ###########################################################################
77
78 SET @@global.slave_max_allowed_packet = -1;
79 SELECT @@global.slave_max_allowed_packet;
80 SET @@global.slave_max_allowed_packet = 100000000000;
81 SELECT @@global.slave_max_allowed_packet;
82 --Error ER_WRONG_TYPE_FOR_VAR
83 SET @@global.slave_max_allowed_packet = 10000.01;
84 SELECT @@global.slave_max_allowed_packet;
85 SET @@global.slave_max_allowed_packet = -1024;
86 SELECT @@global.slave_max_allowed_packet;
87 SET @@global.slave_max_allowed_packet = 4294967296;
88 SELECT @@global.slave_max_allowed_packet;
89 SET @@global.slave_max_allowed_packet = 1023;
90 SELECT @@global.slave_max_allowed_packet;
91
92 --echo 'Bug # 34837: Errors are not coming on assigning invalid values to variable';
93
94 --Error ER_WRONG_TYPE_FOR_VAR
95 SET @@global.slave_max_allowed_packet = ON;
96 SELECT @@global.slave_max_allowed_packet;
97 --Error ER_WRONG_TYPE_FOR_VAR
98 SET @@global.slave_max_allowed_packet = 'test';
99 SELECT @@global.slave_max_allowed_packet;
100
101
102 --echo '#-------------------FN_DYNVARS_072_05----------------------------#'
103 ###########################################################################
104 # Test if accessing session slave_max_allowed_packet gives error #
105 ###########################################################################
106
107 --Error ER_GLOBAL_VARIABLE
108 SET @@session.slave_max_allowed_packet = 4096;
109 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
110 SELECT @@session.slave_max_allowed_packet;
111
112
113 --echo '#----------------------FN_DYNVARS_072_06------------------------#'
114 ##############################################################################
115 # Check if the value in GLOBAL & SESSION Tables matches values in variable #
116 ##############################################################################
117
118 SELECT @@global.slave_max_allowed_packet = VARIABLE_VALUE
119 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
120 WHERE VARIABLE_NAME='slave_max_allowed_packet';
121
122 SELECT @@slave_max_allowed_packet = VARIABLE_VALUE
123 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
124 WHERE VARIABLE_NAME='slave_max_allowed_packet';
125
126
127 --echo '#---------------------FN_DYNVARS_072_07----------------------#'
128 ###################################################################
129 # Check if TRUE and FALSE values can be used on variable #
130 ###################################################################
131
132 SET @@global.slave_max_allowed_packet = TRUE;
133 SELECT @@global.slave_max_allowed_packet;
134 SET @@global.slave_max_allowed_packet = FALSE;
135 SELECT @@global.slave_max_allowed_packet;
136
137
138 --echo '#---------------------FN_DYNVARS_072_08----------------------#'
139 ########################################################################################################
140 # Check if accessing variable with SESSION,LOCAL and without SCOPE points to same session variable #
141 ########################################################################################################
142
143 SET @@global.slave_max_allowed_packet = 5000;
144 SELECT @@slave_max_allowed_packet = @@global.slave_max_allowed_packet;
145
146
147 --echo '#---------------------FN_DYNVARS_072_09----------------------#'
148 ################################################################################
149 # Check if slave_max_allowed_packet can be accessed with and without @@ sign #
150 ################################################################################
151
152 --Error ER_GLOBAL_VARIABLE
153 SET slave_max_allowed_packet = 6000;
154 SELECT @@slave_max_allowed_packet;
155 --Error ER_UNKNOWN_TABLE
156 SELECT local.slave_max_allowed_packet;
157 --Error ER_UNKNOWN_TABLE
158 SELECT global.slave_max_allowed_packet;
159 --Error ER_BAD_FIELD_ERROR
160 SELECT slave_max_allowed_packet = @@session.slave_max_allowed_packet;
161
162
163 ##############################
164 # Restore initial value #
165 ##############################
166
167 SET @@global.slave_max_allowed_packet = @start_value;
168 SELECT @@global.slave_max_allowed_packet;
169
170
171 ########################################################################
172 # END OF slave_max_allowed_packet TESTS #
173 ########################################################################