Debian Codegraph @

mysql-test/suite/ndb/r/ndb_bitfield.result

raw
1 create table t1 (
2 pk1 int not null primary key,
3 b bit(64)
4 ) engine=ndbcluster;
5 show create table t1;
6 Table Create Table
7 t1 CREATE TABLE `t1` (
8 `pk1` int NOT NULL,
9 `b` bit(64) DEFAULT NULL,
10 PRIMARY KEY (`pk1`)
11 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 insert into t1 values
13 (0,b'1111111111111111111111111111111111111111111111111111111111111111'),
14 (1,b'1000000000000000000000000000000000000000000000000000000000000000'),
15 (2,b'0000000000000000000000000000000000000000000000000000000000000001'),
16 (3,b'1010101010101010101010101010101010101010101010101010101010101010'),
17 (4,b'0101010101010101010101010101010101010101010101010101010101010101');
18 select hex(b) from t1 order by pk1;
19 hex(b)
20 FFFFFFFFFFFFFFFF
21 8000000000000000
22 1
23 AAAAAAAAAAAAAAAA
24 5555555555555555
25 drop table t1;
26 create table t1 (
27 pk1 int not null primary key,
28 b bit(9)
29 ) engine=ndbcluster;
30 insert into t1 values
31 (0,b'000000000'),
32 (1,b'000000001'),
33 (2,b'000000010'),
34 (3,b'000000011'),
35 (4,b'000000100');
36 select hex(b) from t1 order by pk1;
37 hex(b)
38 0
39 1
40 2
41 3
42 4
43 update t1 set b = b + b'101010101';
44 select hex(b) from t1 order by pk1;
45 hex(b)
46 155
47 156
48 157
49 158
50 159
51 drop table t1;
52 create table t1 (a bit(7), b bit(9)) engine = ndbcluster;
53 insert into t1 values
54 (94, 46), (31, 438), (61, 152), (78, 123), (88, 411), (122, 118), (0, 177),
55 (75, 42), (108, 67), (79, 349), (59, 188), (68, 206), (49, 345), (118, 380),
56 (111, 368), (94, 468), (56, 379), (77, 133), (29, 399), (9, 363), (23, 36),
57 (116, 390), (119, 368), (87, 351), (123, 411), (24, 398), (34, 202), (28, 499),
58 (30, 83), (5, 178), (60, 343), (4, 245), (104, 280), (106, 446), (127, 403),
59 (44, 307), (68, 454), (57, 135);
60 select a+0 from t1 order by a;
61 a+0
62 0
63 4
64 5
65 9
66 23
67 24
68 28
69 29
70 30
71 31
72 34
73 44
74 49
75 56
76 57
77 59
78 60
79 61
80 68
81 68
82 75
83 77
84 78
85 79
86 87
87 88
88 94
89 94
90 104
91 106
92 108
93 111
94 116
95 118
96 119
97 122
98 123
99 127
100 select b+0 from t1 order by b;
101 b+0
102 36
103 42
104 46
105 67
106 83
107 118
108 123
109 133
110 135
111 152
112 177
113 178
114 188
115 202
116 206
117 245
118 280
119 307
120 343
121 345
122 349
123 351
124 363
125 368
126 368
127 379
128 380
129 390
130 398
131 399
132 403
133 411
134 411
135 438
136 446
137 454
138 468
139 499
140 drop table t1;
141 create table t1 (
142 dummyKey INTEGER NOT NULL,
143 a001 TINYINT,
144 a010 TINYINT,
145 a012 TINYINT,
146 a015 TINYINT,
147 a016 TINYINT,
148 a017 TINYINT,
149 a019 TINYINT,
150 a029 TINYINT,
151 a030 TINYINT,
152 a031 TINYINT,
153 a032 TINYINT,
154 a042 TINYINT,
155 a043 TINYINT,
156 a044 TINYINT,
157 a3001 TINYINT,
158 a3002 TINYINT,
159 a3003 TINYINT,
160 a3004 TINYINT,
161 a3005 TINYINT,
162 a3021 TINYINT,
163 a3022 TINYINT,
164 a BIT(6),
165 b BIT(6),
166 c BIT(6),
167 d TINYINT,
168 e TINYINT,
169 f TINYINT,
170 g TINYINT,
171 h TINYINT,
172 i TINYINT,
173 j TINYINT,
174 k TINYINT,
175 l TINYINT,
176 m TINYINT,
177 n TINYINT,
178 o TINYINT,
179 a034 TINYINT,
180 PRIMARY KEY USING HASH (dummyKey) ) engine=ndb;
181 INSERT INTO `t1` VALUES
182 (1,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'000001',b'111111',b'111110',4,5,5,5,5,5,5,5,5,5,3,2,1),
183 (2,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'000010',b'000000',b'111101',4,5,5,5,5,5,5,5,5,5,3,2,1),
184 (3,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'000100',b'001111',b'111011',4,5,5,5,5,5,5,5,5,5,3,2,1),
185 (4,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'001000',b'110000',b'110111',4,5,5,5,5,5,5,5,5,5,3,2,1),
186 (5,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'010000',b'100001',b'101111',4,5,5,5,5,5,5,5,5,5,3,2,1),
187 (6,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'100000',b'010010',b'011111',4,5,5,5,5,5,5,5,5,5,3,2,1),
188 (7,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'000000',b'001100',b'111111',4,5,5,5,5,5,5,5,5,5,3,2,1),
189 (8,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'111111',b'000000',b'000000',4,5,5,5,5,5,5,5,5,5,3,2,1);
190 INSERT INTO `t1` VALUES (1,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x01,0x3F,0x3E,4,5,5,5,5,5,5,5,5,5,3,2,1);
191 INSERT INTO `t1` VALUES (2,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x02,0x00,0x3D,4,5,5,5,5,5,5,5,5,5,3,2,1);
192 INSERT INTO `t1` VALUES (3,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x04,0x0F,0x3B,4,5,5,5,5,5,5,5,5,5,3,2,1);
193 INSERT INTO `t1` VALUES (4,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x08,0x30,0x37,4,5,5,5,5,5,5,5,5,5,3,2,1);
194 INSERT INTO `t1` VALUES (5,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x10,0x21,0x2F,4,5,5,5,5,5,5,5,5,5,3,2,1);
195 INSERT INTO `t1` VALUES (6,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x20,0x12,0x1F,4,5,5,5,5,5,5,5,5,5,3,2,1);
196 INSERT INTO `t1` VALUES (7,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x00,0x0C,0x3F,4,5,5,5,5,5,5,5,5,5,3,2,1);
197 INSERT INTO `t1` VALUES (8,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x3F,0x00,0x00,4,5,5,5,5,5,5,5,5,5,3,2,1);
198 select a001, a010, a012, a015, a016, a017, a019, a029
199 a030, a031, a032, a042, a043, a044, a3001, a3002,
200 a3003, a3004, a3005, a3021, a3022, hex(a), hex(b), hex(c),
201 d, e, f, g, h, i, j, k, l, m, n, o, a034
202 from t1
203 order by dummyKey;
204 a001 a010 a012 a015 a016 a017 a019 a030 a031 a032 a042 a043 a044 a3001 a3002 a3003 a3004 a3005 a3021 a3022 hex(a) hex(b) hex(c) d e f g h i j k l m n o a034
205 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 3F 3E 4 5 5 5 5 5 5 5 5 5 3 2 1
206 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 3D 4 5 5 5 5 5 5 5 5 5 3 2 1
207 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 F 3B 4 5 5 5 5 5 5 5 5 5 3 2 1
208 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 30 37 4 5 5 5 5 5 5 5 5 5 3 2 1
209 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 21 2F 4 5 5 5 5 5 5 5 5 5 3 2 1
210 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 12 1F 4 5 5 5 5 5 5 5 5 5 3 2 1
211 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C 3F 4 5 5 5 5 5 5 5 5 5 3 2 1
212 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3F 0 0 4 5 5 5 5 5 5 5 5 5 3 2 1
213 select a001, a010, a012, a015, a016, a017, a019, a029
214 a030, a031, a032, a042, a043, a044, a3001, a3002,
215 a3003, a3004, a3005, a3021, a3022, hex(a), hex(b), hex(c),
216 d, e, f, g, h, i, j, k, l, m, n, o, a034
217 from t1 where dummyKey = 1;
218 a001 a010 a012 a015 a016 a017 a019 a030 a031 a032 a042 a043 a044 a3001 a3002 a3003 a3004 a3005 a3021 a3022 hex(a) hex(b) hex(c) d e f g h i j k l m n o a034
219 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 3F 3E 4 5 5 5 5 5 5 5 5 5 3 2 1
220 drop table t1;
221 create table t1 (
222 pk1 bit(9) not null primary key,
223 b int
224 ) engine=ndbcluster;
225 ERROR HY000: Can't create table 't1' (use SHOW WARNINGS for more info).
226 show warnings;
227 Level Code Message
228 Warning 1296 Got error 906 'Unsupported attribute type in index' from NDB
229 Error 1005 Can't create table 't1' (use SHOW WARNINGS for more info).
230 create table t1 (
231 pk1 int not null primary key,
232 b bit(9),
233 key(b)
234 ) engine=ndbcluster;
235 ERROR HY000: Can't create table 't1' (use SHOW WARNINGS for more info).
236 show warnings;
237 Level Code Message
238 Warning 1296 Got error 906 'Unsupported attribute type in index' from NDB
239 Error 1005 Can't create table 't1' (use SHOW WARNINGS for more info).
240 create table t1 (
241 pk1 int primary key,
242 b bit(32) not null
243 ) engine=ndbcluster;
244 insert into t1 values (1,1);
245 drop table t1;
246 create table bigbits ( k int unsigned primary key, c1 bit(64), c2 bit(64), c3 bit(64), c4 bit(64), c5 bit(64), c6 bit(64), c7 bit(64), c8 bit(64), c9 bit(64), c10 bit(64), c11 bit(64), c12 bit(64), c13 bit(64), c14 bit(64), c15 bit(64), c16 bit(64), c17 bit(64), c18 bit(64), c19 bit(64), c20 bit(64), c21 bit(64), c22 bit(64), c23 bit(64), c24 bit(64), c25 bit(64), c26 bit(64), c27 bit(64), c28 bit(64), c29 bit(64), c30 bit(64), c31 bit(64), c32 bit(64), c33 bit(64), c34 bit(64), c35 bit(64), c36 bit(64), c37 bit(64), c38 bit(64), c39 bit(64), c40 bit(64), c41 bit(64), c42 bit(64), c43 bit(64), c44 bit(64), c45 bit(64), c46 bit(64), c47 bit(64), c48 bit(64), c49 bit(64), c50 bit(64), c51 bit(64), c52 bit(64), c53 bit(64), c54 bit(64), c55 bit(64), c56 bit(64), c57 bit(64), c58 bit(64), c59 bit(64), c60 bit(64), c61 bit(64), c62 bit(64), c63 bit(64), c64 bit(64), c65 bit(64), c66 bit(64), c67 bit(64), c68 bit(64), c69 bit(64), c70 bit(64), c71 bit(64), c72 bit(64), c73 bit(64), c74 bit(64), c75 bit(64), c76 bit(64), c77 bit(64), c78 bit(64), c79 bit(64), c80 bit(64), c81 bit(64), c82 bit(64), c83 bit(64), c84 bit(64), c85 bit(64), c86 bit(64), c87 bit(64), c88 bit(64), c89 bit(64), c90 bit(64), c91 bit(64), c92 bit(64), c93 bit(64), c94 bit(64), c95 bit(64), c96 bit(64), c97 bit(64), c98 bit(64), c99 bit(64), c100 bit(64), c101 bit(64), c102 bit(64), c103 bit(64), c104 bit(64), c105 bit(64), c106 bit(64), c107 bit(64), c108 bit(64), c109 bit(64), c110 bit(64), c111 bit(64), c112 bit(64), c113 bit(64), c114 bit(64), c115 bit(64), c116 bit(64), c117 bit(64), c118 bit(64), c119 bit(64), c120 bit(64), c121 bit(64), c122 bit(64), c123 bit(64), c124 bit(64), c125 bit(64), c126 bit(64)) engine=ndb;
247 ERROR HY000: Can't create table 'bigbits' (use SHOW WARNINGS for more info).
248 create table bigbits ( k int unsigned primary key, c1 bit(64) column_format
249 dynamic, c2 bit(64) column_format dynamic, c3 bit(64) column_format dynamic,
250 c4 bit(64) column_format dynamic, c5 bit(64) column_format dynamic, c6
251 bit(64) column_format dynamic, c7 bit(64) column_format dynamic, c8 bit(64)
252 column_format dynamic, c9 bit(64) column_format dynamic, c10 bit(64)
253 column_format dynamic, c11 bit(64) column_format dynamic, c12 bit(64)
254 column_format dynamic, c13 bit(64) column_format dynamic, c14 bit(64)
255 column_format dynamic, c15 bit(64) column_format dynamic, c16 bit(64)
256 column_format dynamic, c17 bit(64) column_format dynamic, c18 bit(64)
257 column_format dynamic, c19 bit(64) column_format dynamic, c20 bit(64)
258 column_format dynamic, c21 bit(64) column_format dynamic, c22 bit(64)
259 column_format dynamic, c23 bit(64) column_format dynamic, c24 bit(64)
260 column_format dynamic, c25 bit(64) column_format dynamic, c26 bit(64)
261 column_format dynamic, c27 bit(64) column_format dynamic, c28 bit(64)
262 column_format dynamic, c29 bit(64) column_format dynamic, c30 bit(64)
263 column_format dynamic, c31 bit(64) column_format dynamic, c32 bit(64)
264 column_format dynamic, c33 bit(64) column_format dynamic, c34 bit(64)
265 column_format dynamic, c35 bit(64) column_format dynamic, c36 bit(64)
266 column_format dynamic, c37 bit(64) column_format dynamic, c38 bit(64)
267 column_format dynamic, c39 bit(64) column_format dynamic, c40 bit(64)
268 column_format dynamic, c41 bit(64) column_format dynamic, c42 bit(64)
269 column_format dynamic, c43 bit(64) column_format dynamic, c44 bit(64)
270 column_format dynamic, c45 bit(64) column_format dynamic, c46 bit(64)
271 column_format dynamic, c47 bit(64) column_format dynamic, c48 bit(64)
272 column_format dynamic, c49 bit(64) column_format dynamic, c50 bit(64)
273 column_format dynamic, c51 bit(64) column_format dynamic, c52 bit(64)
274 column_format dynamic, c53 bit(64) column_format dynamic, c54 bit(64)
275 column_format dynamic, c55 bit(64) column_format dynamic, c56 bit(64)
276 column_format dynamic, c57 bit(64) column_format dynamic, c58 bit(64)
277 column_format dynamic, c59 bit(64) column_format dynamic, c60 bit(64)
278 column_format dynamic, c61 bit(64) column_format dynamic, c62 bit(64)
279 column_format dynamic, c63 bit(64) column_format dynamic) engine=ndb;
280 ERROR HY000: Can't create table 'bigbits' (use SHOW WARNINGS for more info).
281 show warnings;
282 Level Code Message
283 Warning 1296 Got error 791 'Too many total bits in bitfields' from NDB
284 Warning 1296 Failed to commit NDB schema transaction
285 Error 1005 Can't create table 'bigbits' (use SHOW WARNINGS for more info).