Debian Codegraph @

mysql-test/suite/group_replication/r/gr_invoked_features.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 CREATE TABLE t11 (a INT NOT NULL PRIMARY KEY, b INT, c VARCHAR(64)) ENGINE=innodb;
7 INSERT INTO t11 VALUES (1,1,'1');
8 INSERT INTO t11 VALUES (2,2,UUID());
9 CREATE TABLE t12 (a INT PRIMARY KEY, b INT, c VARCHAR(64)) ENGINE=innodb;
10 INSERT INTO t12 VALUES (1,1,'1');
11 INSERT INTO t12 VALUES (2,2,UUID());
12
13 CREATE VIEW v11 AS SELECT * FROM t11;
14 CREATE TRIGGER t11_tr1 BEFORE INSERT ON t11 FOR EACH ROW
15 BEGIN
16 INSERT INTO t12 VALUES (NEW.a, NEW.b, NEW.c);
17 INSERT INTO t13 VALUES (NEW.a, NEW.b, NEW.c);
18 END|
19 CREATE EVENT e1 ON SCHEDULE EVERY 1 SECOND DISABLE DO
20 BEGIN
21 ALTER EVENT e1 DISABLE;
22 CALL p11(10, '');
23 END|
24 CREATE FUNCTION f1 (x INT) RETURNS VARCHAR(64)
25 BEGIN
26 IF x > 5 THEN
27 RETURN UUID();
28 END IF;
29 RETURN '';
30 END|
31 CREATE PROCEDURE p11 (IN x INT, IN y VARCHAR(64))
32 BEGIN
33 INSERT IGNORE INTO t11 VALUES (x,x,y);
34 END|
35 include/rpl_sync.inc
36
37 CREATE TABLE t13(a INT NOT NULL PRIMARY KEY, b INT, c VARCHAR(64)) engine=InnoDB;
38 INSERT INTO t11 VALUES (3,3,'');
39 UPDATE t11 SET c='2' WHERE a = 1;
40 include/rpl_sync.inc
41 INSERT INTO t11 VALUES(4,4,f1(4));
42 INSERT INTO t11 VALUES(7,7,f1(7));
43 CALL p11(5, UUID());
44 CALL p11(10, UUID());
45 SET @old_event_scheduler= @@global.event_scheduler;
46 SET GLOBAL EVENT_SCHEDULER = on;
47 ALTER EVENT e1 ENABLE;
48 SET GLOBAL EVENT_SCHEDULER = @old_event_scheduler;
49 include/rpl_sync.inc
50
51 SHOW TABLES LIKE 't%';
52 Tables_in_test (t%)
53 t11
54 t12
55 t13
56 SELECT table_name FROM information_schema.views WHERE table_schema='test';
57 TABLE_NAME
58 v11
59 SELECT trigger_name, event_manipulation, event_object_table FROM information_schema.triggers WHERE trigger_schema='test';
60 TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_TABLE
61 t11_tr1 INSERT t11
62 SELECT routine_type, routine_name FROM information_schema.routines WHERE routine_schema='test';
63 ROUTINE_TYPE ROUTINE_NAME
64 FUNCTION f1
65 PROCEDURE p11
66 SELECT event_name, status FROM information_schema.events WHERE event_schema='test';
67 EVENT_NAME STATUS
68 e1 DISABLED
69 include/rpl_sync.inc
70 include/diff_tables.inc [server1:t11, server2:t11]
71 include/diff_tables.inc [server1:t12, server2:t12]
72 include/diff_tables.inc [server1:t13, server2:t13]
73
74 SHOW TABLES LIKE 't%';
75 Tables_in_test (t%)
76 t11
77 t12
78 t13
79 SELECT table_name FROM information_schema.views WHERE table_schema='test';
80 TABLE_NAME
81 v11
82 SELECT trigger_name, event_manipulation, event_object_table FROM information_schema.triggers WHERE trigger_schema='test';
83 TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_TABLE
84 t11_tr1 INSERT t11
85 SELECT routine_type, routine_name FROM information_schema.routines WHERE routine_schema='test';
86 ROUTINE_TYPE ROUTINE_NAME
87 FUNCTION f1
88 PROCEDURE p11
89 SELECT event_name, status FROM information_schema.events WHERE event_schema='test';
90 EVENT_NAME STATUS
91 e1 DISABLED
92 DROP VIEW IF EXISTS v11;
93 DROP TABLE IF EXISTS t11,t12,t13;
94 DROP PROCEDURE IF EXISTS p11;
95 DROP FUNCTION IF EXISTS f1;
96 DROP EVENT IF EXISTS e1;
97 include/group_replication_end.inc