diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_create_function.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_create_function.result | 55 |
1 files changed, 55 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_create_function.result b/mysql-test/suite/galera/r/galera_create_function.result new file mode 100644 index 00000000000..10020712286 --- /dev/null +++ b/mysql-test/suite/galera/r/galera_create_function.result @@ -0,0 +1,55 @@ +CREATE USER 'user1'; +CREATE +DEFINER = 'user1' +FUNCTION f1 (param INTEGER) +RETURNS VARCHAR(200) +COMMENT 'f1_comment' +LANGUAGE SQL +NOT DETERMINISTIC +MODIFIES SQL DATA +SQL SECURITY DEFINER +RETURN 'abc'; +GRANT EXECUTE ON FUNCTION f1 TO user1; +CREATE +DEFINER = CURRENT_USER +FUNCTION f2 (param VARCHAR(100)) +RETURNS INTEGER +DETERMINISTIC +NO SQL +SQL SECURITY INVOKER +RETURN 123; +SHOW CREATE FUNCTION f1; +Function sql_mode Create Function character_set_client collation_connection Database Collation +f1 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`user1`@`%` FUNCTION `f1`(param INTEGER) RETURNS varchar(200) CHARSET latin1 + MODIFIES SQL DATA + COMMENT 'f1_comment' +RETURN 'abc' latin1 latin1_swedish_ci latin1_swedish_ci +SHOW CREATE FUNCTION f1; +Function sql_mode Create Function character_set_client collation_connection Database Collation +f1 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`user1`@`%` FUNCTION `f1`(param INTEGER) RETURNS varchar(200) CHARSET latin1 + MODIFIES SQL DATA + COMMENT 'f1_comment' +RETURN 'abc' latin1 latin1_swedish_ci latin1_swedish_ci +SHOW CREATE FUNCTION f2; +Function sql_mode Create Function character_set_client collation_connection Database Collation +f2 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` FUNCTION `f2`(param VARCHAR(100)) RETURNS int(11) + NO SQL + DETERMINISTIC + SQL SECURITY INVOKER +RETURN 123 latin1 latin1_swedish_ci latin1_swedish_ci +SHOW CREATE FUNCTION f2; +Function sql_mode Create Function character_set_client collation_connection Database Collation +f2 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` FUNCTION `f2`(param VARCHAR(100)) RETURNS int(11) + NO SQL + DETERMINISTIC + SQL SECURITY INVOKER +RETURN 123 latin1 latin1_swedish_ci latin1_swedish_ci +SELECT f1(1) = 'abc'; +f1(1) = 'abc' +1 +SELECT f2('abc') = 123; +f2('abc') = 123 +1 +DROP FUNCTION f1; +DROP FUNCTION f2; +DROP USER 'user1'; |