Debian Codegraph @

mysql-test/suite/galera/r/galera_partition_key.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE `t1` (
5 `id` int(10) unsigned NOT NULL,
6 `other_id` int(10) unsigned NOT NULL,
7 PRIMARY KEY (`id`,`other_id`)
8 ) ENGINE=InnoDB
9 PARTITION BY LIST (`id` MOD 2)
10 (PARTITION `p0` VALUES IN (0) ENGINE = InnoDB,
11 PARTITION `p1` VALUES IN (1) ENGINE = InnoDB);
12 INSERT INTO t1 VALUES (1, 0);
13 CREATE TABLE t2 LIKE t1;
14 START TRANSACTION;
15 INSERT INTO t2(SELECT * FROM t1 WHERE id = 1);
16 DELETE FROM t1 WHERE id = 1;
17 COMMIT;
18 connection node_2;
19 SELECT * from t1;
20 id other_id
21 SELECT * from t2;
22 id other_id
23 1 0
24 DROP TABLE t1, t2;
25 connection node_1;
26 CREATE TABLE `t1` (
27 `id` int(10) unsigned NOT NULL,
28 `other_id` int(10) unsigned NOT NULL,
29 PRIMARY KEY (`id`)
30 ) ENGINE=InnoDB
31 PARTITION BY LIST (`id` MOD 2)
32 (PARTITION `p0` VALUES IN (0) ENGINE = InnoDB,
33 PARTITION `p1` VALUES IN (1) ENGINE = InnoDB);
34 INSERT INTO t1 VALUES (1, 0);
35 CREATE TABLE t2 LIKE t1;
36 START TRANSACTION;
37 INSERT INTO t2(SELECT * FROM t1 WHERE id = 1);
38 DELETE FROM t1 WHERE id = 1;
39 COMMIT;
40 connection node_2;
41 SELECT * from t1;
42 id other_id
43 SELECT * from t2;
44 id other_id
45 1 0
46 DROP TABLE t1, t2;