1
drop table if exists t1;
3
pk1 int not null primary key,
9
`pk1` int(11) NOT NULL,
10
`b` bit(64) DEFAULT NULL,
12
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
14
(0,b'1111111111111111111111111111111111111111111111111111111111111111'),
15
(1,b'1000000000000000000000000000000000000000000000000000000000000000'),
16
(2,b'0000000000000000000000000000000000000000000000000000000000000001'),
17
(3,b'1010101010101010101010101010101010101010101010101010101010101010'),
18
(4,b'0101010101010101010101010101010101010101010101010101010101010101');
19
select hex(b) from t1 order by pk1;
28
pk1 int not null primary key,
37
select hex(b) from t1 order by pk1;
44
update t1 set b = b + b'101010101';
45
select hex(b) from t1 order by pk1;
53
create table t1 (a bit(7), b bit(9)) engine = ndbcluster;
55
(94, 46), (31, 438), (61, 152), (78, 123), (88, 411), (122, 118), (0, 177),
56
(75, 42), (108, 67), (79, 349), (59, 188), (68, 206), (49, 345), (118, 380),
57
(111, 368), (94, 468), (56, 379), (77, 133), (29, 399), (9, 363), (23, 36),
58
(116, 390), (119, 368), (87, 351), (123, 411), (24, 398), (34, 202), (28, 499),
59
(30, 83), (5, 178), (60, 343), (4, 245), (104, 280), (106, 446), (127, 403),
60
(44, 307), (68, 454), (57, 135);
61
select a+0 from t1 order by a;
101
select b+0 from t1 order by b;
143
dummyKey INTEGER NOT NULL,
181
PRIMARY KEY USING HASH (dummyKey) ) engine=ndb;
182
INSERT INTO `t1` VALUES
183
(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),
184
(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),
185
(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),
186
(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),
187
(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),
188
(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),
189
(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),
190
(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);
191
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);
192
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);
193
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);
194
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);
195
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);
196
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);
197
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);
198
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);
201
pk1 bit(9) not null primary key,
204
ERROR HY000: Can't create table 'test.t1' (errno: 906)
207
Error 1296 Got error 906 'Unsupported attribute type in index' from NDB
208
Error 1005 Can't create table 'test.t1' (errno: 906)
210
pk1 int not null primary key,
214
ERROR HY000: Can't create table 'test.t1' (errno: 906)
217
Error 1296 Got error 906 'Unsupported attribute type in index' from NDB
218
Error 1005 Can't create table 'test.t1' (errno: 906)
223
insert into t1 values (1,1);