Debian Codegraph @

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

raw
1 ##############################################################################
2 # This test checks that keys that are considered the same under a collation do
3 # not pass certification as being different keys.
4 #
5 # 0. 2 Server with running GR
6 # 1. Create a table with collation latin1
7 # 2. Execute in concurrency transaction with equivalent keys under latin1
8 # 3. Cleanup
9 ##############################################################################
10
11 --source include/have_debug_sync.inc
12 --source include/have_group_replication_plugin.inc
13 --source include/group_replication.inc
14
15 --echo
16 --echo ###########################
17 --echo # Create a table on server1
18 --let $rpl_connection_name= server1
19 --source include/rpl_connection.inc
20
21 CREATE TABLE t1 (
22 u_str VARCHAR(32) NOT NULL,
23 value VARCHAR(32) NOT NULL,
24 PRIMARY KEY (u_str)
25 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
26
27 --source include/rpl_sync.inc
28
29 --echo
30 --echo ######################################################################
31 --echo # Execute in concurrency transaction with equivalent keys under latin1
32 --let $local_server_connection1=server1
33 --let $local_server_connection2=server_1
34 --let $remote_server_connection=server2
35 --let $local_transaction= INSERT INTO t1 (u_str, value) VALUES ('Ã', "A value");
36 --let $remote_transaction=INSERT INTO t1 (u_str, value) VALUES ('á', "Another value");
37 --let $conflict_test=1
38 --source include/gr_parallel_local_and_remote_transactions.inc
39
40 --echo
41 --echo ###########
42 --echo # Clean up.
43 DROP TABLE t1;
44
45 --source include/group_replication_end.inc