Debian Codegraph @

mysql-test/suite/rpl/r/rpl_create_drop_trigger.result

raw
1 include/master-slave.inc
2 [connection master]
3 # 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 ACTION_STATEMENT_Master
13 SET @sum = @sum + NEW.val + 1
14 connection slave;
15 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Slave FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
16 ACTION_STATEMENT_Slave
17 SET @sum = @sum + NEW.val + 1
18 # Part 2 - CREATE IF NOT EXISTS (on a existing trigger)
19 connection master;
20 CREATE TRIGGER IF NOT EXISTS val_sum AFTER INSERT ON t1 FOR EACH ROW SET @sum = @sum + NEW.val + 2;
21 Warnings:
22 Note 1359 Trigger 'db1.val_sum' already exists
23 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Master FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
24 ACTION_STATEMENT_Master
25 SET @sum = @sum + NEW.val + 1
26 connection slave;
27 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Slave FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
28 ACTION_STATEMENT_Slave
29 SET @sum = @sum + NEW.val + 1
30 # Part 3 - CREATE OR REPLACE (on a existing trigger)
31 connection master;
32 CREATE OR REPLACE TRIGGER val_sum BEFORE INSERT ON t1 FOR EACH ROW SET @sum = @sum + NEW.val + 3;
33 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Master FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
34 ACTION_STATEMENT_Master
35 SET @sum = @sum + NEW.val + 3
36 connection slave;
37 SELECT ACTION_STATEMENT AS ACTION_STATEMENT_Slave FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME='val_sum';
38 ACTION_STATEMENT_Slave
39 SET @sum = @sum + NEW.val + 3
40 # Clearing up
41 connection master;
42 DROP TRIGGER val_sum;
43 DROP TABLE t1;
44 DROP TRIGGER IF EXISTS val_sum;
45 Warnings:
46 Note 1360 Trigger does not exist
47 DROP TRIGGER random_trigger;
48 ERROR HY000: Trigger does not exist
49 DROP DATABASE db1;
50 DROP TRIGGER IF EXISTS val_sum;
51 ERROR 3D000: No database selected
52 # Syncing slave with master
53 connection slave;
54 DROP TRIGGER val_sum;
55 ERROR HY000: Trigger does not exist
56 include/rpl_end.inc