Debian Codegraph @

mysql-test/suite/group_replication/r/gr_list_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 ## List Partitioning ##
8 CREATE TABLE t1 (id int PRIMARY KEY, c2 int)
9 CHARSET=utf8mb4
10 PARTITION BY LIST (id)
11 (PARTITION p1 VALUES in (5, 10, 15),
12 PARTITION p2 VALUES in (2, 3),
13 PARTITION p3 VALUES in (11, 21));
14 include/rpl_sync.inc
15 [connection server2]
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `id` int NOT NULL,
20 `c2` int DEFAULT NULL,
21 PRIMARY KEY (`id`)
22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
23 /*!50100 PARTITION BY LIST (`id`)
24 (PARTITION p1 VALUES IN (5,10,15) ENGINE = InnoDB,
25 PARTITION p2 VALUES IN (2,3) ENGINE = InnoDB,
26 PARTITION p3 VALUES IN (11,21) ENGINE = InnoDB) */
27 INSERT INTO t1 VALUES (05, 2);
28 INSERT INTO t1 VALUES (10, 5);
29 INSERT INTO t1 VALUES (03, 1);
30 INSERT INTO t1 VALUES (100, 50);
31 ERROR HY000: Table has no partition for value 100
32 include/rpl_sync.inc
33 [connection server1]
34 INSERT INTO t1 VALUES (11, 5);
35 INSERT INTO t1 VALUES (21, 10);
36 DELETE FROM t1 WHERE id= 5;
37 include/rpl_sync.inc
38 [connection server3]
39 include/assert.inc ['Check that partition p1 on table t1 has 1 row']
40 include/assert.inc ['Check that partition p2 on table t1 has 1 row']
41 include/assert.inc ['Check that partition p3 on table t1 has 2 rows']
42 DROP TABLE t1;
43 include/rpl_sync.inc
44 include/group_replication_end.inc