mysql存储过程事务回滚

SQL进程代码：

DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `test_procedure`()
BEGIN
	DECLARE errno int;
	declare continue HANDLER for sqlexception
begin 
	rollback;
	set errno=1;
end;
	start transaction;
	set errno=0;
	insert into test(name) values ("kaka");
	insert into test(id, name) values(1,"papa");
	commit;
	select errno;
ENDDELIMITER $$

CREATE DEFINER=`root`@`loc