Debian Codegraph @

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

raw
1 #
2 --source include/have_statement_timeout.inc
3
4 --echo # Initial values
5 SELECT @@global.max_execution_time, @@session.max_execution_time;
6
7 --echo # Save initial value
8
9 SET @start_global_value= @@global.max_execution_time;
10 SELECT @start_global_value;
11
12 SET @start_session_value = @@session.max_execution_time;
13 SELECT @start_session_value;
14
15 --echo # Display the DEFAULT value of max_execution_time
16
17 SET @@session.max_execution_time = 20000;
18 SET @@session.max_execution_time = DEFAULT;
19 SELECT @@session.max_execution_time;
20
21 SET @@global.max_execution_time = 20000;
22 SET @@global.max_execution_time = DEFAULT;
23 SELECT @@global.max_execution_time;
24
25 --echo # Check the DEFAULT value of max_execution_time
26
27 SET @@global.max_execution_time = DEFAULT;
28 SELECT @@global.max_execution_time = 28800;
29
30 SET @@session.max_execution_time = DEFAULT;
31 SELECT @@session.max_execution_time = 28800;
32
33 --echo # Check Max value for max_execution_time.
34
35 --disable_query_log
36 --disable_warnings
37 SET @@global.max_execution_time = 4294967296;
38 let $value_of_32bit = `SELECT @@global.max_execution_time <= 4294967295 OR
39 convert(@@version_compile_os using latin1) IN ("Win32","Win64","Windows")`;
40
41 if ($value_of_32bit)
42 {
43 eval SET @@global.max_execution_time= 4294967295;
44 eval SET @@session.max_execution_time= 4294967295;
45 --error 0,ER_WRONG_TYPE_FOR_VAR
46 eval SET @@global.max_execution_time= 4294967296;
47 --error 0,ER_WRONG_TYPE_FOR_VAR
48 eval SET @@session.max_execution_time= 4294967296;
49 let $max_global_value= `SELECT @@global.max_execution_time = 4294967295`;
50 let $max_session_value= `SELECT @@session.max_execution_time = 4294967295`;
51 if ($max_global_value)
52 {
53 echo "Max value for @@global.max_execution_time is set properly.";
54 }
55 if ($max_session_value)
56 {
57 echo "Max value for @@session.max_execution_time is set properly.";
58 }
59 }
60 if (!$value_of_32bit)
61 {
62 eval SET @@global.max_execution_time= 1844674407370955615;
63 eval SET @@session.max_execution_time= 1844674407370955615;
64 --error 0,ER_WRONG_TYPE_FOR_VAR
65 eval SET @@global.max_execution_time= 18446744073709551616;
66 --error 0,ER_WRONG_TYPE_FOR_VAR
67 eval SET @@session.max_execution_time= 18446744073709551616;
68 let $max_global_value= `SELECT @@global.max_execution_time = 1844674407370955615`;
69 let $max_session_value= `SELECT @@session.max_execution_time = 1844674407370955615`;
70 if ($max_global_value)
71 {
72 echo "Max value for @@global.max_execution_time is set properly.";
73 }
74 if ($max_session_value)
75 {
76 echo "Max value for @@session.max_execution_time is set properly.";
77 }
78 }
79 --enable_warnings
80 --enable_query_log
81
82 SET @@global.max_execution_time = 0;
83 SELECT @@global.max_execution_time;
84
85 SET @@session.max_execution_time = 0;
86 SELECT @@global.max_execution_time;
87
88 --echo # Change the value of max_execution_time to a valid value for SESSION scope
89
90 SET @@session.max_execution_time = 10000;
91 SELECT @@global.max_execution_time, @@session.max_execution_time;
92 SET @@session.max_execution_time = 50050;
93 SELECT @@global.max_execution_time, @@session.max_execution_time;
94 SET @@session.max_execution_time = 65535;
95 SELECT @@global.max_execution_time, @@session.max_execution_time;
96
97 --echo # Change the value of max_execution_time to an invalid value #
98
99 SET @@global.max_execution_time = -2;
100 SELECT @@global.max_execution_time;
101 --error ER_WRONG_TYPE_FOR_VAR
102 SET @@global.max_execution_time = 65530.34;
103 SELECT @@global.max_execution_time;
104 --error ER_WRONG_TYPE_FOR_VAR
105 SET @@global.max_execution_time = test;
106 SELECT @@global.max_execution_time;
107 --echo # Change the value of max_execution_time to a valid value for SESSION scope
108
109 SET @@session.max_execution_time = 10000;
110 SELECT @@global.max_execution_time, @@session.max_execution_time;
111 SET @@session.max_execution_time = 50050;
112 SELECT @@global.max_execution_time, @@session.max_execution_time;
113 SET @@session.max_execution_time = 65535;
114 SELECT @@global.max_execution_time, @@session.max_execution_time;
115
116 --echo # Change the value of max_execution_time to an invalid value #
117
118 SET @@global.max_execution_time = -2;
119 SELECT @@global.max_execution_time;
120 --error ER_WRONG_TYPE_FOR_VAR
121 SET @@global.max_execution_time = 65530.34;
122 SELECT @@global.max_execution_time;
123 --error ER_WRONG_TYPE_FOR_VAR
124 SET @@global.max_execution_time = test;
125 SELECT @@global.max_execution_time;
126 --error ER_WRONG_TYPE_FOR_VAR
127 SET @@global.max_execution_time = "";
128 SELECT @@global.max_execution_time;
129 --error ER_WRONG_TYPE_FOR_VAR
130 SET @@global.max_execution_time = "*";
131 SELECT @@global.max_execution_time;
132 --error ER_WRONG_TYPE_FOR_VAR
133 SET @@global.max_execution_time = NULL;
134 SELECT @@global.max_execution_time;
135 --error ER_WRONG_TYPE_FOR_VAR
136 SET @@global.max_execution_time = "0";
137 SELECT @@global.max_execution_time;
138 --error ER_WRONG_TYPE_FOR_VAR
139 SET @@global.max_execution_time = "*#$**$(@(@ ##@";
140 SELECT @@global.max_execution_time;
141
142 SET @@session.max_execution_time = -2;
143 SELECT @@session.max_execution_time;
144 --error ER_WRONG_TYPE_FOR_VAR
145 SET @@session.max_execution_time = 65530.34;
146 SELECT @@session.max_execution_time;
147 --error ER_WRONG_TYPE_FOR_VAR
148 SET @@session.max_execution_time = test;
149 SELECT @@session.max_execution_time;
150 --error ER_WRONG_TYPE_FOR_VAR
151 SET @@session.max_execution_time = "";
152 SELECT @@session.max_execution_time;
153 --error ER_WRONG_TYPE_FOR_VAR
154 SET @@session.max_execution_time = "*";
155 SELECT @@session.max_execution_time;
156 --error ER_WRONG_TYPE_FOR_VAR
157 SET @@session.max_execution_time = NULL;
158 SELECT @@session.max_execution_time;
159 --error ER_WRONG_TYPE_FOR_VAR
160 SET @@session.max_execution_time = "0";
161 SELECT @@session.max_execution_time;
162 --error ER_WRONG_TYPE_FOR_VAR
163 SET @@session.max_execution_time = "*#$**$(@(@ ##@";
164 SELECT @@session.max_execution_time;
165
166 --echo # Check if the value in GLOBAL Table matches value in variable
167
168 --disable_warnings
169 SELECT @@global.max_execution_time = VARIABLE_VALUE
170 FROM performance_schema.global_variables
171 WHERE VARIABLE_NAME='max_execution_time';
172 --enable_warnings
173
174 --echo # Check if the value in SESSION Table matches value in variable
175
176 --disable_warnings
177 SELECT @@session.max_execution_time = VARIABLE_VALUE
178 FROM performance_schema.session_variables
179 WHERE VARIABLE_NAME='max_execution_time';
180 --enable_warnings
181
182 --echo # Check if TRUE and FALSE values can be used on variable
183 SET @@global.max_execution_time = TRUE;
184 SELECT @@global.max_execution_time;
185 SET @@global.max_execution_time = FALSE;
186 SELECT @@global.max_execution_time;
187
188 SET @@session.max_execution_time = TRUE;
189 SELECT @@session.max_execution_time;
190 SET @@session.max_execution_time = FALSE;
191 SELECT @@session.max_execution_time;
192
193 --echo # Check if accessing variable with SESSION,LOCAL and without SCOPE points to same session variable
194
195 SET @@max_execution_time = 10000;
196 SELECT @@max_execution_time = @@local.max_execution_time;
197 SELECT @@local.max_execution_time = @@session.max_execution_time;
198
199 --echo # Check if max_execution_time can be accessed with and without @@ sign
200
201 SET max_execution_time = 10000;
202 SELECT @@max_execution_time;
203 --error ER_UNKNOWN_TABLE
204 SELECT local.max_execution_time;
205 --error ER_UNKNOWN_TABLE
206 SELECT session.max_execution_time;
207
208 --echo # Restore initial value
209 SET @@global.max_execution_time = @start_global_value;
210 SELECT @@global.max_execution_time;
211
212 SET @@session.max_execution_time = @start_session_value;
213 SELECT @@session.max_execution_time;
214