1
SET @start_global_value = @@global.transaction_alloc_block_size;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.transaction_alloc_block_size;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_005_01-------------------------#'
10
SET @@global.transaction_alloc_block_size = 100;
12
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '100'
13
SET @@global.transaction_alloc_block_size = DEFAULT;
14
SELECT @@global.transaction_alloc_block_size;
15
@@global.transaction_alloc_block_size
17
SET @@session.transaction_alloc_block_size = 200;
19
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '200'
20
SET @@session.transaction_alloc_block_size = DEFAULT;
21
SELECT @@session.transaction_alloc_block_size;
22
@@session.transaction_alloc_block_size
24
'#--------------------FN_DYNVARS_005_02-------------------------#'
25
SET @@global.transaction_alloc_block_size = DEFAULT;
26
SELECT @@global.transaction_alloc_block_size = 8192;
27
@@global.transaction_alloc_block_size = 8192
29
SET @@session.transaction_alloc_block_size = DEFAULT;
30
SELECT @@session.transaction_alloc_block_size = 8192;
31
@@session.transaction_alloc_block_size = 8192
33
'#--------------------FN_DYNVARS_005_03-------------------------#'
34
SET @@global.transaction_alloc_block_size = 1024;
35
SELECT @@global.transaction_alloc_block_size;
36
@@global.transaction_alloc_block_size
38
SET @@global.transaction_alloc_block_size = 60020;
40
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '60020'
41
SELECT @@global.transaction_alloc_block_size;
42
@@global.transaction_alloc_block_size
44
'#--------------------FN_DYNVARS_005_04-------------------------#'
45
SET @@session.transaction_alloc_block_size = 1024;
46
SELECT @@session.transaction_alloc_block_size;
47
@@session.transaction_alloc_block_size
49
SET @@session.transaction_alloc_block_size = 65535;
51
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '65535'
52
SELECT @@session.transaction_alloc_block_size;
53
@@session.transaction_alloc_block_size
55
'#------------------FN_DYNVARS_005_05-----------------------#'
56
SET @@global.transaction_alloc_block_size = 0;
58
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '0'
59
SELECT @@global.transaction_alloc_block_size;
60
@@global.transaction_alloc_block_size
62
SET @@global.transaction_alloc_block_size = -1024;
64
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '-1024'
65
SELECT @@global.transaction_alloc_block_size;
66
@@global.transaction_alloc_block_size
68
SET @@global.transaction_alloc_block_size = 135217728;
70
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '135217728'
71
SELECT @@global.transaction_alloc_block_size;
72
@@global.transaction_alloc_block_size
74
SET @@global.transaction_alloc_block_size = ON;
75
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
76
SET @@global.transaction_alloc_block_size = OFF;
77
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
78
SET @@global.transaction_alloc_block_size = True;
80
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '1'
81
SELECT @@global.transaction_alloc_block_size;
82
@@global.transaction_alloc_block_size
84
SET @@global.transaction_alloc_block_size = False;
86
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '0'
87
SELECT @@global.transaction_alloc_block_size;
88
@@global.transaction_alloc_block_size
90
SET @@global.transaction_alloc_block_size = 65530.34;
91
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
92
SET @@global.transaction_alloc_block_size ="Test";
93
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
94
SET @@global.transaction_alloc_block_size = 1000;
96
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '1000'
97
SELECT @@global.transaction_alloc_block_size;
98
@@global.transaction_alloc_block_size
100
SET @@session.transaction_alloc_block_size = 135217728;
102
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '135217728'
103
SELECT @@session.transaction_alloc_block_size;
104
@@session.transaction_alloc_block_size
106
SET @@session.transaction_alloc_block_size = ON;
107
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
108
SET @@session.transaction_alloc_block_size = OFF;
109
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
110
SET @@session.transaction_alloc_block_size = True;
112
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '1'
113
SELECT @@session.transaction_alloc_block_size;
114
@@session.transaction_alloc_block_size
116
SET @@session.transaction_alloc_block_size = False;
118
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '0'
119
SELECT @@session.transaction_alloc_block_size;
120
@@session.transaction_alloc_block_size
122
SET @@session.transaction_alloc_block_size = "Test";
123
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
124
SET @@session.transaction_alloc_block_size = 'test';
125
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
126
'#------------------FN_DYNVARS_005_06-----------------------#'
127
SELECT @@global.transaction_alloc_block_size = VARIABLE_VALUE
128
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
129
WHERE VARIABLE_NAME='transaction_alloc_block_size';
130
@@global.transaction_alloc_block_size = VARIABLE_VALUE
132
'#------------------FN_DYNVARS_005_07-----------------------#'
133
SELECT @@session.transaction_alloc_block_size = VARIABLE_VALUE
134
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
135
WHERE VARIABLE_NAME='transaction_alloc_block_size';
136
@@session.transaction_alloc_block_size = VARIABLE_VALUE
138
'#---------------------FN_DYNVARS_001_08----------------------#'
139
SET @@transaction_alloc_block_size = 1024;
140
SET @@global.transaction_alloc_block_size = 134217728;
141
SELECT @@transaction_alloc_block_size = @@global.transaction_alloc_block_size;
142
@@transaction_alloc_block_size = @@global.transaction_alloc_block_size
144
'#---------------------FN_DYNVARS_001_09----------------------#'
145
SET @@transaction_alloc_block_size = 100;
147
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '100'
148
SELECT @@transaction_alloc_block_size = @@local.transaction_alloc_block_size;
149
@@transaction_alloc_block_size = @@local.transaction_alloc_block_size
151
SELECT @@local.transaction_alloc_block_size = @@session.transaction_alloc_block_size;
152
@@local.transaction_alloc_block_size = @@session.transaction_alloc_block_size
154
'#---------------------FN_DYNVARS_001_10----------------------#'
155
SET transaction_alloc_block_size = 1027;
157
Warning 1292 Truncated incorrect transaction_alloc_block_size value: '1027'
158
SELECT @@transaction_alloc_block_size;
159
@@transaction_alloc_block_size
161
SELECT local.transaction_alloc_block_size;
162
ERROR 42S02: Unknown table 'local' in field list
163
SELECT session.transaction_alloc_block_size;
164
ERROR 42S02: Unknown table 'session' in field list
165
SELECT transaction_alloc_block_size = @@session.transaction_alloc_block_size;
166
ERROR 42S22: Unknown column 'transaction_alloc_block_size' in 'field list'
167
SET @@global.transaction_alloc_block_size = @start_global_value;
168
SELECT @@global.transaction_alloc_block_size;
169
@@global.transaction_alloc_block_size
171
SET @@session.tmp_table_size = @start_session_value;
172
SELECT @@session.transaction_alloc_block_size;
173
@@session.transaction_alloc_block_size