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;
79
SELECT @@global.max_tmp_tables;
80
@@global.max_tmp_tables
82
SET @@global.max_tmp_tables = -1;
84
Warning 1292 Truncated incorrect max_tmp_tables value: '0'
85
SELECT @@global.max_tmp_tables;
86
@@global.max_tmp_tables
88
SET @@global.max_tmp_tables = 429496729500;
89
SELECT @@global.max_tmp_tables;
90
@@global.max_tmp_tables
92
SET @@global.max_tmp_tables = 65530.34.;
93
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
94
SELECT @@global.max_tmp_tables;
95
@@global.max_tmp_tables
97
SET @@global.max_tmp_tables = test;
98
ERROR 42000: Incorrect argument type to variable 'max_tmp_tables'
99
SELECT @@global.max_tmp_tables;
100
@@global.max_tmp_tables
102
SET @@session.max_tmp_tables = 4294967296;
103
SELECT @@session.max_tmp_tables;
104
@@session.max_tmp_tables
106
SET @@session.max_tmp_tables = -1;
108
Warning 1292 Truncated incorrect max_tmp_tables value: '0'
109
SELECT @@session.max_tmp_tables;
110
@@session.max_tmp_tables
112
SET @@session.max_tmp_tables = 429496729500;
113
SELECT @@session.max_tmp_tables;
114
@@session.max_tmp_tables
116
SET @@session.max_tmp_tables = -001;
118
Warning 1292 Truncated incorrect max_tmp_tables value: '0'
119
SELECT @@session.max_tmp_tables;
120
@@session.max_tmp_tables
122
SET @@session.max_tmp_tables = 65530.34.;
123
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
124
SET @@session.max_tmp_tables = 10737418241;
125
SELECT @@session.max_tmp_tables;
126
@@session.max_tmp_tables
128
SET @@session.max_tmp_tables = test;
129
ERROR 42000: Incorrect argument type to variable 'max_tmp_tables'
130
SELECT @@session.max_tmp_tables;
131
@@session.max_tmp_tables
133
'#------------------FN_DYNVARS_086_06-----------------------#'
134
SELECT @@global.max_tmp_tables = VARIABLE_VALUE
135
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
136
WHERE VARIABLE_NAME='max_tmp_tables';
137
@@global.max_tmp_tables = VARIABLE_VALUE
139
'#------------------FN_DYNVARS_086_07-----------------------#'
140
SELECT @@session.max_tmp_tables = VARIABLE_VALUE
141
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
142
WHERE VARIABLE_NAME='max_tmp_tables';
143
@@session.max_tmp_tables = VARIABLE_VALUE
145
'#------------------FN_DYNVARS_086_08-----------------------#'
146
SET @@global.max_tmp_tables = TRUE;
147
SELECT @@global.max_tmp_tables;
148
@@global.max_tmp_tables
150
SET @@global.max_tmp_tables = FALSE;
152
Warning 1292 Truncated incorrect max_tmp_tables value: '0'
153
SELECT @@global.max_tmp_tables;
154
@@global.max_tmp_tables
156
'#---------------------FN_DYNVARS_086_09----------------------#'
157
SET @@global.max_tmp_tables = 20;
158
SELECT @@max_tmp_tables = @@global.max_tmp_tables;
159
@@max_tmp_tables = @@global.max_tmp_tables
161
'#---------------------FN_DYNVARS_086_10----------------------#'
162
SET @@max_tmp_tables = 255;
163
SELECT @@max_tmp_tables = @@local.max_tmp_tables;
164
@@max_tmp_tables = @@local.max_tmp_tables
166
SELECT @@local.max_tmp_tables = @@session.max_tmp_tables;
167
@@local.max_tmp_tables = @@session.max_tmp_tables
169
'#---------------------FN_DYNVARS_086_11----------------------#'
170
SET max_tmp_tables = 102;
171
SELECT @@max_tmp_tables;
174
SELECT local.max_tmp_tables;
175
ERROR 42S02: Unknown table 'local' in field list
176
SELECT session.max_tmp_tables;
177
ERROR 42S02: Unknown table 'session' in field list
178
SELECT max_tmp_tables = @@session.max_tmp_tables;
179
ERROR 42S22: Unknown column 'max_tmp_tables' in 'field list'
180
SET @@global.max_tmp_tables = @start_global_value;
181
SELECT @@global.max_tmp_tables;
182
@@global.max_tmp_tables
184
SET @@session.max_tmp_tables = @start_session_value;
185
SELECT @@session.max_tmp_tables;
186
@@session.max_tmp_tables