Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.transaction_prealloc_size;
2 SELECT @start_global_value;
3 @start_global_value
4 4096
5 SET @start_session_value = @@session.transaction_prealloc_size;
6 SELECT @start_session_value;
7 @start_session_value
8 4096
9 '#--------------------FN_DYNVARS_005_01-------------------------#'
10 SET @@global.transaction_prealloc_size = 100;
11 Warnings:
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
16 4096
17 SET @@session.transaction_prealloc_size = 200;
18 Warnings:
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
23 4096
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
28 1
29 SET @@session.transaction_prealloc_size = DEFAULT;
30 SELECT @@session.transaction_prealloc_size = 4096;
31 @@session.transaction_prealloc_size = 4096
32 1
33 '#--------------------FN_DYNVARS_005_03-------------------------#'
34 SET @@global.transaction_prealloc_size = 1024;
35 SELECT @@global.transaction_prealloc_size;
36 @@global.transaction_prealloc_size
37 1024
38 SET @@global.transaction_prealloc_size = 60020;
39 Warnings:
40 Warning 1292 Truncated incorrect transaction_prealloc_size value: '60020'
41 SELECT @@global.transaction_prealloc_size;
42 @@global.transaction_prealloc_size
43 59392
44 '#--------------------FN_DYNVARS_005_04-------------------------#'
45 SET @@session.transaction_prealloc_size = 1024;
46 SELECT @@session.transaction_prealloc_size;
47 @@session.transaction_prealloc_size
48 1024
49 SET @@session.transaction_prealloc_size = 65535;
50 Warnings:
51 Warning 1292 Truncated incorrect transaction_prealloc_size value: '65535'
52 SELECT @@session.transaction_prealloc_size;
53 @@session.transaction_prealloc_size
54 64512
55 '#------------------FN_DYNVARS_005_05-----------------------#'
56 SET @@global.transaction_prealloc_size = 0;
57 Warnings:
58 Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
59 SELECT @@global.transaction_prealloc_size;
60 @@global.transaction_prealloc_size
61 1024
62 SET @@global.transaction_prealloc_size = -1024;
63 Warnings:
64 Warning 1292 Truncated incorrect transaction_prealloc_size value: '-1024'
65 SELECT @@global.transaction_prealloc_size;
66 @@global.transaction_prealloc_size
67 1024
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;
73 Warnings:
74 Warning 1292 Truncated incorrect transaction_prealloc_size value: '1'
75 SELECT @@global.transaction_prealloc_size;
76 @@global.transaction_prealloc_size
77 1024
78 SET @@global.transaction_prealloc_size = False;
79 Warnings:
80 Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
81 SELECT @@global.transaction_prealloc_size;
82 @@global.transaction_prealloc_size
83 1024
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;
89 Warnings:
90 Warning 1292 Truncated incorrect transaction_prealloc_size value: '1000'
91 SELECT @@global.transaction_prealloc_size;
92 @@global.transaction_prealloc_size
93 1024
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;
99 Warnings:
100 Warning 1292 Truncated incorrect transaction_prealloc_size value: '1'
101 SELECT @@session.transaction_prealloc_size;
102 @@session.transaction_prealloc_size
103 1024
104 SET @@session.transaction_prealloc_size = False;
105 Warnings:
106 Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
107 SELECT @@session.transaction_prealloc_size;
108 @@session.transaction_prealloc_size
109 1024
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;
113 Warnings:
114 Warning 1292 Truncated incorrect transaction_prealloc_size value: '135217728'
115 SELECT @@session.transaction_prealloc_size;
116 @@session.transaction_prealloc_size
117 134217728
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
123 1
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
129 1
130 '#---------------------FN_DYNVARS_001_09----------------------#'
131 SET @@global.transaction_prealloc_size = 1024;
132 SET @@global.transaction_prealloc_size = 10;
133 Warnings:
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
137 0
138 '#---------------------FN_DYNVARS_001_10----------------------#'
139 SET @@transaction_prealloc_size = 100;
140 Warnings:
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
144 1
145 SELECT @@local.transaction_prealloc_size = @@session.transaction_prealloc_size;
146 @@local.transaction_prealloc_size = @@session.transaction_prealloc_size
147 1
148 '#---------------------FN_DYNVARS_001_11----------------------#'
149 SET transaction_prealloc_size = 1027;
150 Warnings:
151 Warning 1292 Truncated incorrect transaction_prealloc_size value: '1027'
152 SELECT @@transaction_prealloc_size;
153 @@transaction_prealloc_size
154 1024
155 SELECT local.transaction_prealloc_size;
156 ERROR 42S02: Unknown table 'local' in SELECT
157 SELECT session.transaction_prealloc_size;
158 ERROR 42S02: Unknown table 'session' in SELECT
159 SELECT transaction_prealloc_size = @@session.transaction_prealloc_size;
160 ERROR 42S22: Unknown column 'transaction_prealloc_size' in 'SELECT'
161 SET @@global.transaction_prealloc_size = @start_global_value;
162 SELECT @@global.transaction_prealloc_size;
163 @@global.transaction_prealloc_size
164 4096
165 SET @@session.transaction_prealloc_size = @start_session_value;
166 SELECT @@session.transaction_prealloc_size;
167 @@session.transaction_prealloc_size
168 4096