Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test CREATE FUNCTION
6 #
7
8 --connection node_1
9 CREATE USER 'user1';
10
11 CREATE
12 DEFINER = 'user1'
13 FUNCTION f1 (param INTEGER)
14 RETURNS VARCHAR(200)
15 COMMENT 'f1_comment'
16 LANGUAGE SQL
17 NOT DETERMINISTIC
18 MODIFIES SQL DATA
19 SQL SECURITY DEFINER
20 RETURN 'abc';
21 GRANT EXECUTE ON FUNCTION f1 TO user1;
22
23 CREATE
24 DEFINER = CURRENT_USER
25 FUNCTION f2 (param VARCHAR(100))
26 RETURNS INTEGER
27 DETERMINISTIC
28 NO SQL
29 SQL SECURITY INVOKER
30 RETURN 123;
31
32 --connection node_1
33 SHOW CREATE FUNCTION f1;
34
35 --connection node_2
36 # Work around codership/mysql-wsrep#228 - SHOW CREATE FUNCTION not covered by wsrep_sync_wait
37 SELECT 1 FROM DUAL;
38 SHOW CREATE FUNCTION f1;
39
40 --connection node_1
41 SHOW CREATE FUNCTION f2;
42
43 --connection node_2
44 SHOW CREATE FUNCTION f2;
45
46 SELECT f1(1) = 'abc';
47 SELECT f2('abc') = 123;
48
49 --connection node_1
50 DROP FUNCTION f1;
51 DROP FUNCTION f2;
52
53 DROP USER 'user1';