1
SET @start_global_value = @@global.tmp_table_size;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.tmp_table_size;
6
SELECT @start_session_value;
9
'Bug# 34876: This variable has invalid default value as compared to documentation';
10
'#--------------------FN_DYNVARS_005_01-------------------------#'
11
SET @@global.tmp_table_size = 100;
13
Warning 1292 Truncated incorrect tmp_table_size value: '100'
14
SET @@global.tmp_table_size = DEFAULT;
15
SELECT @@global.tmp_table_size;
16
@@global.tmp_table_size
18
'Bug# 34876: This variable has invalid default value as compared to documentation';
19
SET @@session.tmp_table_size = 200;
21
Warning 1292 Truncated incorrect tmp_table_size value: '200'
22
SET @@session.tmp_table_size = DEFAULT;
23
SELECT @@session.tmp_table_size;
24
@@session.tmp_table_size
26
'Bug# 34876: This variable has invalid default value as compared to documentation';
27
'#--------------------FN_DYNVARS_005_02-------------------------#'
28
SET @@global.tmp_table_size = DEFAULT;
29
SELECT @@global.tmp_table_size = 33554432;
30
@@global.tmp_table_size = 33554432
32
SET @@session.tmp_table_size = DEFAULT;
33
SELECT @@session.tmp_table_size = 33554432;
34
@@session.tmp_table_size = 33554432
36
'Bug# 34876: This variable has invalid default value as compared to documentation';
37
'#--------------------FN_DYNVARS_005_03-------------------------#'
38
SET @@global.tmp_table_size = 1024;
39
SELECT @@global.tmp_table_size;
40
@@global.tmp_table_size
42
SET @@global.tmp_table_size = 60020;
43
SELECT @@global.tmp_table_size;
44
@@global.tmp_table_size
46
SET @@global.tmp_table_size = 4294967295;
47
SELECT @@global.tmp_table_size;
48
@@global.tmp_table_size
50
'#--------------------FN_DYNVARS_005_04-------------------------#'
51
SET @@session.tmp_table_size = 1024;
52
SELECT @@session.tmp_table_size;
53
@@session.tmp_table_size
55
SET @@session.tmp_table_size =4294967295;
56
SELECT @@session.tmp_table_size;
57
@@session.tmp_table_size
59
SET @@session.tmp_table_size = 65535;
60
SELECT @@session.tmp_table_size;
61
@@session.tmp_table_size
63
'#------------------FN_DYNVARS_005_05-----------------------#'
64
SET @@global.tmp_table_size = 0;
66
Warning 1292 Truncated incorrect tmp_table_size value: '0'
67
SELECT @@global.tmp_table_size;
68
@@global.tmp_table_size
70
SET @@global.tmp_table_size = -1024;
72
Warning 1292 Truncated incorrect tmp_table_size value: '0'
73
SELECT @@global.tmp_table_size;
74
@@global.tmp_table_size
76
SET @@global.tmp_table_size = 1000;
78
Warning 1292 Truncated incorrect tmp_table_size value: '1000'
79
SELECT @@global.tmp_table_size;
80
@@global.tmp_table_size
82
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
83
SET @@global.tmp_table_size = ON;
84
ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
85
SET @@global.tmp_table_size = OFF;
86
ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
87
SET @@global.tmp_table_size = True;
89
Warning 1292 Truncated incorrect tmp_table_size value: '1'
90
SELECT @@global.tmp_table_size;
91
@@global.tmp_table_size
93
SET @@global.tmp_table_size = False;
95
Warning 1292 Truncated incorrect tmp_table_size value: '0'
96
SELECT @@global.tmp_table_size;
97
@@global.tmp_table_size
99
'Bug:Error should be shown that variable is numeric and can not assigned boolean value';
100
SET @@global.tmp_table_size = 65530.34;
101
ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
102
SET @@global.tmp_table_size ="Test";
103
ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
104
SET @@session.tmp_table_size = ON;
105
ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
106
SET @@session.tmp_table_size = OFF;
107
ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
108
SET @@session.tmp_table_size = True;
110
Warning 1292 Truncated incorrect tmp_table_size value: '1'
111
SELECT @@session.tmp_table_size;
112
@@session.tmp_table_size
114
SET @@session.tmp_table_size = False;
116
Warning 1292 Truncated incorrect tmp_table_size value: '0'
117
SELECT @@session.tmp_table_size;
118
@@session.tmp_table_size
120
SET @@session.tmp_table_size = "Test";
121
ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
122
SET @@session.tmp_table_size = 12345678901;
123
SELECT @@session.tmp_table_size;
124
@@session.tmp_table_size
126
'#------------------FN_DYNVARS_005_06-----------------------#'
127
SELECT @@global.tmp_table_size = VARIABLE_VALUE
128
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
129
WHERE VARIABLE_NAME='tmp_table_size';
130
@@global.tmp_table_size = VARIABLE_VALUE
132
'#------------------FN_DYNVARS_005_07-----------------------#'
133
SELECT @@session.tmp_table_size = VARIABLE_VALUE
134
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
135
WHERE VARIABLE_NAME='tmp_table_size';
136
@@session.tmp_table_size = VARIABLE_VALUE
138
'#---------------------FN_DYNVARS_001_09----------------------#'
139
SET @@global.tmp_table_size = 1024;
140
SET @@tmp_table_size = 4294967295;
141
SELECT @@tmp_table_size = @@global.tmp_table_size;
142
@@tmp_table_size = @@global.tmp_table_size
144
'#---------------------FN_DYNVARS_001_10----------------------#'
145
SET @@tmp_table_size = 100;
147
Warning 1292 Truncated incorrect tmp_table_size value: '100'
148
SELECT @@tmp_table_size = @@local.tmp_table_size;
149
@@tmp_table_size = @@local.tmp_table_size
151
SELECT @@local.tmp_table_size = @@session.tmp_table_size;
152
@@local.tmp_table_size = @@session.tmp_table_size
154
'#---------------------FN_DYNVARS_001_11----------------------#'
155
SET tmp_table_size = 1027;
156
SELECT @@tmp_table_size;
159
SELECT local.tmp_table_size;
160
ERROR 42S02: Unknown table 'local' in field list
161
SELECT global.tmp_table_size;
162
ERROR 42S02: Unknown table 'global' in field list
163
SELECT tmp_table_size = @@session.tmp_table_size;
164
ERROR 42S22: Unknown column 'tmp_table_size' in 'field list'
165
SET @@global.tmp_table_size = @start_global_value;
166
SELECT @@global.tmp_table_size;
167
@@global.tmp_table_size
169
SET @@session.tmp_table_size = @start_session_value;
170
SELECT @@session.tmp_table_size;
171
@@session.tmp_table_size