1
-- source include/have_ndb.inc
2
-- source include/not_embedded.inc
5
drop table if exists t1;
9
pk1 int not null primary key,
15
(0,b'1111111111111111111111111111111111111111111111111111111111111111'),
16
(1,b'1000000000000000000000000000000000000000000000000000000000000000'),
17
(2,b'0000000000000000000000000000000000000000000000000000000000000001'),
18
(3,b'1010101010101010101010101010101010101010101010101010101010101010'),
19
(4,b'0101010101010101010101010101010101010101010101010101010101010101');
20
select hex(b) from t1 order by pk1;
24
pk1 int not null primary key,
33
select hex(b) from t1 order by pk1;
34
update t1 set b = b + b'101010101';
35
select hex(b) from t1 order by pk1;
38
create table t1 (a bit(7), b bit(9)) engine = ndbcluster;
40
(94, 46), (31, 438), (61, 152), (78, 123), (88, 411), (122, 118), (0, 177),
41
(75, 42), (108, 67), (79, 349), (59, 188), (68, 206), (49, 345), (118, 380),
42
(111, 368), (94, 468), (56, 379), (77, 133), (29, 399), (9, 363), (23, 36),
43
(116, 390), (119, 368), (87, 351), (123, 411), (24, 398), (34, 202), (28, 499),
44
(30, 83), (5, 178), (60, 343), (4, 245), (104, 280), (106, 446), (127, 403),
45
(44, 307), (68, 454), (57, 135);
46
select a+0 from t1 order by a;
47
select b+0 from t1 order by b;
51
dummyKey INTEGER NOT NULL,
89
PRIMARY KEY USING HASH (dummyKey) ) engine=ndb;
90
INSERT INTO `t1` VALUES
91
(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),
92
(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),
93
(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),
94
(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),
95
(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),
96
(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),
97
(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),
98
(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);
99
--exec $MYSQL_DUMP --hex-blob --compact --order-by-primary --skip-extended-insert --no-create-info test t1
104
pk1 bit(9) not null primary key,
111
pk1 int not null primary key,
123
insert into t1 values (1,1);