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