几乎死循环的存储过程

测试用

create table test(num1 varchar(10),num2 varchar(100),num3 varchar(10));

drop procedure  test;

DELIMITER ;; 
CREATE PROCEDURE test() 
BEGIN 
DECLARE y varchar(100) DEFAULT 1;
WHILE y<=20000000
DO
insert into test(num1,num2,num3) values(y,y+1,y+2); 
SET y=y+1; 
END WHILE ; 
commit; 
END;; 

ALTER TABLE `test`.`test` ADD UNIQUE INDEX `test` (`num1` , `num2` );
ALTER TABLE `test`.`test` ADD UNIQUE INDEX `test1` (`num1`);
ALTER TABLE `test`.`test` ADD PRIMARY KEY (`num1`);

CALL test();

MySQL 8.0.18 MGR测试下，test表无主键，报以下错误

ERROR 3098 (HY000): The table does not comply with the requirements by an external plugin.
修改建表语句如下：
create table test(num1 varchar(10),num2 varchar(100),num3 varchar(10), PRIMARY KEY (num1));