1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
drop schema if exists bug23012;
create schema bug23012;
use bug23012;
CREATE TABLE `tab` (
`id` INTEGER
)
ENGINE = INNODB;
DELIMITER $$
DROP PROCEDURE IF EXISTS `a` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `a`(IN a INT)
BEGIN
select a from dual;
insert into tab values(a);
END $$
DELIMITER ;
DELIMITER $$
DROP PROCEDURE IF EXISTS `b` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `b`(IN b INT)
BEGIN
select b from dual;
insert into tab values(b);
END $$
DELIMITER ;
|
