File: test_m5_t15_1.sql

package info (click to toggle)
mysql-gui-tools 5.0r12-1
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 105,540 kB
  • ctags: 50,897
  • sloc: sql: 348,439; pascal: 285,780; cpp: 94,578; ansic: 90,768; objc: 33,761; sh: 25,629; xml: 10,924; yacc: 10,755; java: 9,986; php: 2,806; python: 2,068; makefile: 1,945; perl: 3
file content (30 lines) | stat: -rw-r--r-- 520 bytes parent folder | download | duplicates (2) 
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 ;