diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_create_procedure.result')
| -rw-r--r-- | mysql-test/suite/galera/r/galera_create_procedure.result | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_create_procedure.result b/mysql-test/suite/galera/r/galera_create_procedure.result new file mode 100644 index 00000000000..6191ef48ee5 --- /dev/null +++ b/mysql-test/suite/galera/r/galera_create_procedure.result @@ -0,0 +1,53 @@ +CREATE USER 'user1'; +CREATE TABLE t1 (f1 INTEGER); +CREATE +DEFINER = 'user1' +PROCEDURE p1 (IN param1 INTEGER, OUT param2 INTEGER, INOUT param3 INTEGER) +COMMENT 'p1_comment' +LANGUAGE SQL +NOT DETERMINISTIC +MODIFIES SQL DATA +SQL SECURITY DEFINER +INSERT INTO t1 VALUES (1); +GRANT EXECUTE ON PROCEDURE p1 TO user1; +CREATE +DEFINER = CURRENT_USER +PROCEDURE p2 (param VARCHAR(100)) +DETERMINISTIC +NO SQL +SQL SECURITY INVOKER BEGIN END ; +SHOW CREATE PROCEDURE p1; +Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation +p1 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`user1`@`%` PROCEDURE `p1`(IN param1 INTEGER, OUT param2 INTEGER, INOUT param3 INTEGER) + MODIFIES SQL DATA + COMMENT 'p1_comment' +INSERT INTO t1 VALUES (1) latin1 latin1_swedish_ci latin1_swedish_ci +SELECT 1 FROM DUAL; +1 +1 +SHOW CREATE PROCEDURE p1; +Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation +p1 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`user1`@`%` PROCEDURE `p1`(IN param1 INTEGER, OUT param2 INTEGER, INOUT param3 INTEGER) + MODIFIES SQL DATA + COMMENT 'p1_comment' +INSERT INTO t1 VALUES (1) latin1 latin1_swedish_ci latin1_swedish_ci +SHOW CREATE PROCEDURE p2; +Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation +p2 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`(param VARCHAR(100)) + NO SQL + DETERMINISTIC + SQL SECURITY INVOKER +BEGIN END latin1 latin1_swedish_ci latin1_swedish_ci +SHOW CREATE PROCEDURE p2; +Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation +p2 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`(param VARCHAR(100)) + NO SQL + DETERMINISTIC + SQL SECURITY INVOKER +BEGIN END latin1 latin1_swedish_ci latin1_swedish_ci +CALL p1(@a, @b, @c); +CALL p2('abc'); +DROP PROCEDURE p1; +DROP PROCEDURE p2; +DROP USER 'user1'; +DROP TABLE t1; |