Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_partition.inc
4
5 --echo #
6 --echo # MDEV#4953 Galera: DELETE from a partitioned table is not replicated
7 --echo #
8
9 USE test;
10 CREATE TABLE t1 (pk INT PRIMARY KEY, i INT) ENGINE=INNODB PARTITION BY HASH(pk) PARTITIONS 2;
11 INSERT INTO t1 VALUES (1,100), (2,200);
12 SELECT * FROM t1;
13
14 DELETE FROM t1;
15 SELECT * FROM t1;
16
17 --echo
18 --echo # On node_1
19 --connection node_1
20 SELECT * FROM t1;
21
22 --echo
23 --echo # On node_2
24 --connection node_2
25 SELECT * FROM t1;
26
27 # Cleanup
28 DROP TABLE t1;
29
30
31 --echo #
32 --echo # MDEV#7501 : alter table exchange partition is not replicated in
33 --echo # galera cluster
34 --echo #
35
36 --echo
37 --echo # On node_1
38 --connection node_1
39
40 CREATE TABLE test.t1 (
41 i INT UNSIGNED NOT NULL AUTO_INCREMENT,
42 PRIMARY KEY (i)
43 ) ENGINE=INNODB
44 PARTITION BY RANGE (i)
45 (PARTITION p1 VALUES LESS THAN (10) ENGINE = INNODB,
46 PARTITION p2 VALUES LESS THAN (20) ENGINE = INNODB,
47 PARTITION pMax VALUES LESS THAN MAXVALUE ENGINE = INNODB);
48
49 INSERT INTO test.t1 (i) VALUE (9),(19);
50 CREATE TABLE test.p1 LIKE test.t1;
51 ALTER TABLE test.p1 REMOVE PARTITIONING;
52
53 ALTER TABLE test.t1 EXCHANGE PARTITION p1 WITH TABLE test.p1;
54 SELECT * FROM test.t1;
55 SELECT * FROM test.p1;
56
57 --echo
58 --echo # On node_2
59 --connection node_2
60
61 SHOW CREATE TABLE t1;
62 SHOW CREATE TABLE p1;
63
64 SELECT * FROM test.t1;
65 SELECT * FROM test.p1;
66
67 --echo
68 --echo # On node_1
69 --connection node_1
70 ALTER TABLE t1 TRUNCATE PARTITION p2;
71 SELECT * FROM test.t1;
72
73 --echo
74 --echo # On node_2
75 --connection node_2
76 SELECT * FROM test.t1;
77
78 --echo
79 --echo # On node_1
80 --connection node_1
81 ALTER TABLE t1 DROP PARTITION p2;
82 SHOW CREATE TABLE t1;
83
84 --echo
85 --echo # On node_2
86 --connection node_2
87 SHOW CREATE TABLE t1;
88
89
90 # Cleanup
91 DROP TABLE t1, p1;
92
93 --echo #
94 --echo # MDEV-5146: Bulk loads into partitioned table not working
95 --echo #
96
97 # Create 2 files with 20002 & 101 entries in each.
98 --perl
99 open(FILE, ">", "$ENV{'MYSQLTEST_VARDIR'}/tmp/mdev-5146-1.dat") or die;
100 foreach my $i (1..20002) {
101 print FILE "$i\n";
102 }
103
104 open(FILE, ">", "$ENV{'MYSQLTEST_VARDIR'}/tmp/mdev-5146-2.dat") or die;
105 foreach my $i (1..101) {
106 print FILE "$i\n";
107 }
108 EOF
109
110 --connection node_1
111
112 --echo # Case 1: LOAD DATA with 20002 entries.
113
114 CREATE TABLE t1 (pk INT PRIMARY KEY)
115 ENGINE=INNODB PARTITION BY HASH(pk) PARTITIONS 2;
116
117 # Record wsrep_last_committed as it was before LOAD DATA
118 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
119
120 --disable_query_log
121 --eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/mdev-5146-1.dat' INTO TABLE t1;
122 --enable_query_log
123
124 --let $wsrep_last_committed_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
125
126 --connection node_2
127 --let $wait_condition = SELECT COUNT(*) = 20002 FROM t1;
128 --source include/wait_condition.inc
129
130 SELECT COUNT(*) FROM t1;
131
132 # LOAD-ing 20002 rows causes
133 # 3 commits to be registered when the Galera library does not support streaming replication and
134 # 5 commits to be registered when the Galera library supports streaming replication
135 --disable_query_log
136 --replace_result 1 AS_EXPECTED_1_or_2 2 AS_EXPECTED_1_or_2
137 --eval SELECT $wsrep_last_committed_after - $wsrep_last_committed_before AS wsrep_last_committed_diff;
138 --enable_query_log
139
140 DROP TABLE t1;
141
142 --echo # Case 2: LOAD DATA with 101 entries.
143
144 --connection node_1
145
146 CREATE TABLE t1 (pk INT PRIMARY KEY)
147 ENGINE=INNODB PARTITION BY HASH(pk) PARTITIONS 2;
148
149 # Record wsrep_last_committed as it was before LOAD DATA
150 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
151
152 --disable_query_log
153 --eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/mdev-5146-2.dat' INTO TABLE t1;
154 --enable_query_log
155
156 --let $wsrep_last_committed_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
157
158 --connection node_2
159 --let $wait_condition = SELECT COUNT(*) = 101 FROM t1;
160 --source include/wait_condition.inc
161
162 SELECT COUNT(*) FROM t1;
163
164 # LOAD-ing 101 rows causes 1 commit to be registered
165 --disable_query_log
166 --eval SELECT $wsrep_last_committed_after - $wsrep_last_committed_before AS wsrep_last_committed_diff;
167 --enable_query_log
168
169 DROP TABLE t1;
170
171 --connection node_1
172
173 # Cleanup
174 remove_file '$MYSQLTEST_VARDIR/tmp/mdev-5146-1.dat';
175 remove_file '$MYSQLTEST_VARDIR/tmp/mdev-5146-2.dat';
176
177 --source include/galera_end.inc
178 --echo # End of test