Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 #
4 # MDEV#4953 Galera: DELETE from a partitioned table is not replicated
5 #
6 USE test;
7 CREATE TABLE t1 (pk INT PRIMARY KEY, i INT) ENGINE=INNODB PARTITION BY HASH(pk) PARTITIONS 2;
8 INSERT INTO t1 VALUES (1,100), (2,200);
9 SELECT * FROM t1;
10 pk i
11 2 200
12 1 100
13 DELETE FROM t1;
14 SELECT * FROM t1;
15 pk i
16
17 # On node_1
18 connection node_1;
19 SELECT * FROM t1;
20 pk i
21
22 # On node_2
23 connection node_2;
24 SELECT * FROM t1;
25 pk i
26 DROP TABLE t1;
27 #
28 # MDEV#7501 : alter table exchange partition is not replicated in
29 # galera cluster
30 #
31
32 # On node_1
33 connection node_1;
34 CREATE TABLE test.t1 (
35 i INT UNSIGNED NOT NULL AUTO_INCREMENT,
36 PRIMARY KEY (i)
37 ) ENGINE=INNODB
38 PARTITION BY RANGE (i)
39 (PARTITION p1 VALUES LESS THAN (10) ENGINE = INNODB,
40 PARTITION p2 VALUES LESS THAN (20) ENGINE = INNODB,
41 PARTITION pMax VALUES LESS THAN MAXVALUE ENGINE = INNODB);
42 INSERT INTO test.t1 (i) VALUE (9),(19);
43 CREATE TABLE test.p1 LIKE test.t1;
44 ALTER TABLE test.p1 REMOVE PARTITIONING;
45 ALTER TABLE test.t1 EXCHANGE PARTITION p1 WITH TABLE test.p1;
46 SELECT * FROM test.t1;
47 i
48 19
49 SELECT * FROM test.p1;
50 i
51 9
52
53 # On node_2
54 connection node_2;
55 SHOW CREATE TABLE t1;
56 Table Create Table
57 t1 CREATE TABLE `t1` (
58 `i` int(10) unsigned NOT NULL AUTO_INCREMENT,
59 PRIMARY KEY (`i`)
60 ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
61 PARTITION BY RANGE (`i`)
62 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = InnoDB,
63 PARTITION `p2` VALUES LESS THAN (20) ENGINE = InnoDB,
64 PARTITION `pMax` VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
65 SHOW CREATE TABLE p1;
66 Table Create Table
67 p1 CREATE TABLE `p1` (
68 `i` int(10) unsigned NOT NULL AUTO_INCREMENT,
69 PRIMARY KEY (`i`)
70 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
71 SELECT * FROM test.t1;
72 i
73 19
74 SELECT * FROM test.p1;
75 i
76 9
77
78 # On node_1
79 connection node_1;
80 ALTER TABLE t1 TRUNCATE PARTITION p2;
81 SELECT * FROM test.t1;
82 i
83
84 # On node_2
85 connection node_2;
86 SELECT * FROM test.t1;
87 i
88
89 # On node_1
90 connection node_1;
91 ALTER TABLE t1 DROP PARTITION p2;
92 SHOW CREATE TABLE t1;
93 Table Create Table
94 t1 CREATE TABLE `t1` (
95 `i` int(10) unsigned NOT NULL AUTO_INCREMENT,
96 PRIMARY KEY (`i`)
97 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
98 PARTITION BY RANGE (`i`)
99 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = InnoDB,
100 PARTITION `pMax` VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
101
102 # On node_2
103 connection node_2;
104 SHOW CREATE TABLE t1;
105 Table Create Table
106 t1 CREATE TABLE `t1` (
107 `i` int(10) unsigned NOT NULL AUTO_INCREMENT,
108 PRIMARY KEY (`i`)
109 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
110 PARTITION BY RANGE (`i`)
111 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = InnoDB,
112 PARTITION `pMax` VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
113 DROP TABLE t1, p1;
114 #
115 # MDEV-5146: Bulk loads into partitioned table not working
116 #
117 connection node_1;
118 # Case 1: LOAD DATA with 20002 entries.
119 CREATE TABLE t1 (pk INT PRIMARY KEY)
120 ENGINE=INNODB PARTITION BY HASH(pk) PARTITIONS 2;
121 connection node_2;
122 SELECT COUNT(*) FROM t1;
123 COUNT(*)
124 20002
125 wsrep_last_committed_diff
126 AS_EXPECTED_1_or_2
127 DROP TABLE t1;
128 # Case 2: LOAD DATA with 101 entries.
129 connection node_1;
130 CREATE TABLE t1 (pk INT PRIMARY KEY)
131 ENGINE=INNODB PARTITION BY HASH(pk) PARTITIONS 2;
132 connection node_2;
133 SELECT COUNT(*) FROM t1;
134 COUNT(*)
135 101
136 wsrep_last_committed_diff
137 1
138 DROP TABLE t1;
139 connection node_1;
140 disconnect node_2;
141 disconnect node_1;
142 # End of test