Debian Codegraph @

mysql-test/suite/galera/t/galera_create_procedure.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test CREATE PROCEDURE
6 #
7
8 --connection node_1
9 CREATE USER 'user1';
10 GRANT ALL ON test.* to 'user1';
11 CREATE TABLE t1 (f1 INTEGER);
12
13 CREATE
14 DEFINER = 'user1'
15 PROCEDURE p1 (IN param1 INTEGER, OUT param2 INTEGER, INOUT param3 INTEGER)
16 COMMENT 'p1_comment'
17 LANGUAGE SQL
18 NOT DETERMINISTIC
19 MODIFIES SQL DATA
20 SQL SECURITY DEFINER
21 INSERT INTO t1 VALUES (1);
22 GRANT EXECUTE ON PROCEDURE p1 TO user1;
23
24 CREATE
25 DEFINER = CURRENT_USER
26 PROCEDURE p2 (param VARCHAR(100))
27 DETERMINISTIC
28 NO SQL
29 SQL SECURITY INVOKER BEGIN END ;
30
31 --connection node_1
32 SHOW CREATE PROCEDURE p1;
33
34 --connection node_2
35 # Perform causal wait
36 SELECT 1 FROM DUAL;
37 SHOW CREATE PROCEDURE p1;
38
39 --connection node_1
40 SHOW CREATE PROCEDURE p2;
41
42 --connection node_2
43 SHOW CREATE PROCEDURE p2;
44
45 CALL p1(@a, @b, @c);
46 CALL p2('abc');
47
48 --connection node_1
49 DROP PROCEDURE p1;
50 DROP PROCEDURE p2;
51
52 DROP USER 'user1';
53 DROP TABLE t1;