

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */;

USE `test`;
/*!50003 DROP PROCEDURE IF EXISTS `p1` */;
DELIMITER ;;
CREATE DEFINER="root"@"localhost" PROCEDURE "p1"()
AS
  r pkg1.rec0_t;
BEGIN r.a:=1; SELECT r.a; END
;;
DELIMITER ;
/*!50003 DROP PACKAGE IF EXISTS `pkg1` */;
DELIMITER ;;
CREATE DEFINER="root"@"localhost" PACKAGE "pkg1" AS
  TYPE rec0_t IS RECORD (a INT, b VARCHAR(30));
END
;;
DELIMITER ;

