DROP DATABASE IF EXISTS mem;
CREATE DATABASE mem;

USE mem;

CREATE TABLE t1 (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY(`id`)
)
ENGINE = MyISAM;

CREATE VIEW v1 AS SELECT * FROM t1;


DELIMITER //


DROP PROCEDURE IF EXISTS p1 //

CREATE PROCEDURE p1(IN  loops BIGINT(19) UNSIGNED)
BEGIN
	WHILE loops > 0 DO
          SELECT id FROM v1 WHERE id = 5;
	  SET loops = loops - 1;
	END WHILE;
END
//

DELIMITER ;

CALL p1(10000000);