1SET @start_global_value = @@global.tmp_table_size;
2SET @start_session_value = @@session.tmp_table_size;
3'#--------------------FN_DYNVARS_005_01-------------------------#'
4SET @@global.tmp_table_size = 100;
5Warnings:
6Warning	1292	Truncated incorrect tmp_table_size value: '100'
7SET @@global.tmp_table_size = DEFAULT;
8SET @@session.tmp_table_size = 200;
9Warnings:
10Warning	1292	Truncated incorrect tmp_table_size value: '200'
11SET @@session.tmp_table_size = DEFAULT;
12'#--------------------FN_DYNVARS_005_02-------------------------#'
13SELECT @@global.tmp_table_size >= 16777216;
14@@global.tmp_table_size >= 16777216
151
16SELECT @@session.tmp_table_size >= 16777216;
17@@session.tmp_table_size >= 16777216
181
19'#--------------------FN_DYNVARS_005_03-------------------------#'
20SET @@global.tmp_table_size = 1024;
21SELECT @@global.tmp_table_size;
22@@global.tmp_table_size
231024
24SET @@global.tmp_table_size = 60020;
25SELECT @@global.tmp_table_size;
26@@global.tmp_table_size
2760020
28SET @@global.tmp_table_size = 4294967295;
29SELECT @@global.tmp_table_size;
30@@global.tmp_table_size
314294967295
32'#--------------------FN_DYNVARS_005_04-------------------------#'
33SET @@session.tmp_table_size = 1024;
34SELECT @@session.tmp_table_size;
35@@session.tmp_table_size
361024
37SET @@session.tmp_table_size = 4294967295;
38SELECT @@session.tmp_table_size;
39@@session.tmp_table_size
404294967295
41SET @@session.tmp_table_size = 65535;
42SELECT @@session.tmp_table_size;
43@@session.tmp_table_size
4465535
45'#------------------FN_DYNVARS_005_05-----------------------#'
46SET @@global.tmp_table_size = 0;
47Warnings:
48Warning	1292	Truncated incorrect tmp_table_size value: '0'
49SELECT @@global.tmp_table_size;
50@@global.tmp_table_size
511024
52SET @@global.tmp_table_size = -1024;
53Warnings:
54Warning	1292	Truncated incorrect tmp_table_size value: '-1024'
55SELECT @@global.tmp_table_size;
56@@global.tmp_table_size
571024
58SET @@global.tmp_table_size = 1000;
59Warnings:
60Warning	1292	Truncated incorrect tmp_table_size value: '1000'
61SELECT @@global.tmp_table_size;
62@@global.tmp_table_size
631024
64SET @@global.tmp_table_size = 4294967299;
65SELECT @@global.tmp_table_size;
66@@global.tmp_table_size
674294967299
68SET @@global.tmp_table_size = ' ';
69ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
70SELECT @@global.tmp_table_size;
71@@global.tmp_table_size
724294967299
73SET @@global.tmp_table_size = ON;
74ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
75SET @@global.tmp_table_size = OFF;
76ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
77SET @@global.tmp_table_size = True;
78Warnings:
79Warning	1292	Truncated incorrect tmp_table_size value: '1'
80SELECT @@global.tmp_table_size;
81@@global.tmp_table_size
821024
83SET @@global.tmp_table_size = False;
84Warnings:
85Warning	1292	Truncated incorrect tmp_table_size value: '0'
86SELECT @@global.tmp_table_size;
87@@global.tmp_table_size
881024
89SET @@global.tmp_table_size = 65530.34;
90ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
91SET @@global.tmp_table_size ="Test";
92ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
93SET @@session.tmp_table_size = ON;
94ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
95SET @@session.tmp_table_size = OFF;
96ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
97SET @@session.tmp_table_size = True;
98Warnings:
99Warning	1292	Truncated incorrect tmp_table_size value: '1'
100SELECT @@session.tmp_table_size;
101@@session.tmp_table_size
1021024
103SET @@session.tmp_table_size = 65530.34;
104ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
105SET @@session.tmp_table_size = False;
106Warnings:
107Warning	1292	Truncated incorrect tmp_table_size value: '0'
108SELECT @@session.tmp_table_size;
109@@session.tmp_table_size
1101024
111SET @@session.tmp_table_size = "Test";
112ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
113SET @@session.tmp_table_size = ' ';
114ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
115SELECT @@session.tmp_table_size;
116@@session.tmp_table_size
1171024
118SET @@session.tmp_table_size = 1000;
119Warnings:
120Warning	1292	Truncated incorrect tmp_table_size value: '1000'
121SELECT @@session.tmp_table_size;
122@@session.tmp_table_size
1231024
124SET @@session.tmp_table_size = 12345678901;
125SELECT @@session.tmp_table_size IN (12345678901,4294967295);
126@@session.tmp_table_size IN (12345678901,4294967295)
1271
128'#------------------FN_DYNVARS_005_06-----------------------#'
129SELECT @@global.tmp_table_size = VARIABLE_VALUE
130FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
131WHERE VARIABLE_NAME='tmp_table_size';
132@@global.tmp_table_size = VARIABLE_VALUE
1331
134'#------------------FN_DYNVARS_005_07-----------------------#'
135SELECT @@session.tmp_table_size = VARIABLE_VALUE
136FROM INFORMATION_SCHEMA.SESSION_VARIABLES
137WHERE VARIABLE_NAME='tmp_table_size';
138@@session.tmp_table_size = VARIABLE_VALUE
1391
140'#---------------------FN_DYNVARS_001_09----------------------#'
141SET @@global.tmp_table_size = 1024;
142SET @@tmp_table_size = 4294967295;
143SELECT @@tmp_table_size = @@global.tmp_table_size;
144@@tmp_table_size = @@global.tmp_table_size
1450
146'#---------------------FN_DYNVARS_001_10----------------------#'
147SET @@tmp_table_size = 100;
148Warnings:
149Warning	1292	Truncated incorrect tmp_table_size value: '100'
150SELECT @@tmp_table_size = @@local.tmp_table_size;
151@@tmp_table_size = @@local.tmp_table_size
1521
153SELECT @@local.tmp_table_size = @@session.tmp_table_size;
154@@local.tmp_table_size = @@session.tmp_table_size
1551
156'#---------------------FN_DYNVARS_001_11----------------------#'
157SET tmp_table_size = 1027;
158SELECT @@tmp_table_size;
159@@tmp_table_size
1601027
161SELECT local.tmp_table_size;
162ERROR 42S02: Unknown table 'local' in field list
163SELECT global.tmp_table_size;
164ERROR 42S02: Unknown table 'global' in field list
165SELECT tmp_table_size = @@session.tmp_table_size;
166ERROR 42S22: Unknown column 'tmp_table_size' in 'field list'
167SET @@global.tmp_table_size = @start_global_value;
168SET @@session.tmp_table_size = @start_session_value;
169