[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@18.221.175.172: ~ $ 
--source include/have_ndb.inc
--source include/have_binlog_format_mixed_or_row.inc
--source suite/ndb_rpl/ndb_master-slave.inc

#
# Verifies replication of bit fields
#

--connection master
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
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
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),
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
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),
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
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),
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
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),
b56 bit(64) not null, b57 bit(64) not null, b58 bit(64) not null, b59 bit(64) not null) engine=ndb;

insert into t1
(b0,b1,b2,b3,b4,b5,b6,b7,b8,b9,
b10,b11,b12,b13,b14,b15,b16,b17,b18,b19,
b20,b21,b22,b23,b24,b25,b26,b27,b28,b29,
b30,b31,b32,b33,b34,b35,b36,b37,b38,b39,
b40,b41,b42,b43,b44,b45,b46,b47,b48,b49,
b50,b51,b52,b53,b54,b55,b56,b57,b58,b59
) values 
(
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',
X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000',X'0000000000000000'
),
(
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',
X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF',X'FFFFFFFFFFFFFFFF'
),
(
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',
X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000',X'FFFFFFFF00000000'
),
(
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',
X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF',X'00000000FFFFFFFF'
)
;

--sync_slave_with_master
select pk,
hex(b0),hex(b1),hex(b2),hex(b3),hex(b4),hex(b5),hex(b6),hex(b7),hex(b8),hex(b9),
hex(b10),hex(b11),hex(b12),hex(b13),hex(b14),hex(b15),hex(b16),hex(b17),hex(b18),hex(b19),
hex(b20),hex(b21),hex(b22),hex(b23),hex(b24),hex(b25),hex(b26),hex(b27),hex(b28),hex(b29),
hex(b30),hex(b31),hex(b32),hex(b33),hex(b34),hex(b35),hex(b36),hex(b37),hex(b38),hex(b39),
hex(b40),hex(b41),hex(b42),hex(b43),hex(b44),hex(b45),hex(b46),hex(b47),hex(b48),hex(b49),
hex(b50),hex(b51),hex(b52),hex(b53),hex(b54),hex(b55),hex(b56),hex(b57),hex(b58),hex(b59)
 from t1 order by pk;

--connection master
update t1 set b5 = X'0F0F0F0F0F0F0F0F', b15 = X'F0F0F0F0F0F0F0F0', b25 = X'0F0F0F0F0F0F0F0F', b35 = X'F0F0F0F0F0F0F0F0', b45 = X'0F0F0F0F0F0F0F0F', b55 = X'F0F0F0F0F0F0F0F0';

--sync_slave_with_master
select pk,
hex(b0),hex(b1),hex(b2),hex(b3),hex(b4),hex(b5),hex(b6),hex(b7),hex(b8),hex(b9),
hex(b10),hex(b11),hex(b12),hex(b13),hex(b14),hex(b15),hex(b16),hex(b17),hex(b18),hex(b19),
hex(b20),hex(b21),hex(b22),hex(b23),hex(b24),hex(b25),hex(b26),hex(b27),hex(b28),hex(b29),
hex(b30),hex(b31),hex(b32),hex(b33),hex(b34),hex(b35),hex(b36),hex(b37),hex(b38),hex(b39),
hex(b40),hex(b41),hex(b42),hex(b43),hex(b44),hex(b45),hex(b46),hex(b47),hex(b48),hex(b49),
hex(b50),hex(b51),hex(b52),hex(b53),hex(b54),hex(b55),hex(b56),hex(b57),hex(b58),hex(b59)
 from t1 order by pk;

--connection master
DROP TABLE t1;

