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 = ON;
65ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
66SET @@global.tmp_table_size = OFF;
67ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
68SET @@global.tmp_table_size = True;
69Warnings:
70Warning	1292	Truncated incorrect tmp_table_size value: '1'
71SELECT @@global.tmp_table_size;
72@@global.tmp_table_size
731024
74SET @@global.tmp_table_size = False;
75Warnings:
76Warning	1292	Truncated incorrect tmp_table_size value: '0'
77SELECT @@global.tmp_table_size;
78@@global.tmp_table_size
791024
80SET @@global.tmp_table_size = 65530.34;
81ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
82SET @@global.tmp_table_size ="Test";
83ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
84SET @@session.tmp_table_size = ON;
85ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
86SET @@session.tmp_table_size = OFF;
87ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
88SET @@session.tmp_table_size = True;
89Warnings:
90Warning	1292	Truncated incorrect tmp_table_size value: '1'
91SELECT @@session.tmp_table_size;
92@@session.tmp_table_size
931024
94SET @@session.tmp_table_size = False;
95Warnings:
96Warning	1292	Truncated incorrect tmp_table_size value: '0'
97SELECT @@session.tmp_table_size;
98@@session.tmp_table_size
991024
100SET @@session.tmp_table_size = "Test";
101ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
102SET @@session.tmp_table_size = 12345678901;
103SELECT @@session.tmp_table_size IN (12345678901,4294967295);
104@@session.tmp_table_size IN (12345678901,4294967295)
1051
106'#------------------FN_DYNVARS_005_06-----------------------#'
107SELECT @@global.tmp_table_size = VARIABLE_VALUE
108FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
109WHERE VARIABLE_NAME='tmp_table_size';
110@@global.tmp_table_size = VARIABLE_VALUE
1111
112'#------------------FN_DYNVARS_005_07-----------------------#'
113SELECT @@session.tmp_table_size = VARIABLE_VALUE
114FROM INFORMATION_SCHEMA.SESSION_VARIABLES
115WHERE VARIABLE_NAME='tmp_table_size';
116@@session.tmp_table_size = VARIABLE_VALUE
1171
118'#---------------------FN_DYNVARS_001_09----------------------#'
119SET @@global.tmp_table_size = 1024;
120SET @@tmp_table_size = 4294967295;
121SELECT @@tmp_table_size = @@global.tmp_table_size;
122@@tmp_table_size = @@global.tmp_table_size
1230
124'#---------------------FN_DYNVARS_001_10----------------------#'
125SET @@tmp_table_size = 100;
126Warnings:
127Warning	1292	Truncated incorrect tmp_table_size value: '100'
128SELECT @@tmp_table_size = @@local.tmp_table_size;
129@@tmp_table_size = @@local.tmp_table_size
1301
131SELECT @@local.tmp_table_size = @@session.tmp_table_size;
132@@local.tmp_table_size = @@session.tmp_table_size
1331
134'#---------------------FN_DYNVARS_001_11----------------------#'
135SET tmp_table_size = 1027;
136SELECT @@tmp_table_size;
137@@tmp_table_size
1381027
139SELECT local.tmp_table_size;
140ERROR 42S02: Unknown table 'local' in field list
141SELECT global.tmp_table_size;
142ERROR 42S02: Unknown table 'global' in field list
143SELECT tmp_table_size = @@session.tmp_table_size;
144ERROR 42S22: Unknown column 'tmp_table_size' in 'field list'
145SET @@global.tmp_table_size = @start_global_value;
146SET @@session.tmp_table_size = @start_session_value;
147