几乎死循环的存储过程

测试用

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));