CREATE OR REPLACE TABLE t1 (a BIGINT DEFAULT 100000000000) ENGINE=HEAP;
DELIMITER $$
BEGIN NOT ATOMIC
  FOR i IN 1..1000*1000 DO
    INSERT INTO t1 VALUES (DEFAULT);
  END FOR;
END;
$$
DELIMITER ;
