Debian Codegraph @

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

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