AwkPMrvJ

1DROP TABLE IF EXISTS `test_table`;
2CREATE TABLE `test_table` (
3  `id` int NOT NULL AUTO_INCREMENT,
4  `name` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
5  PRIMARY KEY (`id`)
6) ENGINE=InnoDB;
7
8DROP TABLE IF EXISTS `yoyo_lock`;
9CREATE TABLE `yoyo_lock` (
10  `locked` int NOT NULL DEFAULT '1',
11  `ctime` timestamp NULL DEFAULT NULL,
12  `pid` int NOT NULL,
13  PRIMARY KEY (`locked`)
14) ENGINE=InnoDB;
15
16DELIMITER ;;
17CREATE DEFINER=`root`@`%` FUNCTION `test_function`() RETURNS int
18    READS SQL DATA
19    DETERMINISTIC
20begin
21	declare test_var int default 1;
22	repeat
23		set test_var = test_var + 1;
24	until test_var < 10 end repeat;
25	return test_var;
26end ;;
27
28CREATE DEFINER=`root`@`%` PROCEDURE `test_procedure`()
29begin
30	declare test_var int default 1;
31	repeat
32		set test_var = test_var + 1;
33	until test_var < 10 end repeat;
34end ;;
35DELIMITER ;