Debian Codegraph @

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

raw
1 --source include/load_sysvars.inc
2
3 #####################################################################
4 # START OF select_into_buffer_size TESTS #
5 #####################################################################
6
7 #############################################################
8 # Save initial value #
9 #############################################################
10
11 SET @start_global_value = @@global.select_into_buffer_size;
12 SELECT @start_global_value;
13 SET @start_session_value = @@session.select_into_buffer_size;
14 SELECT @start_session_value;
15
16
17 --echo '#--------------------FN_DYNVARS_002_01-------------------------#'
18 #####################################################################
19 # Display the DEFAULT value of select_into_buffer_size #
20 #####################################################################
21
22 SET @@global.select_into_buffer_size = 1024;
23 SET @@global.select_into_buffer_size = DEFAULT;
24 SELECT @@global.select_into_buffer_size;
25
26 SET @@session.select_into_buffer_size = 2048;
27 SET @@session.select_into_buffer_size = DEFAULT;
28 SELECT @@session.select_into_buffer_size;
29
30
31 --echo '#--------------------FN_DYNVARS_002_02-------------------------#'
32 #####################################################################
33 # Check the DEFAULT value of select_into_buffer_size #
34 #####################################################################
35
36 SET @@global.select_into_buffer_size = @start_global_value;
37 SELECT @@global.select_into_buffer_size = 4096;
38 SET @@session.select_into_buffer_size = @start_session_value;
39 SELECT @@session.select_into_buffer_size = 2048;
40
41
42 --echo '#--------------------FN_DYNVARS_002_03-------------------------#'
43 ###############################################################################
44 # Change the value of select_into_buffer_size to a valid value for GLOBAL Scope #
45 ###############################################################################
46
47 SET @@global.select_into_buffer_size = 16384;
48 SELECT @@global.select_into_buffer_size;
49 SET @@global.select_into_buffer_size = 4096;
50 SELECT @@global.select_into_buffer_size;
51 SET @@global.select_into_buffer_size = 8192;
52 SELECT @@global.select_into_buffer_size;
53
54
55 --echo '#--------------------FN_DYNVARS_002_04-------------------------#'
56 ###############################################################################
57 # Change the value of select_into_buffer_size to a valid value for SESSION Scope#
58 ###############################################################################
59
60 SET @@session.select_into_buffer_size = 4096;
61 SELECT @@session.select_into_buffer_size;
62 SET @@session.select_into_buffer_size = 8192;
63 SELECT @@session.select_into_buffer_size;
64 SET @@session.select_into_buffer_size = 16384;
65 SELECT @@session.select_into_buffer_size;
66
67
68 --echo '#------------------FN_DYNVARS_002_05-----------------------#'
69 #################################################################
70 # Change the value of select_into_buffer_size to an invalid value #
71 #################################################################
72 # for global scope
73 SET @@global.select_into_buffer_size = -1;
74 SELECT @@global.select_into_buffer_size;
75 SET @@global.select_into_buffer_size = -1024;
76 SELECT @@global.select_into_buffer_size;
77 SET @@global.select_into_buffer_size = 13;
78 SELECT @@global.select_into_buffer_size;
79 --Error ER_WRONG_TYPE_FOR_VAR
80 SET @@global.select_into_buffer_size = ON;
81 SELECT @@global.select_into_buffer_size;
82 --Error ER_WRONG_TYPE_FOR_VAR
83 SET @@global.select_into_buffer_size = OFF;
84 SELECT @@global.select_into_buffer_size;
85 --Error ER_WRONG_TYPE_FOR_VAR
86 SET @@global.select_into_buffer_size = test;
87 SELECT @@global.select_into_buffer_size;
88 # for session scope
89 SET @@session.select_into_buffer_size = 23;
90 SELECT @@session.select_into_buffer_size;
91 SET @@session.select_into_buffer_size = -2;
92 SELECT @@session.select_into_buffer_size;
93 SET @@session.select_into_buffer_size = 65550;
94 SELECT @@session.select_into_buffer_size;
95
96 --Error ER_WRONG_TYPE_FOR_VAR
97 SET @@session.select_into_buffer_size = ON;
98 SELECT @@session.select_into_buffer_size;
99 --Error ER_WRONG_TYPE_FOR_VAR
100 SET @@session.select_into_buffer_size = OFF;
101 SELECT @@session.select_into_buffer_size;
102 --Error ER_WRONG_TYPE_FOR_VAR
103 SET @@session.select_into_buffer_size = test;
104 SELECT @@session.select_into_buffer_size;
105
106
107
108 --echo '#------------------FN_DYNVARS_002_06-----------------------#'
109 ####################################################################
110 # Check if the value in GLOBAL Table matches value in variable #
111 ####################################################################
112
113 SELECT @@global.select_into_buffer_size = VARIABLE_VALUE
114 FROM performance_schema.global_variables
115 WHERE VARIABLE_NAME='select_into_buffer_size';
116
117
118 --echo '#------------------FN_DYNVARS_002_07-----------------------#'
119 ####################################################################
120 # Check if the value in SESSION Table matches value in variable #
121 ####################################################################
122
123 SELECT @@session.select_into_buffer_size = VARIABLE_VALUE
124 FROM performance_schema.session_variables
125 WHERE VARIABLE_NAME='select_into_buffer_size';
126
127
128 --echo '#------------------FN_DYNVARS_002_08-----------------------#'
129 ####################################################################
130 # Check if TRUE and FALSE values can be used on variable #
131 ####################################################################
132
133 SET @@global.select_into_buffer_size = TRUE;
134 SELECT @@global.select_into_buffer_size;
135 SET @@global.select_into_buffer_size = FALSE;
136 SELECT @@global.select_into_buffer_size;
137
138
139 --echo '#---------------------FN_DYNVARS_001_09----------------------#'
140 ###############################################################################
141 # Check if global and session variables are independant of each other #
142 ###############################################################################
143
144 SET @@global.select_into_buffer_size = 16384;
145 SET @@session.select_into_buffer_size = 8192;
146 SELECT @@select_into_buffer_size = @@global.select_into_buffer_size;
147
148
149 --echo '#---------------------FN_DYNVARS_001_10----------------------#'
150 ##############################################################################
151 # Check if accessing variable with SESSION,LOCAL and without SCOPE points #
152 # to same session variable #
153 ##############################################################################
154
155 SET @@select_into_buffer_size = 16384;
156 SELECT @@select_into_buffer_size = @@local.select_into_buffer_size;
157 SELECT @@local.select_into_buffer_size = @@session.select_into_buffer_size;
158
159
160 --echo '#---------------------FN_DYNVARS_001_11----------------------#'
161 ###############################################################################
162 # Check if select_into_buffer_size can be accessed with and without @@ sign #
163 ###############################################################################
164
165 SET select_into_buffer_size = 1024;
166 SELECT @@select_into_buffer_size;
167 --Error ER_UNKNOWN_TABLE
168 SELECT local.select_into_buffer_size;
169 --Error ER_UNKNOWN_TABLE
170 SELECT session.select_into_buffer_size;
171 --Error ER_BAD_FIELD_ERROR
172 SELECT select_into_buffer_size = @@session.select_into_buffer_size;
173
174 --echo '#---------------------FN_DYNVARS_001_12----------------------#'
175 ######################################################################################
176 # Check if changing session variable throws error without sufficient privileges #
177 ######################################################################################
178 CREATE USER foo, bar;
179 GRANT SESSION_VARIABLES_ADMIN ON *.* TO bar;
180 --let $conn_name = foo_connection
181 --connect($conn_name, localhost, foo,,,)
182 SELECT @@session.select_into_buffer_size;
183 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
184 SET @@session.select_into_buffer_size = 15000;
185 --connection default
186 disconnect $conn_name;
187 --let $conn_name = bar_connection
188 --connect($conn_name, localhost, bar,,,)
189 SELECT @@session.select_into_buffer_size;
190 SET @@session.select_into_buffer_size = 15000;
191 SELECT @@session.select_into_buffer_size;
192 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
193 SET @@global.select_into_buffer_size = 15000;
194 --connection default
195 disconnect $conn_name;
196 DROP USER foo, bar;
197
198
199 ####################################
200 # Restore initial value #
201 ####################################
202
203 SET @@global.select_into_buffer_size = @start_global_value;
204 SELECT @@global.select_into_buffer_size;
205 SET @@session.select_into_buffer_size = @start_session_value;
206 SELECT @@session.select_into_buffer_size;
207
208
209 ###################################################
210 # END OF select_into_buffer_size TESTS #
211 ###################################################
212