1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
include/group_replication.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
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.
[connection server1]
############################################################
# 1. Create the test table without primary key on all group
# members.
CREATE TABLE `t1` (
`col_bit_64` bit(64),
`col_varchar_255_utf8_key` varchar(255) CHARACTER SET utf8,
`col_bigint` bigint,
`col_varchar_255_binary_key` varchar(255) CHARACTER SET binary,
`col_varchar_255_utf8` varchar(255) CHARACTER SET utf8,
`col_text_utf8` text CHARACTER SET utf8,
`col_set_binary_key` set ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') CHARACTER SET binary,
`col_text_binary` text CHARACTER SET binary,
`col_varchar_255_binary` varchar(255) CHARACTER SET binary,
`col_bigint_key` bigint,
`col_set_utf8` set ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') CHARACTER SET utf8,
`col_text_binary_key` text CHARACTER SET binary,
`col_set_binary` set ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') CHARACTER SET binary,
`col_set_utf8_key` set ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') CHARACTER SET utf8,
`col_text_utf8_key` text CHARACTER SET utf8,
`col_bit_64_key` bit(64),
key (`col_varchar_255_utf8_key`),
key (`col_varchar_255_binary_key`),
key (`col_set_binary_key`),
key (`col_bigint_key`),
key (`col_text_binary_key`(255)),
key (`col_set_utf8_key`),
key (`col_text_utf8_key` (255)),
key (`col_bit_64_key`)
) ENGINE=InnoDB;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
include/rpl_sync.inc
############################################################
# 2. Execute a query on the table without primary key on
# server 1 that will fail on pre-conditions check.
SET SESSION sql_log_bin= 0;
call mtr.add_suppression("Plugin group_replication reported: 'Table t1 does not have any PRIMARY KEY. This is not compatible with Group Replication.'");
SET SESSION sql_log_bin= 1;
INSERT /*! IGNORE */ INTO t1 VALUES (NULL, NULL, -1188668826649100288, 'x', NULL, 'can\'t', 'p', 'didn\'t', 'we', 8, 'what', 'who', NULL, 'can', 'not', 1);
ERROR HY000: The table does not comply with the requirements by an external plugin.
############################################################
# 3. Check that table t1 is empty on server 1.
include/assert.inc ['Table t1 is empty']
############################################################
# 4. Check that table t1 is empty on server 2.
include/assert.inc ['Table t1 is empty']
############################################################
# 5. Clean data.
DROP TABLE t1;
include/group_replication_end.inc
|
