1
SET @start_global_value = @@global.max_tmp_tables;
3
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
4
SELECT @start_global_value;
7
SET @start_session_value = @@session.max_tmp_tables;
9
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
10
SELECT @start_session_value;
13
'#--------------------FN_DYNVARS_086_01-------------------------#'
14
SET @@global.max_tmp_tables = 1000;
16
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
17
SET @@global.max_tmp_tables = DEFAULT;
19
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
20
SELECT @@global.max_tmp_tables;
21
@@global.max_tmp_tables
24
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
25
SET @@session.max_tmp_tables = 1000;
27
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
28
SET @@session.max_tmp_tables = DEFAULT;
30
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
31
SELECT @@session.max_tmp_tables;
32
@@session.max_tmp_tables
35
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
36
'#--------------------FN_DYNVARS_086_02-------------------------#'
37
SET @@global.max_tmp_tables = DEFAULT;
39
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
40
SELECT @@global.max_tmp_tables = 32;
41
@@global.max_tmp_tables = 32
44
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
45
SET @@session.max_tmp_tables = DEFAULT;
47
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
48
SELECT @@session.max_tmp_tables = 32;
49
@@session.max_tmp_tables = 32
52
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
53
'#--------------------FN_DYNVARS_086_03-------------------------#'
54
SET @@global.max_tmp_tables = 1;
56
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
57
SELECT @@global.max_tmp_tables;
58
@@global.max_tmp_tables
61
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
62
SET @@global.max_tmp_tables = 2;
64
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
65
SELECT @@global.max_tmp_tables;
66
@@global.max_tmp_tables
69
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
70
SET @@global.max_tmp_tables = 65536;
72
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
73
SELECT @@global.max_tmp_tables;
74
@@global.max_tmp_tables
77
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
78
SET @@global.max_tmp_tables = 4294967295;
80
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
81
SELECT @@global.max_tmp_tables;
82
@@global.max_tmp_tables
85
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
86
SET @@global.max_tmp_tables = 4294967294;
88
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
89
SELECT @@global.max_tmp_tables;
90
@@global.max_tmp_tables
93
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
94
'#--------------------FN_DYNVARS_086_04-------------------------#'
95
SET @@session.max_tmp_tables = 1;
97
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
98
SELECT @@session.max_tmp_tables;
99
@@session.max_tmp_tables
102
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
103
SET @@session.max_tmp_tables = 2;
105
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
106
SELECT @@session.max_tmp_tables;
107
@@session.max_tmp_tables
110
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
111
SET @@session.max_tmp_tables = 65536;
113
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
114
SELECT @@session.max_tmp_tables;
115
@@session.max_tmp_tables
118
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
119
SET @@session.max_tmp_tables = 4294967295;
121
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
122
SELECT @@session.max_tmp_tables;
123
@@session.max_tmp_tables
126
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
127
SET @@session.max_tmp_tables = 4294967294;
129
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
130
SELECT @@session.max_tmp_tables;
131
@@session.max_tmp_tables
134
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
135
'#------------------FN_DYNVARS_086_05-----------------------#'
136
SET @@global.max_tmp_tables = -1024;
138
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
139
Warning 1292 Truncated incorrect max_tmp_tables value: '-1024'
140
SELECT @@global.max_tmp_tables;
141
@@global.max_tmp_tables
144
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
145
SET @@global.max_tmp_tables = 4294967296;
147
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
148
SELECT @@global.max_tmp_tables;
149
@@global.max_tmp_tables
152
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
153
SET @@global.max_tmp_tables = -1;
155
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
156
Warning 1292 Truncated incorrect max_tmp_tables value: '-1'
157
SELECT @@global.max_tmp_tables;
158
@@global.max_tmp_tables
161
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
162
SET @@global.max_tmp_tables = 429496729500;
164
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
165
SELECT @@global.max_tmp_tables;
166
@@global.max_tmp_tables
169
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
170
SET @@global.max_tmp_tables = 65530.34;
171
ERROR 42000: Incorrect argument type to variable 'max_tmp_tables'
172
SELECT @@global.max_tmp_tables;
173
@@global.max_tmp_tables
176
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
177
SET @@global.max_tmp_tables = test;
178
ERROR 42000: Incorrect argument type to variable 'max_tmp_tables'
179
SELECT @@global.max_tmp_tables;
180
@@global.max_tmp_tables
183
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
184
SET @@session.max_tmp_tables = 4294967296;
186
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
187
SELECT @@session.max_tmp_tables;
188
@@session.max_tmp_tables
191
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
192
SET @@session.max_tmp_tables = -1;
194
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
195
Warning 1292 Truncated incorrect max_tmp_tables value: '-1'
196
SELECT @@session.max_tmp_tables;
197
@@session.max_tmp_tables
200
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
201
SET @@session.max_tmp_tables = 429496729500;
203
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
204
SELECT @@session.max_tmp_tables;
205
@@session.max_tmp_tables
208
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
209
SET @@session.max_tmp_tables = -001;
211
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
212
Warning 1292 Truncated incorrect max_tmp_tables value: '-1'
213
SELECT @@session.max_tmp_tables;
214
@@session.max_tmp_tables
217
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
218
SET @@session.max_tmp_tables = 65530.34;
219
ERROR 42000: Incorrect argument type to variable 'max_tmp_tables'
220
SET @@session.max_tmp_tables = 10737418241;
222
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
223
SELECT @@session.max_tmp_tables;
224
@@session.max_tmp_tables
227
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
228
SET @@session.max_tmp_tables = test;
229
ERROR 42000: Incorrect argument type to variable 'max_tmp_tables'
230
SELECT @@session.max_tmp_tables;
231
@@session.max_tmp_tables
234
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
235
'#------------------FN_DYNVARS_086_06-----------------------#'
236
SELECT @@global.max_tmp_tables = VARIABLE_VALUE
237
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
238
WHERE VARIABLE_NAME='max_tmp_tables';
239
@@global.max_tmp_tables = VARIABLE_VALUE
242
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
243
'#------------------FN_DYNVARS_086_07-----------------------#'
244
SELECT @@session.max_tmp_tables = VARIABLE_VALUE
245
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
246
WHERE VARIABLE_NAME='max_tmp_tables';
247
@@session.max_tmp_tables = VARIABLE_VALUE
250
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
251
'#------------------FN_DYNVARS_086_08-----------------------#'
252
SET @@global.max_tmp_tables = TRUE;
254
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
255
SELECT @@global.max_tmp_tables;
256
@@global.max_tmp_tables
259
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
260
SET @@global.max_tmp_tables = FALSE;
262
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
263
Warning 1292 Truncated incorrect max_tmp_tables value: '0'
264
SELECT @@global.max_tmp_tables;
265
@@global.max_tmp_tables
268
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
269
'#---------------------FN_DYNVARS_086_09----------------------#'
270
SET @@global.max_tmp_tables = 20;
272
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
273
SELECT @@max_tmp_tables = @@global.max_tmp_tables;
274
@@max_tmp_tables = @@global.max_tmp_tables
277
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
278
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
279
'#---------------------FN_DYNVARS_086_10----------------------#'
280
SET @@max_tmp_tables = 255;
282
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
283
SELECT @@max_tmp_tables = @@local.max_tmp_tables;
284
@@max_tmp_tables = @@local.max_tmp_tables
287
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
288
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
289
SELECT @@local.max_tmp_tables = @@session.max_tmp_tables;
290
@@local.max_tmp_tables = @@session.max_tmp_tables
293
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
294
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
295
'#---------------------FN_DYNVARS_086_11----------------------#'
296
SET max_tmp_tables = 102;
298
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
299
SELECT @@max_tmp_tables;
303
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
304
SELECT local.max_tmp_tables;
305
ERROR 42S02: Unknown table 'local' in field list
306
SELECT session.max_tmp_tables;
307
ERROR 42S02: Unknown table 'session' in field list
308
SELECT max_tmp_tables = @@session.max_tmp_tables;
309
ERROR 42S22: Unknown column 'max_tmp_tables' in 'field list'
310
SET @@global.max_tmp_tables = @start_global_value;
312
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
313
SELECT @@global.max_tmp_tables;
314
@@global.max_tmp_tables
317
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
318
SET @@session.max_tmp_tables = @start_session_value;
320
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.
321
SELECT @@session.max_tmp_tables;
322
@@session.max_tmp_tables
325
Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release.