Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=3]
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 [connection server1]
7 ## Create table with HASH Partition ##
8 CREATE TABLE t1 ( c1 int PRIMARY KEY )
9 CHARSET=utf8mb4
10 PARTITION BY HASH(c1)
11 PARTITIONS 3;
12 ## Create table with KEY Partition ##
13 CREATE TABLE t2 ( c1 int PRIMARY KEY )
14 CHARSET=utf8mb4
15 PARTITION BY KEY()
16 PARTITIONS 3;
17 include/rpl_sync.inc
18 [connection server2]
19 SHOW CREATE TABLE t1;
20 Table Create Table
21 t1 CREATE TABLE `t1` (
22 `c1` int NOT NULL,
23 PRIMARY KEY (`c1`)
24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
25 /*!50100 PARTITION BY HASH (`c1`)
26 PARTITIONS 3 */
27 INSERT INTO t1 values (1),(5),(11),(18),(20),(100),(33);
28 SHOW CREATE TABLE t2;
29 Table Create Table
30 t2 CREATE TABLE `t2` (
31 `c1` int NOT NULL,
32 PRIMARY KEY (`c1`)
33 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
34 /*!50100 PARTITION BY KEY ()
35 PARTITIONS 3 */
36 INSERT INTO t2 values (1),(5),(11),(18),(20),(100);
37 include/rpl_sync.inc
38 [connection server1]
39 INSERT INTO t1 VALUES (15);
40 DELETE FROM t1 WHERE c1= 5;
41 DELETE FROM t2 WHERE c1= 100;
42 include/rpl_sync.inc
43 [connection server3]
44 include/assert.inc ['Check that partition p0 on table t1 has 3 row(s)']
45 include/assert.inc ['Check that partition p1 on table t1 has 2 row(s)']
46 include/assert.inc ['Check that partition p2 on table t1 has 2 row(s)']
47 include/assert.inc ['Check that partition p0 on table t2 has 2 row(s)']
48 include/assert.inc ['Check that partition p1 on table t2 has 2 row(s)']
49 include/assert.inc ['Check that partition p2 on table t2 has 1 row(s)']
50 DROP TABLE t1;
51 DROP TABLE t2;
52 include/rpl_sync.inc
53 include/group_replication_end.inc