Debian Codegraph @

mysql-test/suite/rpl/t/rpl_create_drop_trigger.test

raw
1 --source include/master-slave.inc
2
3 --echo # Part 1 - initial creation
4 connection master;
5 CREATE DATABASE db1;
6 USE db1;
7 CREATE TABLE t1 (val INT);
8 CREATE TRIGGER val_sum BEFORE INSERT ON t1 FOR EACH ROW SET @sum = @sum + NEW.val + 1;
9 SET @sum=0;
10 INSERT INTO t1 VALUES (10), (20), (30);
11 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Master FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
12 sync_slave_with_master;
13 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Slave FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
14
15 --echo # Part 2 - CREATE IF NOT EXISTS (on a existing trigger)
16 connection master;
17 CREATE TRIGGER IF NOT EXISTS val_sum AFTER INSERT ON t1 FOR EACH ROW SET @sum = @sum + NEW.val + 2;
18 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Master FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
19 sync_slave_with_master;
20 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Slave FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
21
22 --echo # Part 3 - CREATE OR REPLACE (on a existing trigger)
23 connection master;
24 CREATE OR REPLACE TRIGGER val_sum BEFORE INSERT ON t1 FOR EACH ROW SET @sum = @sum + NEW.val + 3;
25 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Master FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
26 sync_slave_with_master;
27 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Slave FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
28
29 --echo # Clearing up
30 connection master;
31 DROP TRIGGER val_sum;
32 DROP TABLE t1;
33 DROP TRIGGER IF EXISTS val_sum;
34
35 --error ER_TRG_DOES_NOT_EXIST
36 DROP TRIGGER random_trigger;
37 DROP DATABASE db1;
38
39 --error ER_NO_DB_ERROR
40 DROP TRIGGER IF EXISTS val_sum;
41
42 --echo # Syncing slave with master
43 sync_slave_with_master;
44
45 --error ER_TRG_DOES_NOT_EXIST
46 DROP TRIGGER val_sum;
47
48 --source include/rpl_end.inc