Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE USER 'user1';
5 CREATE
6 DEFINER = 'user1'
7 FUNCTION f1 (param INTEGER)
8 RETURNS VARCHAR(200)
9 COMMENT 'f1_comment'
10 LANGUAGE SQL
11 NOT DETERMINISTIC
12 MODIFIES SQL DATA
13 SQL SECURITY DEFINER
14 RETURN 'abc';
15 GRANT EXECUTE ON FUNCTION f1 TO user1;
16 CREATE
17 DEFINER = CURRENT_USER
18 FUNCTION f2 (param VARCHAR(100))
19 RETURNS INTEGER
20 DETERMINISTIC
21 NO SQL
22 SQL SECURITY INVOKER
23 RETURN 123;
24 connection node_1;
25 SHOW CREATE FUNCTION f1;
26 Function sql_mode Create Function character_set_client collation_connection Database Collation
27 f1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`user1`@`%` FUNCTION `f1`(param INTEGER) RETURNS varchar(200) CHARSET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci
28 MODIFIES SQL DATA
29 COMMENT 'f1_comment'
30 RETURN 'abc' latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
31 connection node_2;
32 SELECT 1 FROM DUAL;
33 1
34 1
35 SHOW CREATE FUNCTION f1;
36 Function sql_mode Create Function character_set_client collation_connection Database Collation
37 f1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`user1`@`%` FUNCTION `f1`(param INTEGER) RETURNS varchar(200) CHARSET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci
38 MODIFIES SQL DATA
39 COMMENT 'f1_comment'
40 RETURN 'abc' latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
41 connection node_1;
42 SHOW CREATE FUNCTION f2;
43 Function sql_mode Create Function character_set_client collation_connection Database Collation
44 f2 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` FUNCTION `f2`(param VARCHAR(100)) RETURNS int(11)
45 NO SQL
46 DETERMINISTIC
47 SQL SECURITY INVOKER
48 RETURN 123 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
49 connection node_2;
50 SHOW CREATE FUNCTION f2;
51 Function sql_mode Create Function character_set_client collation_connection Database Collation
52 f2 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` FUNCTION `f2`(param VARCHAR(100)) RETURNS int(11)
53 NO SQL
54 DETERMINISTIC
55 SQL SECURITY INVOKER
56 RETURN 123 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
57 SELECT f1(1) = 'abc';
58 f1(1) = 'abc'
59 1
60 SELECT f2('abc') = 123;
61 f2('abc') = 123
62 1
63 connection node_1;
64 DROP FUNCTION f1;
65 DROP FUNCTION f2;
66 DROP USER 'user1';