MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
transaction_alloc_block_size_basic.inc
1 ############## mysql-test\t\transaction_alloc_block_size_basic.test ###########
2 # #
3 # Variable Name: transaction_alloc_block_size #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: numeric #
7 # Default Value: 8192 #
8 # Range: 1024-4294967295 #
9 # #
10 # #
11 # Creation Date: 2008-02-14 #
12 # Author: Salman #
13 # #
14 # Description: Test Cases of Dynamic System Variable #
15 # transaction_alloc_block_size #
16 # that checks the behavior of this variable in the following ways#
17 # * Default Value #
18 # * Valid & Invalid values #
19 # * Scope & Access method #
20 # * Data Integrity #
21 # #
22 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
23 # server-system-variables.html #
24 # #
25 ###############################################################################
26 
27 --source include/load_sysvars.inc
28 
29 ########################################################################
30 # START OF transaction_alloc_block_size TESTS #
31 ########################################################################
32 
33 
34 #############################################################
35 # Save initial value #
36 #############################################################
37 
38 SET @start_global_value = @@global.transaction_alloc_block_size;
39 SELECT @start_global_value;
40 SET @start_session_value = @@session.transaction_alloc_block_size;
41 SELECT @start_session_value;
42 
43 
44 --echo '#--------------------FN_DYNVARS_005_01-------------------------#'
45 ########################################################################
46 # Display the DEFAULT value of transaction_alloc_block_size #
47 ########################################################################
48 
49 SET @@global.transaction_alloc_block_size = 100;
50 SET @@global.transaction_alloc_block_size = DEFAULT;
51 SELECT @@global.transaction_alloc_block_size;
52 
53 
54 SET @@session.transaction_alloc_block_size = 200;
55 SET @@session.transaction_alloc_block_size = DEFAULT;
56 SELECT @@session.transaction_alloc_block_size;
57 
58 
59 
60 --echo '#--------------------FN_DYNVARS_005_02-------------------------#'
61 ########################################################################
62 # Check the DEFAULT value of transaction_alloc_block_size #
63 ########################################################################
64 
65 SET @@global.transaction_alloc_block_size = DEFAULT;
66 SELECT @@global.transaction_alloc_block_size = 8192;
67 
68 SET @@session.transaction_alloc_block_size = DEFAULT;
69 SELECT @@session.transaction_alloc_block_size = 8192;
70 
71 
72 --echo '#--------------------FN_DYNVARS_005_03-------------------------#'
73 ##################################################################
74 # Change the value of variable to a valid value for GLOBAL Scope #
75 ##################################################################
76 
77 SET @@global.transaction_alloc_block_size = 1024;
78 SELECT @@global.transaction_alloc_block_size;
79 
80 SET @@global.transaction_alloc_block_size = 60020;
81 SELECT @@global.transaction_alloc_block_size;
82 
83 SET @@global.transaction_alloc_block_size = 4294967295;
84 SELECT @@global.transaction_alloc_block_size;
85 
86 --echo '#--------------------FN_DYNVARS_005_04-------------------------#'
87 ###################################################################
88 # Change the value of variable to a valid value for SESSION Scope #
89 ###################################################################
90 
91 SET @@session.transaction_alloc_block_size = 1024;
92 SELECT @@session.transaction_alloc_block_size;
93 
94 SET @@session.transaction_alloc_block_size =4294967295;
95 SELECT @@session.transaction_alloc_block_size;
96 
97 SET @@session.transaction_alloc_block_size = 65535;
98 SELECT @@session.transaction_alloc_block_size;
99 
100 
101 --echo '#------------------FN_DYNVARS_005_05-----------------------#'
102 ########################################################################
103 # Change the value of transaction_alloc_block_size to an invalid value #
104 ########################################################################
105 
106 SET @@global.transaction_alloc_block_size = 0;
107 SELECT @@global.transaction_alloc_block_size;
108 
109 SET @@global.transaction_alloc_block_size = -1024;
110 SELECT @@global.transaction_alloc_block_size;
111 
112 
113 SET @@global.transaction_alloc_block_size = 123456789201;
114 SELECT @@global.transaction_alloc_block_size;
115 
116 -- Error ER_WRONG_TYPE_FOR_VAR
117 SET @@global.transaction_alloc_block_size = ON;
118 
119 -- Error ER_WRONG_TYPE_FOR_VAR
120 SET @@global.transaction_alloc_block_size = OFF;
121 
122 
123 SET @@global.transaction_alloc_block_size = True;
124 SELECT @@global.transaction_alloc_block_size;
125 
126 SET @@global.transaction_alloc_block_size = False;
127 SELECT @@global.transaction_alloc_block_size;
128 
129 
130 -- Error ER_WRONG_TYPE_FOR_VAR
131 SET @@global.transaction_alloc_block_size = 65530.34;
132 
133 -- Error ER_WRONG_TYPE_FOR_VAR
134 SET @@global.transaction_alloc_block_size ="Test";
135 
136 SET @@global.transaction_alloc_block_size = 1000;
137 SELECT @@global.transaction_alloc_block_size;
138 
139 SET @@session.transaction_alloc_block_size = 12345678901;
140 SELECT @@session.transaction_alloc_block_size;
141 
142 -- Error ER_WRONG_TYPE_FOR_VAR
143 SET @@session.transaction_alloc_block_size = ON;
144 
145 -- Error ER_WRONG_TYPE_FOR_VAR
146 SET @@session.transaction_alloc_block_size = OFF;
147 
148 SET @@session.transaction_alloc_block_size = True;
149 SELECT @@session.transaction_alloc_block_size;
150 
151 SET @@session.transaction_alloc_block_size = False;
152 SELECT @@session.transaction_alloc_block_size;
153 
154 
155 -- Error ER_WRONG_TYPE_FOR_VAR
156 SET @@session.transaction_alloc_block_size = "Test";
157 
158 
159 --Error ER_WRONG_TYPE_FOR_VAR
160 SET @@session.transaction_alloc_block_size = 'test';
161 
162 --echo '#------------------FN_DYNVARS_005_06-----------------------#'
163 ####################################################################
164 # Check if the value in GLOBAL Table matches value in variable #
165 ####################################################################
166 
167 
168 SELECT @@global.transaction_alloc_block_size = VARIABLE_VALUE
169 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
170 WHERE VARIABLE_NAME='transaction_alloc_block_size';
171 
172 --echo '#------------------FN_DYNVARS_005_07-----------------------#'
173 ####################################################################
174 # Check if the value in SESSION Table matches value in variable #
175 ####################################################################
176 
177 SELECT @@session.transaction_alloc_block_size = VARIABLE_VALUE
178 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
179 WHERE VARIABLE_NAME='transaction_alloc_block_size';
180 
181 
182 --echo '#---------------------FN_DYNVARS_001_08----------------------#'
183 ###########################################################################
184 # Check if global and session variable are independent of each other #
185 ###########################################################################
186 
187 SET @@transaction_alloc_block_size = 1024;
188 SET @@global.transaction_alloc_block_size = 4294967295;
189 SELECT @@transaction_alloc_block_size = @@global.transaction_alloc_block_size;
190 
191 
192 --echo '#---------------------FN_DYNVARS_001_09----------------------#'
193 ########################################################################
194 # Check if accessing variable with SESSION,LOCAL and without SCOPE #
195 # points to same session variable #
196 ########################################################################
197 
198 SET @@transaction_alloc_block_size = 100;
199 SELECT @@transaction_alloc_block_size = @@local.transaction_alloc_block_size;
200 SELECT @@local.transaction_alloc_block_size = @@session.transaction_alloc_block_size;
201 
202 
203 --echo '#---------------------FN_DYNVARS_001_10----------------------#'
204 ################################################################
205 # Check if variable can be accessed with and without @@ sign #
206 ################################################################
207 
208 SET transaction_alloc_block_size = 1027;
209 SELECT @@transaction_alloc_block_size;
210 
211 --Error ER_UNKNOWN_TABLE
212 SELECT local.transaction_alloc_block_size;
213 
214 --Error ER_UNKNOWN_TABLE
215 SELECT session.transaction_alloc_block_size;
216 
217 --Error ER_BAD_FIELD_ERROR
218 SELECT transaction_alloc_block_size = @@session.transaction_alloc_block_size;
219 
220 
221 ####################################
222 # Restore initial value #
223 ####################################
224 
225 SET @@global.transaction_alloc_block_size = @start_global_value;
226 SELECT @@global.transaction_alloc_block_size;
227 SET @@session.tmp_table_size = @start_session_value;
228 SELECT @@session.transaction_alloc_block_size;
229 
230 
231 #############################################################
232 # END OF transaction_alloc_block_size TESTS #
233 #############################################################
234