--source include/have_ndb.inc --source include/have_binlog_format_mixed_or_row.inc --source suite/ndb_rpl/ndb_master-slave.inc # InnoDB CREATE TABLE t1_innodb (b1 BIT, b2 BIT); # 1 high bit per column CREATE TABLE t1_ndb (c1 BIT, c2 BIT) ENGINE = NDB; # d1 = 2 high bits, d2 = 1 high bit, d3 = 1 high bit CREATE TABLE t2 (d1 BIT(2), d2 BIT, d3 BIT) ENGINE = NDB; # PK and 1 high bit per column CREATE TABLE t3 (a INT PRIMARY KEY, e1 BIT, e2 BIT) ENGINE = NDB; # Only 1 high bit per NOT NULL, null bit and high bit for the rest CREATE TABLE t4 (f1 BIT, f2 BIT NOT NULL, f3 BIT NOT NULL, f4 BIT NOT NULL, f5 BIT) ENGINE = NDB; # PK, 1 null and 6 high bits (full null flag byte) CREATE TABLE t5 (a INT PRIMARY KEY, g1 BIT(6)) ENGINE = NDB; # Insert data INSERT INTO t1_innodb VALUES (1, 1); INSERT INTO t1_ndb VALUES (1, 1); INSERT INTO t2 VALUES (3, 1, 1); INSERT INTO t3 VALUES (1, 1, 1); INSERT INTO t4 VALUES (1, 1, 1, 1, 1); INSERT INTO t5 VALUES (1, 63); --source include/sync_slave_sql_with_master.inc --source include/rpl_connection_master.inc UPDATE t1_innodb SET b1 = NULL WHERE b2 = 1; UPDATE t1_ndb SET c1 = NULL WHERE c2 = 1; UPDATE t2 SET d1 = NULL WHERE d3 = 1; UPDATE t3 SET e1 = NULL WHERE a = 1; UPDATE t4 SET f1 = NULL, f5 = NULL WHERE f2 = 1; UPDATE t5 SET g1 = NULL WHERE a = 1; --source include/sync_slave_sql_with_master.inc SELECT * FROM t1_ndb; SELECT * FROM t1_innodb; SELECT * FROM t2; SELECT * FROM t3; SELECT * FROM t4; SELECT * FROM t5; --source include/rpl_connection_master.inc DELETE FROM t1_innodb WHERE b2 = 1 LIMIT 1; --source include/sync_slave_sql_with_master.inc SELECT * FROM t1_innodb; --source include/rpl_connection_master.inc DELETE FROM t1_ndb WHERE c2 = 1 LIMIT 1; --source include/sync_slave_sql_with_master.inc SELECT * FROM t1_ndb; --source include/rpl_connection_master.inc DELETE FROM t2 WHERE d2 = 1 LIMIT 1; --source include/sync_slave_sql_with_master.inc SELECT * FROM t2; --source include/rpl_connection_master.inc DELETE FROM t3 WHERE a = 1 LIMIT 1; --source include/sync_slave_sql_with_master.inc SELECT * FROM t3; --source include/rpl_connection_master.inc DELETE FROM t4 WHERE f2 = 1 LIMIT 1; --source include/sync_slave_sql_with_master.inc SELECT * FROM t4; --source include/rpl_connection_master.inc DELETE FROM t5 WHERE a = 1 LIMIT 1; --source include/sync_slave_sql_with_master.inc SELECT * FROM t5; --source include/rpl_connection_master.inc DROP TABLE t1_innodb; DROP TABLE t1_ndb; DROP TABLE t2; DROP TABLE t3; DROP TABLE t4; DROP TABLE t5; --echo Cleanup --source include/rpl_end.inc