Debian Codegraph @

mysql-test/suite/group_replication/r/gr_sbr_verifications_mysqlbinlog.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
7 # Initialization
8
9 # Bootstrap start Group Replication on server1
10 [connection server1]
11 include/start_and_bootstrap_group_replication.inc
12
13 # Set binlog format on server2.
14 [connection server2]
15 SET SESSION BINLOG_FORMAT= "STATEMENT";
16 Warnings:
17 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
18
19 # Create a table t1 without PK on server2(master)
20 # and add data to it.
21 CREATE TABLE t1 (c1 INT);
22 include/rpl_sync.inc
23 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-bbbbbbbbbbbb:1';
24 INSERT INTO t1 VALUES (1);
25 SET GTID_NEXT= AUTOMATIC;
26
27 # Verify insert doesn't gets executed as table
28 # doesn't have a primary key.
29 [connection server1]
30 Pattern found.
31
32 # Create a table t2 with MYISAM storage engine on
33 # server2(master) and add data to it.
34 [connection server2]
35 CREATE TABLE t2 (c1 INT) engine MyIsam;
36 include/rpl_sync.inc
37 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-bbbbbbbbbbbb:2';
38 INSERT INTO t2 VALUES (1);
39 SET GTID_NEXT= AUTOMATIC;
40
41 # Verify insert doesn't gets executed as table
42 # doesn't have the innodb storage engine.
43 [connection server1]
44 Pattern found.
45 Pattern found.
46
47 # Create a table tc3 with foreign key with delete CASCADE clause
48 # on server2(master) and add data to it.
49 [connection server2]
50 CREATE TABLE tp3 (c1 INT PRIMARY KEY);
51 CREATE TABLE tc3 (c1 INT PRIMARY KEY, FOREIGN KEY (c1) REFERENCES tp3(c1) ON DELETE CASCADE);
52 INSERT INTO tp3 VALUES(1);
53 include/rpl_sync.inc
54 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-bbbbbbbbbbbb:3';
55 INSERT INTO tc3 VALUES (1);
56 SET GTID_NEXT= AUTOMATIC;
57
58 # Verify insert doesn't gets executed as table
59 # has a foreign key with CASCADE clause.
60 [connection server1]
61 Pattern found.
62
63 # Clean-up
64 [connection server2]
65 drop table t1;
66 drop table t2;
67 drop table tc3;
68 drop table tp3;
69 SET SESSION BINLOG_FORMAT= DEFAULT;
70 Warnings:
71 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
72 [connection server1]
73 drop table t1;
74 drop table t2;
75 drop table tc3;
76 drop table tp3;
77 include/group_replication_end.inc