← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/archive_bitfield.test

  • Committer: Monty Taylor
  • Date: 2009-08-12 06:25:19 UTC
  • mto: (1114.1.1 innodb-plugin-merge)
  • mto: This revision was merged to the branch mainline in revision 1183.
  • Revision ID: mordred@inaugust.com-20090812062519-cij02mrrunvnxblt
Tags: innodb-plugin-1.0.4
InnoDB Plugin 1.0.4

Show diffs side-by-side

added added

removed removed

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