RESET MASTER;
CREATE TABLE t(f text);
INSERT INTO t VALUES (repeat('x',4096));
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
SELECT COUNT(*) FROM t;
COUNT(*)
512
FLUSH LOGS;
DROP TABLE t;
# 512- Rows must be present
include/assert.inc [Table t should have 512 rows.]
DROP TABLE t;
RESET MASTER;