DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT, msg VARCHAR(255)) ENGINE=NDB;

INSERT INTO t1 SELECT 0, MD5(RAND());

INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1;

-- INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1; -- this one would run out of op records

-- so we now limit the number of rows

INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;
INSERT INTO t1 SELECT 0, MD5(RAND()) FROM t1 LIMIT 30000;