-- source include/rpl_end.inc

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ ndb_rpl/ t/
Name Type Size Permission Actions
disabled.def File 688 B 0644
ndb_apply_status.frm File 8.51 KB 0644
ndb_conflict_info.inc File 1013 B 0644
ndb_conflict_info_init.inc File 692 B 0644
ndb_rpl_2innodb-master.opt File 32 B 0644
ndb_rpl_2innodb-slave.opt File 56 B 0644
ndb_rpl_2innodb.test File 1.63 KB 0644
ndb_rpl_2multi_basic.inc File 3.42 KB 0644
ndb_rpl_2multi_eng.inc File 10.33 KB 0644
ndb_rpl_2myisam-master.opt File 25 B 0644
ndb_rpl_2myisam-slave.opt File 47 B 0644
ndb_rpl_2myisam.test File 1.6 KB 0644
ndb_rpl_2ndb-slave.opt File 58 B 0644
ndb_rpl_2ndb.test File 648 B 0644
ndb_rpl_2other-slave.opt File 54 B 0644
ndb_rpl_2other.test File 2.18 KB 0644
ndb_rpl_add_column.test File 3.56 KB 0644
ndb_rpl_apply_status-master.opt File 28 B 0644
ndb_rpl_apply_status.test File 1.29 KB 0644
ndb_rpl_auto_inc.test File 3.98 KB 0644
ndb_rpl_bank.test File 6.47 KB 0644
ndb_rpl_basic.test File 11.29 KB 0644
ndb_rpl_binlog_format_errors.test File 3.26 KB 0644
ndb_rpl_bitfield.test File 7.9 KB 0644
ndb_rpl_blob.test File 3.91 KB 0644
ndb_rpl_break_3_chain.cnf File 1.71 KB 0644
ndb_rpl_break_3_chain.test File 3.53 KB 0644
ndb_rpl_bug22045.test File 2.2 KB 0644
ndb_rpl_check_for_mixed.test File 804 B 0644
ndb_rpl_circular.test File 4.21 KB 0644
ndb_rpl_circular_2ch.cnf File 878 B 0644
ndb_rpl_circular_2ch.test File 4.21 KB 0644
ndb_rpl_circular_2ch_rep_status.cnf File 183 B 0644
ndb_rpl_circular_2ch_rep_status.test File 9.01 KB 0644
ndb_rpl_circular_simplex.test File 2.22 KB 0644
ndb_rpl_conflict.test File 9.99 KB 0644
ndb_rpl_conflict_1.inc File 5.15 KB 0644
ndb_rpl_conflict_epoch.cnf File 561 B 0644
ndb_rpl_conflict_epoch.test File 6.86 KB 0644
ndb_rpl_conflict_epoch_1.inc File 12.36 KB 0644
ndb_rpl_conflict_max-master.opt File 28 B 0644
ndb_rpl_conflict_max.test File 2.83 KB 0644
ndb_rpl_conflict_max_delete_win-master.opt File 28 B 0644
ndb_rpl_conflict_max_delete_win.test File 2.86 KB 0644
ndb_rpl_conflict_old-master.opt File 28 B 0644
ndb_rpl_conflict_old.test File 2.83 KB 0644
ndb_rpl_ctype_ucs2_def-master.opt File 70 B 0644
ndb_rpl_ctype_ucs2_def.test File 1.13 KB 0644
ndb_rpl_dd_advance.test File 10.04 KB 0644
ndb_rpl_dd_basic.test File 1.38 KB 0644
ndb_rpl_dd_partitions-master.opt File 11 B 0644
ndb_rpl_dd_partitions-slave.opt File 11 B 0644
ndb_rpl_dd_partitions.test File 8.53 KB 0644
ndb_rpl_do_db-slave.opt File 26 B 0644
ndb_rpl_do_db.test File 1.52 KB 0644
ndb_rpl_do_table-slave.opt File 29 B 0644
ndb_rpl_do_table.test File 1.21 KB 0644
ndb_rpl_empty_epoch.test File 934 B 0644
ndb_rpl_gap_event-master.opt File 24 B 0644
ndb_rpl_gap_event.test File 1.52 KB 0644
ndb_rpl_get_binlog_events.inc File 1.09 KB 0644
ndb_rpl_idempotent.test File 2.95 KB 0644
ndb_rpl_ignore_db-master.opt File 25 B 0644
ndb_rpl_ignore_db.test File 1.07 KB 0644
ndb_rpl_init_rep_status.test File 2.95 KB 0644
ndb_rpl_innodb2ndb-master.opt File 9 B 0644
ndb_rpl_innodb2ndb-slave.opt File 42 B 0644
ndb_rpl_innodb2ndb.test File 714 B 0644
ndb_rpl_innodb_trans-slave.opt File 34 B 0644
ndb_rpl_innodb_trans.test File 1.54 KB 0644
ndb_rpl_load.test File 2.34 KB 0644
ndb_rpl_logging.test File 3.76 KB 0644
ndb_rpl_mix_eng_trans-master.opt File 9 B 0644
ndb_rpl_mix_eng_trans-slave.opt File 9 B 0644
ndb_rpl_mix_eng_trans.test File 8.84 KB 0644
ndb_rpl_mix_innodb-master.opt File 41 B 0644
ndb_rpl_mix_innodb.test File 533 B 0644
ndb_rpl_mixed_tables-master.opt File 22 B 0644
ndb_rpl_mixed_tables-slave.opt File 70 B 0644
ndb_rpl_mixed_tables.test File 8.35 KB 0644
ndb_rpl_multi.test File 2.68 KB 0644
ndb_rpl_multi_binlog_update.cnf File 1.85 KB 0644
ndb_rpl_multi_binlog_update.inc File 6.78 KB 0644
ndb_rpl_multi_update2-slave.opt File 42 B 0644
ndb_rpl_myisam2ndb-slave.opt File 42 B 0644
ndb_rpl_myisam2ndb.test File 672 B 0644
ndb_rpl_ndbapi_multi.test File 614 B 0644
ndb_rpl_relayrotate-slave.opt File 57 B 0644
ndb_rpl_rep_error.test File 2.29 KB 0644
ndb_rpl_rep_ignore-slave.opt File 63 B 0644
ndb_rpl_rep_ignore.test File 1.58 KB 0644
ndb_rpl_skip_gap_event-slave.opt File 24 B 0644
ndb_rpl_skip_gap_event.test File 1.65 KB 0644
ndb_rpl_slave_lsu.cnf File 57 B 0644
ndb_rpl_slave_lsu.test File 5.66 KB 0644
ndb_rpl_slave_lsu_anyval.cnf File 176 B 0644
ndb_rpl_slave_lsu_anyval.test File 2.25 KB 0644
ndb_rpl_slave_restart.test File 2.87 KB 0644
ndb_rpl_stm_innodb-master.opt File 41 B 0644
ndb_rpl_stm_innodb.test File 622 B 0644
ndb_rpl_sync.test File 3.02 KB 0644
ndb_rpl_ui.test File 1.2 KB 0644
ndb_rpl_ui2.test File 747 B 0644
ndb_rpl_ui3.test File 1.3 KB 0644
ndb_rpl_xxx_innodb.inc File 6.22 KB 0644
rpl_truncate_7ndb.test File 1.58 KB 0644
rpl_truncate_7ndb_2.test File 383 B 0644
select_ndb_apply_status.inc File 505 B 0644
wait_schema_logging.inc File 2.33 KB 0644