Debian Codegraph @

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

raw
1 #
2 # DELETE LIMIT should not cause any issues with row-based Galera replication
3 # regardless of the order in which the rows were deleted
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 #
10 # With a PK
11 #
12
13 --connection node_1
14 CREATE TABLE ten (f1 INTEGER) Engine=InnoDB;
15 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
16
17 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
18 INSERT INTO t1 SELECT f1 FROM ten ORDER BY RAND();
19
20 --connection node_2
21 DELETE FROM t1 ORDER BY RAND() LIMIT 5;
22 --let $sum_remaining = `SELECT SUM(f1) FROM t1`
23 --let $max_remaining = `SELECT MAX(f1) FROM t1`
24
25 --connection node_1
26 --disable_query_log
27 --eval SELECT (SELECT SUM(f1) FROM t1) = $sum_remaining AS sum_matches;
28 --eval SELECT f1 = $max_remaining AS max_matches FROM t1 WHERE f1 = $max_remaining;
29 --enable_query_log
30
31 DROP TABLE t1;
32
33 #
34 # Without a PK
35 #
36
37 CREATE TABLE t2 (f1 INTEGER) Engine=InnoDB;
38 INSERT INTO t2 SELECT f1 FROM ten ORDER BY RAND();
39
40 --connection node_2
41 DELETE FROM t2 ORDER BY RAND() LIMIT 5;
42 --let $sum_remaining = `SELECT SUM(f1) FROM t2`
43 --let $max_remaining = `SELECT MAX(f1) FROM t2`
44
45 --connection node_1
46 --disable_query_log
47 --eval SELECT (SELECT SUM(f1) FROM t2) = $sum_remaining AS sum_matches;
48 --eval SELECT f1 = $max_remaining AS max_matches FROM t2 WHERE f1 = $max_remaining;
49 --enable_query_log
50
51 DROP TABLE t2;
52 DROP TABLE ten;