Debian Codegraph @

mysql-test/suite/binlog/t/binlog_create_if_not_exists.test

raw
1 --echo #
2 --echo # WL#14722 Support IF NOT EXISTS clause
3 --echo # in CREATE PROCEDURE/FUNCTION/TRIGGER
4 --echo #
5
6 --source include/master-slave.inc
7
8 --echo
9 --echo # Create objects on source
10 --echo [On Source]
11 --connection master
12
13 CREATE TABLE t1 (a INT);
14
15 CREATE PROCEDURE IF NOT EXISTS sp1() BEGIN END;
16 CREATE FUNCTION IF NOT EXISTS sf1() RETURNS INT DETERMINISTIC return 0;
17 --replace_result $UDF_EXAMPLE_LIB UDF_EXAMPLE_LIB
18 --eval CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_LIB"
19 CREATE TRIGGER IF NOT EXISTS trg1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN END;
20
21 --echo
22 --echo # Check if objects are created on replica
23 --echo [On Replica]
24 --source include/sync_slave_sql_with_master.inc
25 --connection slave
26
27 SELECT routine_name FROM information_schema.routines WHERE routine_schema = "test";
28 SELECT name FROM mysql.func WHERE name = 'metaphon';
29 SELECT trigger_name FROM information_schema.triggers WHERE trigger_schema = "test";
30
31 --echo
32 --echo # Drop objects on replica
33 DROP PROCEDURE sp1;
34 DROP FUNCTION sf1;
35 DROP FUNCTION metaphon;
36 DROP TRIGGER trg1;
37
38 --echo
39 --echo # Create objects with IF NOT EXISTS claus when objects already exist on source.
40 --echo # These statements should re-create objects on replica
41 --echo [On Source]
42 --connection master
43
44 CREATE PROCEDURE IF NOT EXISTS sp1() BEGIN END;
45 CREATE FUNCTION IF NOT EXISTS sf1() RETURNS INT DETERMINISTIC return 0;
46 --replace_result $UDF_EXAMPLE_LIB UDF_EXAMPLE_LIB
47 --eval CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_LIB"
48 CREATE TRIGGER IF NOT EXISTS trg1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN END;
49
50 --echo
51 --echo # Check if objects are re-created on replica
52 --echo [On Replica]
53 --source include/sync_slave_sql_with_master.inc
54 --connection slave
55
56 SELECT routine_name FROM information_schema.routines WHERE routine_schema = "test";
57 SELECT name FROM mysql.func WHERE name = 'metaphon';
58 SELECT trigger_name FROM information_schema.triggers WHERE trigger_schema = "test";
59
60 --echo
61 --echo # Cleanup
62 --echo [On Source]
63 --connection master
64
65 DROP PROCEDURE sp1;
66 DROP FUNCTION sf1;
67 DROP FUNCTION metaphon;
68 DROP TRIGGER trg1;
69
70 DROP TABLE t1;
71
72 --source include/sync_slave_sql_with_master.inc
73 --source include/rpl_end.inc