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
'Bug# 34876: This variable has invalid default value as compared to documentation';
10
'#--------------------FN_DYNVARS_005_01-------------------------#'
11
SET @@global.transaction_prealloc_size = 100;
13
Warning 1292 Truncated incorrect transaction_prealloc_size value: '100'
14
SET @@global.transaction_prealloc_size = DEFAULT;
15
SELECT @@global.transaction_prealloc_size;
16
@@global.transaction_prealloc_size
18
SET @@session.transaction_prealloc_size = 200;
20
Warning 1292 Truncated incorrect transaction_prealloc_size value: '200'
21
SET @@session.transaction_prealloc_size = DEFAULT;
22
SELECT @@session.transaction_prealloc_size;
23
@@session.transaction_prealloc_size
25
'#--------------------FN_DYNVARS_005_02-------------------------#'
26
SET @@global.transaction_prealloc_size = DEFAULT;
27
SELECT @@global.transaction_prealloc_size = 4096;
28
@@global.transaction_prealloc_size = 4096
30
SET @@session.transaction_prealloc_size = DEFAULT;
31
SELECT @@session.transaction_prealloc_size = 4096;
32
@@session.transaction_prealloc_size = 4096
34
'#--------------------FN_DYNVARS_005_03-------------------------#'
35
SET @@global.transaction_prealloc_size = 1024;
36
SELECT @@global.transaction_prealloc_size;
37
@@global.transaction_prealloc_size
39
SET @@global.transaction_prealloc_size = 60020;
40
SELECT @@global.transaction_prealloc_size;
41
@@global.transaction_prealloc_size
43
SET @@global.transaction_prealloc_size = 4294966272;
44
SELECT @@global.transaction_prealloc_size;
45
@@global.transaction_prealloc_size
47
'#--------------------FN_DYNVARS_005_04-------------------------#'
48
SET @@session.transaction_prealloc_size = 1024;
49
SELECT @@session.transaction_prealloc_size;
50
@@session.transaction_prealloc_size
52
SET @@session.transaction_prealloc_size =4294966272;
53
SELECT @@session.transaction_prealloc_size;
54
@@session.transaction_prealloc_size
56
SET @@session.transaction_prealloc_size = 65535;
57
SELECT @@session.transaction_prealloc_size;
58
@@session.transaction_prealloc_size
60
'#------------------FN_DYNVARS_005_05-----------------------#'
61
SET @@global.transaction_prealloc_size = 0;
63
Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
64
SELECT @@global.transaction_prealloc_size;
65
@@global.transaction_prealloc_size
67
SET @@global.transaction_prealloc_size = -1024;
69
Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
70
SELECT @@global.transaction_prealloc_size;
71
@@global.transaction_prealloc_size
73
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
74
SET @@global.transaction_prealloc_size = ON;
75
ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
76
SET @@global.transaction_prealloc_size = OFF;
77
ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
78
SET @@global.transaction_prealloc_size = True;
80
Warning 1292 Truncated incorrect transaction_prealloc_size value: '1'
81
SELECT @@global.transaction_prealloc_size;
82
@@global.transaction_prealloc_size
84
SET @@global.transaction_prealloc_size = False;
86
Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
87
SELECT @@global.transaction_prealloc_size;
88
@@global.transaction_prealloc_size
90
SET @@global.transaction_prealloc_size = 65530.34;
91
ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
92
SET @@global.transaction_prealloc_size ="Test";
93
ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
94
SET @@global.transaction_prealloc_size = 1000;
96
Warning 1292 Truncated incorrect transaction_prealloc_size value: '1000'
97
SELECT @@global.transaction_prealloc_size;
98
@@global.transaction_prealloc_size
100
SET @@session.transaction_prealloc_size = ON;
101
ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
102
SET @@session.transaction_prealloc_size = OFF;
103
ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
104
SET @@session.transaction_prealloc_size = True;
106
Warning 1292 Truncated incorrect transaction_prealloc_size value: '1'
107
SELECT @@session.transaction_prealloc_size;
108
@@session.transaction_prealloc_size
110
SET @@session.transaction_prealloc_size = False;
112
Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
113
SELECT @@session.transaction_prealloc_size;
114
@@session.transaction_prealloc_size
116
SET @@session.transaction_prealloc_size = "Test";
117
ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
118
SET @@session.transaction_prealloc_size = 123456789031;
120
Warning 1292 Truncated incorrect transaction_prealloc_size value: '123456789031'
121
SELECT @@session.transaction_prealloc_size;
122
@@session.transaction_prealloc_size
124
'#------------------FN_DYNVARS_005_06-----------------------#'
125
SELECT @@global.transaction_prealloc_size = VARIABLE_VALUE
126
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
127
WHERE VARIABLE_NAME='transaction_prealloc_size';
128
@@global.transaction_prealloc_size = VARIABLE_VALUE
130
'#------------------FN_DYNVARS_005_07-----------------------#'
131
SELECT @@session.transaction_prealloc_size = VARIABLE_VALUE
132
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
133
WHERE VARIABLE_NAME='transaction_prealloc_size';
134
@@session.transaction_prealloc_size = VARIABLE_VALUE
136
'#---------------------FN_DYNVARS_001_09----------------------#'
137
SET @@global.transaction_prealloc_size = 1024;
138
SET @@global.transaction_prealloc_size = 10;
140
Warning 1292 Truncated incorrect transaction_prealloc_size value: '10'
141
SELECT @@transaction_prealloc_size = @@global.transaction_prealloc_size;
142
@@transaction_prealloc_size = @@global.transaction_prealloc_size
144
'#---------------------FN_DYNVARS_001_10----------------------#'
145
SET @@transaction_prealloc_size = 100;
147
Warning 1292 Truncated incorrect transaction_prealloc_size value: '100'
148
SELECT @@transaction_prealloc_size = @@local.transaction_prealloc_size;
149
@@transaction_prealloc_size = @@local.transaction_prealloc_size
151
SELECT @@local.transaction_prealloc_size = @@session.transaction_prealloc_size;
152
@@local.transaction_prealloc_size = @@session.transaction_prealloc_size
154
'#---------------------FN_DYNVARS_001_11----------------------#'
155
SET transaction_prealloc_size = 1027;
156
SELECT @@transaction_prealloc_size;
157
@@transaction_prealloc_size
159
SELECT local.transaction_prealloc_size;
160
ERROR 42S02: Unknown table 'local' in field list
161
SELECT session.transaction_prealloc_size;
162
ERROR 42S02: Unknown table 'session' in field list
163
SELECT transaction_prealloc_size = @@session.transaction_prealloc_size;
164
ERROR 42S22: Unknown column 'transaction_prealloc_size' in 'field list'
165
SET @@global.transaction_prealloc_size = @start_global_value;
166
SELECT @@global.transaction_prealloc_size;
167
@@global.transaction_prealloc_size
169
SET @@session.transaction_prealloc_size = @start_session_value;
170
SELECT @@session.transaction_prealloc_size;
171
@@session.transaction_prealloc_size