1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
-- source include/have_archive.inc
-- source include/have_binlog_format_mixed_or_statement.inc
--disable_warnings
drop table if exists t1;
--enable_warnings
create table t1 (
pk1 int not null auto_increment primary key,
b bit(64)
) engine=archive;
show create table t1;
insert into t1 values
(NULL,b'1111111111111111111111111111111111111111111111111111111111111111'),
(NULL,b'1000000000000000000000000000000000000000000000000000000000000000'),
(NULL,b'0000000000000000000000000000000000000000000000000000000000000001'),
(NULL,b'1010101010101010101010101010101010101010101010101010101010101010'),
(NULL,b'0101010101010101010101010101010101010101010101010101010101010101');
select hex(b) from t1 order by pk1;
drop table t1;
create table t1 (
pk1 int not null auto_increment primary key,
b bit(9)
) engine=archive;
insert into t1 values
(NULL,b'000000000'),
(NULL,b'000000001'),
(NULL,b'000000010'),
(NULL,b'000000011'),
(NULL,b'000000100');
select hex(b) from t1 order by pk1;
drop table t1;
create table t1 (a bit(7), b bit(9)) engine = archive;
insert into t1 values
(94, 46), (31, 438), (61, 152), (78, 123), (88, 411), (122, 118), (0, 177),
(75, 42), (108, 67), (79, 349), (59, 188), (68, 206), (49, 345), (118, 380),
(111, 368), (94, 468), (56, 379), (77, 133), (29, 399), (9, 363), (23, 36),
(116, 390), (119, 368), (87, 351), (123, 411), (24, 398), (34, 202), (28, 499),
(30, 83), (5, 178), (60, 343), (4, 245), (104, 280), (106, 446), (127, 403),
(44, 307), (68, 454), (57, 135);
select a+0 from t1 order by a;
select b+0 from t1 order by b;
drop table t1;
create table t1 (
dummyKey INTEGER NOT NULL AUTO_INCREMENT,
a001 int,
a010 int,
a012 int,
a015 int,
a016 int,
a017 int,
a019 int,
a029 int,
a030 int,
a031 int,
a032 int,
a042 int,
a043 int,
a044 int,
a3001 int,
a3002 int,
a3003 int,
a3004 int,
a3005 int,
a3021 int,
a3022 int,
a BIT(6),
b BIT(6),
c BIT(6),
d int,
e int,
f int,
g int,
h int,
i int,
j int,
k int,
l int,
m int,
n int,
o int,
a034 int,
PRIMARY KEY USING HASH (dummyKey) ) engine=archive;
INSERT INTO `t1` VALUES
(NULL,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),
(NULL,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),
(NULL,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),
(NULL,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),
(NULL,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),
(NULL,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),
(NULL,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),
(NULL,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);
--exec $DRIZZLE_DUMP --hex-blob --compact --order-by-primary --skip-extended-insert --no-create-info test t1
drop table t1;
|