Debian Codegraph @

mysql-test/suite/sys_vars/r/transaction_alloc_block_size_basic.result

raw
1 SET @start_global_value = @@global.transaction_alloc_block_size;
2 SELECT @start_global_value;
3 @start_global_value
4 8192
5 SET @start_session_value = @@session.transaction_alloc_block_size;
6 SELECT @start_session_value;
7 @start_session_value
8 8192
9 '#--------------------FN_DYNVARS_005_01-------------------------#'
10 SET @@global.transaction_alloc_block_size = 100;
11 Warnings:
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
16 8192
17 SET @@session.transaction_alloc_block_size = 200;
18 Warnings:
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
23 8192
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
28 1
29 SET @@session.transaction_alloc_block_size = DEFAULT;
30 SELECT @@session.transaction_alloc_block_size = 8192;
31 @@session.transaction_alloc_block_size = 8192
32 1
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
37 1024
38 SET @@global.transaction_alloc_block_size = 60020;
39 Warnings:
40 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '60020'
41 SELECT @@global.transaction_alloc_block_size;
42 @@global.transaction_alloc_block_size
43 59392
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
48 1024
49 SET @@session.transaction_alloc_block_size = 65535;
50 Warnings:
51 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '65535'
52 SELECT @@session.transaction_alloc_block_size;
53 @@session.transaction_alloc_block_size
54 64512
55 '#------------------FN_DYNVARS_005_05-----------------------#'
56 SET @@global.transaction_alloc_block_size = 0;
57 Warnings:
58 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '0'
59 SELECT @@global.transaction_alloc_block_size;
60 @@global.transaction_alloc_block_size
61 1024
62 SET @@global.transaction_alloc_block_size = -1024;
63 Warnings:
64 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '-1024'
65 SELECT @@global.transaction_alloc_block_size;
66 @@global.transaction_alloc_block_size
67 1024
68 SET @@global.transaction_alloc_block_size = 135217728;
69 Warnings:
70 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '135217728'
71 SELECT @@global.transaction_alloc_block_size;
72 @@global.transaction_alloc_block_size
73 131072
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;
79 Warnings:
80 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '1'
81 SELECT @@global.transaction_alloc_block_size;
82 @@global.transaction_alloc_block_size
83 1024
84 SET @@global.transaction_alloc_block_size = False;
85 Warnings:
86 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '0'
87 SELECT @@global.transaction_alloc_block_size;
88 @@global.transaction_alloc_block_size
89 1024
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;
95 Warnings:
96 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '1000'
97 SELECT @@global.transaction_alloc_block_size;
98 @@global.transaction_alloc_block_size
99 1024
100 SET @@session.transaction_alloc_block_size = 135217728;
101 Warnings:
102 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '135217728'
103 SELECT @@session.transaction_alloc_block_size;
104 @@session.transaction_alloc_block_size
105 131072
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;
111 Warnings:
112 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '1'
113 SELECT @@session.transaction_alloc_block_size;
114 @@session.transaction_alloc_block_size
115 1024
116 SET @@session.transaction_alloc_block_size = False;
117 Warnings:
118 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '0'
119 SELECT @@session.transaction_alloc_block_size;
120 @@session.transaction_alloc_block_size
121 1024
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 performance_schema.global_variables
129 WHERE VARIABLE_NAME='transaction_alloc_block_size';
130 @@global.transaction_alloc_block_size = VARIABLE_VALUE
131 1
132 '#------------------FN_DYNVARS_005_07-----------------------#'
133 SELECT @@session.transaction_alloc_block_size = VARIABLE_VALUE
134 FROM performance_schema.session_variables
135 WHERE VARIABLE_NAME='transaction_alloc_block_size';
136 @@session.transaction_alloc_block_size = VARIABLE_VALUE
137 1
138 '#---------------------FN_DYNVARS_001_08----------------------#'
139 SET @@transaction_alloc_block_size = 1024;
140 SET @@global.transaction_alloc_block_size = 134217728;
141 Warnings:
142 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '134217728'
143 SELECT @@transaction_alloc_block_size = @@global.transaction_alloc_block_size;
144 @@transaction_alloc_block_size = @@global.transaction_alloc_block_size
145 0
146 '#---------------------FN_DYNVARS_001_09----------------------#'
147 SET @@transaction_alloc_block_size = 100;
148 Warnings:
149 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '100'
150 SELECT @@transaction_alloc_block_size = @@local.transaction_alloc_block_size;
151 @@transaction_alloc_block_size = @@local.transaction_alloc_block_size
152 1
153 SELECT @@local.transaction_alloc_block_size = @@session.transaction_alloc_block_size;
154 @@local.transaction_alloc_block_size = @@session.transaction_alloc_block_size
155 1
156 '#---------------------FN_DYNVARS_001_10----------------------#'
157 SET transaction_alloc_block_size = 1027;
158 Warnings:
159 Warning 1292 Truncated incorrect transaction_alloc_block_size value: '1027'
160 SELECT @@transaction_alloc_block_size;
161 @@transaction_alloc_block_size
162 1024
163 SELECT local.transaction_alloc_block_size;
164 ERROR 42S02: Unknown table 'local' in field list
165 SELECT session.transaction_alloc_block_size;
166 ERROR 42S02: Unknown table 'session' in field list
167 SELECT transaction_alloc_block_size = @@session.transaction_alloc_block_size;
168 ERROR 42S22: Unknown column 'transaction_alloc_block_size' in 'field list'
169 SET @@global.transaction_alloc_block_size = @start_global_value;
170 SELECT @@global.transaction_alloc_block_size;
171 @@global.transaction_alloc_block_size
172 8192
173 SET @@session.tmp_table_size = @start_session_value;
174 SELECT @@session.transaction_alloc_block_size;
175 @@session.transaction_alloc_block_size
176 1024