Debian Codegraph @

mysql-test/suite/galera/t/galera_partition_key.test

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