Debian Codegraph @

mysql-test/suite/galera/r/galera_create_procedure.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE USER 'user1';
5 GRANT ALL ON test.* to 'user1';
6 CREATE TABLE t1 (f1 INTEGER);
7 CREATE
8 DEFINER = 'user1'
9 PROCEDURE p1 (IN param1 INTEGER, OUT param2 INTEGER, INOUT param3 INTEGER)
10 COMMENT 'p1_comment'
11 LANGUAGE SQL
12 NOT DETERMINISTIC
13 MODIFIES SQL DATA
14 SQL SECURITY DEFINER
15 INSERT INTO t1 VALUES (1);
16 GRANT EXECUTE ON PROCEDURE p1 TO user1;
17 CREATE
18 DEFINER = CURRENT_USER
19 PROCEDURE p2 (param VARCHAR(100))
20 DETERMINISTIC
21 NO SQL
22 SQL SECURITY INVOKER BEGIN END ;
23 connection node_1;
24 SHOW CREATE PROCEDURE p1;
25 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
26 p1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`user1`@`%` PROCEDURE `p1`(IN param1 INTEGER, OUT param2 INTEGER, INOUT param3 INTEGER)
27 MODIFIES SQL DATA
28 COMMENT 'p1_comment'
29 INSERT INTO t1 VALUES (1) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
30 connection node_2;
31 SELECT 1 FROM DUAL;
32 1
33 1
34 SHOW CREATE PROCEDURE p1;
35 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
36 p1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`user1`@`%` PROCEDURE `p1`(IN param1 INTEGER, OUT param2 INTEGER, INOUT param3 INTEGER)
37 MODIFIES SQL DATA
38 COMMENT 'p1_comment'
39 INSERT INTO t1 VALUES (1) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
40 connection node_1;
41 SHOW CREATE PROCEDURE p2;
42 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
43 p2 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`(param VARCHAR(100))
44 NO SQL
45 DETERMINISTIC
46 SQL SECURITY INVOKER
47 BEGIN END latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
48 connection node_2;
49 SHOW CREATE PROCEDURE p2;
50 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
51 p2 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`(param VARCHAR(100))
52 NO SQL
53 DETERMINISTIC
54 SQL SECURITY INVOKER
55 BEGIN END latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
56 CALL p1(@a, @b, @c);
57 CALL p2('abc');
58 connection node_1;
59 DROP PROCEDURE p1;
60 DROP PROCEDURE p2;
61 DROP USER 'user1';
62 DROP TABLE t1;