-- source include/have_ndb.inc
-- source include/master-slave.inc
connection slave;
-- source include/have_innodb.inc
connection master;
SET storage_engine=ndb;

DROP TABLE IF EXISTS t1;

#CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc VARCHAR(255),
#                 bc CHAR(255), d DECIMAL(10,4) DEFAULT 0,
#                 f FLOAT DEFAULT 0, total BIGINT UNSIGNED,
#                 y YEAR, t DATE,PRIMARY KEY(id));

CREATE TABLE t1 (id INT NOT NULL, b1 BIT(8), vc VARCHAR(255),
                 bc CHAR(255), d DECIMAL(10,4) DEFAULT 0,
                 f FLOAT DEFAULT 0, total BIGINT UNSIGNED,
                 y YEAR, t DATE,PRIMARY KEY(id))
                 PARTITION BY KEY();
#                 PARTITIONS 4;

INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ',
                      'Must make it bug free for the customer',
                       654321.4321,15.21,0,1965,"1905-11-14");
INSERT INTO t1 VALUES(2,1,'Testing MySQL databases is a cool ',
                      'Must make it bug free for the customer',
                       654321.4321,15.21,0,1965,"1965-11-14");
INSERT INTO t1 VALUES(4,1,'Testing MySQL databases is a cool ',
                      'Must make it bug free for the customer',
                       654321.4321,15.21,0,1965,"1985-11-14");
INSERT INTO t1 VALUES(142,1,'Testing MySQL databases is a cool ',
                      'Must make it bug free for the customer',
                       654321.4321,15.21,0,1965,"1995-11-14");
INSERT INTO t1 VALUES(412,1,'Testing MySQL databases is a cool ',
                      'Must make it bug free for the customer',
                       654321.4321,15.21,0,1965,"2005-11-14");


DELETE FROM t1 WHERE id = 42;

--echo
--echo --- Show current count on master for t1 ---
--echo

SELECT COUNT(*) FROM t1;

sync_slave_with_master;

--echo
--echo --- Show current count on slave for t1 ---
--echo

SELECT COUNT(*) FROM t1;

connection master;
--echo
DROP TABLE t1;
--echo
sync_slave_with_master;