| 1 |
--source include/have_ndb.inc |
| 2 |
--source include/have_binlog_format_mixed_or_row.inc |
| 3 |
--source suite/ndb_rpl/ndb_master-slave.inc |
| 4 |
|
| 5 |
# |
| 6 |
# Verifies replication of bit fields |
| 7 |
# |
| 8 |
|
| 9 |
--connection master |
| 10 |
create table t1 ( pk int not null auto_increment primary key, b0 bit(64) not null, b1 bit(64) not null, b2 bit(64) not null, b3 |
| 11 |
bit(64) not null, b4 bit(64) not null, b5 bit(64) not null, b6 bit(64) not null, b7 bit(64) not null, b8 bit(64) not null, b9 bit(64) not null, b10 |
| 12 |
bit(64) not null, b11 bit(64) not null, b12 bit(64) not null, b13 bit(64) not null, b14 bit(64) not null, b15 bit(64) not null, b16 bit(64), |
| 13 |
b17 bit(64) not null, b18 bit(64) not null, b19 bit(64) not null, b20 bit(64) not null, b21 bit(64) not null, b22 bit(64) not null, b23 |
| 14 |
bit(64) not null, b24 bit(64) not null, b25 bit(64) not null, b26 bit(64) not null, b27 bit(64) not null, b28 bit(64) not null, b29 bit(64), |
| 15 |
b30 bit(64) not null, b31 bit(64) not null, b32 bit(64) not null, b33 bit(64) not null, b34 bit(64) not null, b35 bit(64) not null, b36 |
| 16 |
bit(64) not null, b37 bit(64) not null, b38 bit(64) not null, b39 bit(64) not null, b40 bit(64) not null, b41 bit(64) not null, b42 bit(64), |
| 17 |
b43 bit(64) not null, b44 bit(64) not null, b45 bit(64) not null, b46 bit(64) not null, b47 bit(64) not null, b48 bit(64) not null, b49 |
| 18 |
bit(64) not null, b50 bit(64) not null, b51 bit(64) not null, b52 bit(64) not null, b53 bit(64) not null, b54 bit(64) not null, b55 bit(64), |
| 19 |
b56 bit(64) not null, b57 bit(64) not null, b58 bit(64) not null, b59 bit(64) not null) engine=ndb; |
| 20 |
|
| 21 |
insert into t1 |
| 22 |
(b0,b1,b2,b3,b4,b5,b6,b7,b8,b9, |
| 23 |
b10,b11,b12,b13,b14,b15,b16,b17,b18,b19, |
| 24 |
b20,b21,b22,b23,b24,b25,b26,b27,b28,b29, |
| 25 |
b30,b31,b32,b33,b34,b35,b36,b37,b38,b39, |
| 26 |
b40,b41,b42,b43,b44,b45,b46,b47,b48,b49, |
| 27 |
b50,b51,b52,b53,b54,b55,b56,b57,b58,b59 |
| 28 |
) values |
| 29 |
( |
| 30 |
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000', |
| 31 |
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000', |
| 32 |
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000', |
| 33 |
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000', |
| 34 |
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000', |
| 35 |
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000' |
| 36 |
), |
| 37 |
( |
| 38 |
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF', |
| 39 |
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF', |
| 40 |
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF', |
| 41 |
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF', |
| 42 |
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF', |
| 43 |
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF' |
| 44 |
), |
| 45 |
( |
| 46 |
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000', |
| 47 |
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000', |
| 48 |
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000', |
| 49 |
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000', |
| 50 |
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000', |
| 51 |
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000' |
| 52 |
), |
| 53 |
( |
| 54 |
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF', |
| 55 |
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF', |
| 56 |
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF', |
| 57 |
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF', |
| 58 |
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF', |
| 59 |
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF' |
| 60 |
) |
| 61 |
; |
| 62 |
|
| 63 |
--sync_slave_with_master |
| 64 |
select pk, |
| 65 |
hex(b0),hex(b1),hex(b2),hex(b3),hex(b4),hex(b5),hex(b6),hex(b7),hex(b8),hex(b9), |
| 66 |
hex(b10),hex(b11),hex(b12),hex(b13),hex(b14),hex(b15),hex(b16),hex(b17),hex(b18),hex(b19), |
| 67 |
hex(b20),hex(b21),hex(b22),hex(b23),hex(b24),hex(b25),hex(b26),hex(b27),hex(b28),hex(b29), |
| 68 |
hex(b30),hex(b31),hex(b32),hex(b33),hex(b34),hex(b35),hex(b36),hex(b37),hex(b38),hex(b39), |
| 69 |
hex(b40),hex(b41),hex(b42),hex(b43),hex(b44),hex(b45),hex(b46),hex(b47),hex(b48),hex(b49), |
| 70 |
hex(b50),hex(b51),hex(b52),hex(b53),hex(b54),hex(b55),hex(b56),hex(b57),hex(b58),hex(b59) |
| 71 |
from t1 order by pk; |
| 72 |
|
| 73 |
--connection master |
| 74 |
update t1 set b5 = X'0F0F0F0F0F0F0F0F', b15 = X'F0F0F0F0F0F0F0F0', b25 = X'0F0F0F0F0F0F0F0F', b35 = X'F0F0F0F0F0F0F0F0', b45 = X'0F0F0F0F0F0F0F0F', b55 = X'F0F0F0F0F0F0F0F0'; |
| 75 |
|
| 76 |
--sync_slave_with_master |
| 77 |
select pk, |
| 78 |
hex(b0),hex(b1),hex(b2),hex(b3),hex(b4),hex(b5),hex(b6),hex(b7),hex(b8),hex(b9), |
| 79 |
hex(b10),hex(b11),hex(b12),hex(b13),hex(b14),hex(b15),hex(b16),hex(b17),hex(b18),hex(b19), |
| 80 |
hex(b20),hex(b21),hex(b22),hex(b23),hex(b24),hex(b25),hex(b26),hex(b27),hex(b28),hex(b29), |
| 81 |
hex(b30),hex(b31),hex(b32),hex(b33),hex(b34),hex(b35),hex(b36),hex(b37),hex(b38),hex(b39), |
| 82 |
hex(b40),hex(b41),hex(b42),hex(b43),hex(b44),hex(b45),hex(b46),hex(b47),hex(b48),hex(b49), |
| 83 |
hex(b50),hex(b51),hex(b52),hex(b53),hex(b54),hex(b55),hex(b56),hex(b57),hex(b58),hex(b59) |
| 84 |
from t1 order by pk; |
| 85 |
|
| 86 |
--connection master |
| 87 |
DROP TABLE t1; |
| 88 |
|
| 89 |
-- source include/rpl_end.inc |