Debian Codegraph @

mysql-test/suite/group_replication/t/gr_consistent_reads_single_member.test

raw
1 ################################################################################
2 # Validate that group_replication_consistency is supported on single member
3 # groups.
4 #
5 # Test:
6 # 00. The test requires one server: M1.
7 # 01. Start a single member group.
8 # 02. Validate all values on a single member group.
9 # 03. Clean up.
10 ################################################################################
11 --source include/have_group_replication_plugin.inc
12 --let $rpl_skip_group_replication_start= 1
13 --source include/group_replication.inc
14
15
16 --echo
17 --echo ############################################################
18 --echo # 01. Start a single member group.
19 --let $rpl_connection_name= server1
20 --source include/rpl_connection.inc
21 --source include/start_and_bootstrap_group_replication.inc
22
23
24 --echo
25 --echo ############################################################
26 --echo # 02. Validate all values on a single member group.
27 SET @@SESSION.group_replication_consistency= 'BEFORE';
28 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
29
30 SET @@SESSION.group_replication_consistency= 'AFTER';
31 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY);
32
33 SET @@SESSION.group_replication_consistency= 'BEFORE_AND_AFTER';
34 CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY);
35
36 SET @@SESSION.group_replication_consistency= DEFAULT;
37
38
39 --echo
40 --echo ############################################################
41 --echo # 03. Clean up.
42 --let $rpl_connection_name= server1
43 --source include/rpl_connection.inc
44 DROP TABLE t1;
45 DROP TABLE t2;
46 DROP TABLE t3;
47
48 --source include/group_replication_end.inc