1
SET @start_global_value = @@global.max_tmp_tables;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.max_tmp_tables;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_086_01-------------------------#'
10
SET @@global.max_tmp_tables = 1000;
11
SET @@global.max_tmp_tables = DEFAULT;
12
SELECT @@global.max_tmp_tables;
13
@@global.max_tmp_tables
15
SET @@session.max_tmp_tables = 1000;
16
SET @@session.max_tmp_tables = DEFAULT;
17
SELECT @@session.max_tmp_tables;
18
@@session.max_tmp_tables
20
'#--------------------FN_DYNVARS_086_02-------------------------#'
21
SET @@global.max_tmp_tables = DEFAULT;
22
SELECT @@global.max_tmp_tables = 32;
23
@@global.max_tmp_tables = 32
25
SET @@session.max_tmp_tables = DEFAULT;
26
SELECT @@session.max_tmp_tables = 32;
27
@@session.max_tmp_tables = 32
29
'#--------------------FN_DYNVARS_086_03-------------------------#'
30
SET @@global.max_tmp_tables = 1;
31
SELECT @@global.max_tmp_tables;
32
@@global.max_tmp_tables
34
SET @@global.max_tmp_tables = 2;
35
SELECT @@global.max_tmp_tables;
36
@@global.max_tmp_tables
38
SET @@global.max_tmp_tables = 65536;
39
SELECT @@global.max_tmp_tables;
40
@@global.max_tmp_tables
42
SET @@global.max_tmp_tables = 4294967295;
43
SELECT @@global.max_tmp_tables;
44
@@global.max_tmp_tables
46
SET @@global.max_tmp_tables = 4294967294;
47
SELECT @@global.max_tmp_tables;
48
@@global.max_tmp_tables
50
'#--------------------FN_DYNVARS_086_04-------------------------#'
51
SET @@session.max_tmp_tables = 1;
52
SELECT @@session.max_tmp_tables;
53
@@session.max_tmp_tables
55
SET @@session.max_tmp_tables = 2;
56
SELECT @@session.max_tmp_tables;
57
@@session.max_tmp_tables
59
SET @@session.max_tmp_tables = 65536;
60
SELECT @@session.max_tmp_tables;
61
@@session.max_tmp_tables
63
SET @@session.max_tmp_tables = 4294967295;
64
SELECT @@session.max_tmp_tables;
65
@@session.max_tmp_tables
67
SET @@session.max_tmp_tables = 4294967294;
68
SELECT @@session.max_tmp_tables;
69
@@session.max_tmp_tables
71
'#------------------FN_DYNVARS_086_05-----------------------#'
72
SET @@global.max_tmp_tables = -1024;
74
Warning 1292 Truncated incorrect max_tmp_tables value: '0'
75
SELECT @@global.max_tmp_tables;
76
@@global.max_tmp_tables
78
SET @@global.max_tmp_tables = 4294967296;
80
Warning 1292 Truncated incorrect max_tmp_tables value: '4294967296'
81
SELECT @@global.max_tmp_tables;
82
@@global.max_tmp_tables
84
SET @@global.max_tmp_tables = -1;
86
Warning 1292 Truncated incorrect max_tmp_tables value: '0'
87
SELECT @@global.max_tmp_tables;
88
@@global.max_tmp_tables
90
SET @@global.max_tmp_tables = 429496729500;
92
Warning 1292 Truncated incorrect max_tmp_tables value: '429496729500'
93
SELECT @@global.max_tmp_tables;
94
@@global.max_tmp_tables
96
SET @@global.max_tmp_tables = 65530.34.;
97
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
98
SELECT @@global.max_tmp_tables;
99
@@global.max_tmp_tables
101
SET @@global.max_tmp_tables = test;
102
ERROR 42000: Incorrect argument type to variable 'max_tmp_tables'
103
SELECT @@global.max_tmp_tables;
104
@@global.max_tmp_tables
106
SET @@session.max_tmp_tables = 4294967296;
108
Warning 1292 Truncated incorrect max_tmp_tables value: '4294967296'
109
SELECT @@session.max_tmp_tables;
110
@@session.max_tmp_tables
112
SET @@session.max_tmp_tables = -1;
114
Warning 1292 Truncated incorrect max_tmp_tables value: '0'
115
SELECT @@session.max_tmp_tables;
116
@@session.max_tmp_tables
118
SET @@session.max_tmp_tables = 429496729500;
120
Warning 1292 Truncated incorrect max_tmp_tables value: '429496729500'
121
SELECT @@session.max_tmp_tables;
122
@@session.max_tmp_tables
124
SET @@session.max_tmp_tables = -001;
126
Warning 1292 Truncated incorrect max_tmp_tables value: '0'
127
SELECT @@session.max_tmp_tables;
128
@@session.max_tmp_tables
130
SET @@session.max_tmp_tables = 65530.34.;
131
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
132
SET @@session.max_tmp_tables = 10737418241;
134
Warning 1292 Truncated incorrect max_tmp_tables value: '10737418241'
135
SELECT @@session.max_tmp_tables;
136
@@session.max_tmp_tables
138
SET @@session.max_tmp_tables = test;
139
ERROR 42000: Incorrect argument type to variable 'max_tmp_tables'
140
SELECT @@session.max_tmp_tables;
141
@@session.max_tmp_tables
143
'#------------------FN_DYNVARS_086_06-----------------------#'
144
SELECT @@global.max_tmp_tables = VARIABLE_VALUE
145
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
146
WHERE VARIABLE_NAME='max_tmp_tables';
147
@@global.max_tmp_tables = VARIABLE_VALUE
149
'#------------------FN_DYNVARS_086_07-----------------------#'
150
SELECT @@session.max_tmp_tables = VARIABLE_VALUE
151
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
152
WHERE VARIABLE_NAME='max_tmp_tables';
153
@@session.max_tmp_tables = VARIABLE_VALUE
155
'#------------------FN_DYNVARS_086_08-----------------------#'
156
SET @@global.max_tmp_tables = TRUE;
157
SELECT @@global.max_tmp_tables;
158
@@global.max_tmp_tables
160
SET @@global.max_tmp_tables = FALSE;
162
Warning 1292 Truncated incorrect max_tmp_tables value: '0'
163
SELECT @@global.max_tmp_tables;
164
@@global.max_tmp_tables
166
'#---------------------FN_DYNVARS_086_09----------------------#'
167
SET @@global.max_tmp_tables = 20;
168
SELECT @@max_tmp_tables = @@global.max_tmp_tables;
169
@@max_tmp_tables = @@global.max_tmp_tables
171
'#---------------------FN_DYNVARS_086_10----------------------#'
172
SET @@max_tmp_tables = 255;
173
SELECT @@max_tmp_tables = @@local.max_tmp_tables;
174
@@max_tmp_tables = @@local.max_tmp_tables
176
SELECT @@local.max_tmp_tables = @@session.max_tmp_tables;
177
@@local.max_tmp_tables = @@session.max_tmp_tables
179
'#---------------------FN_DYNVARS_086_11----------------------#'
180
SET max_tmp_tables = 102;
181
SELECT @@max_tmp_tables;
184
SELECT local.max_tmp_tables;
185
ERROR 42S02: Unknown table 'local' in field list
186
SELECT session.max_tmp_tables;
187
ERROR 42S02: Unknown table 'session' in field list
188
SELECT max_tmp_tables = @@session.max_tmp_tables;
189
ERROR 42S22: Unknown column 'max_tmp_tables' in 'field list'
190
SET @@global.max_tmp_tables = @start_global_value;
191
SELECT @@global.max_tmp_tables;
192
@@global.max_tmp_tables
194
SET @@session.max_tmp_tables = @start_session_value;
195
SELECT @@session.max_tmp_tables;
196
@@session.max_tmp_tables