Debian Codegraph @

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

raw
1 #
2 # Test wsrep_certify_nonPK = OFF
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 --let $wsrep_certify_nonPK_orig = `SELECT @@wsrep_certify_nonPK`
9 SET GLOBAL wsrep_certify_nonPK = OFF;
10
11 --connection node_2
12 SET GLOBAL wsrep_certify_nonPK = OFF;
13
14 --connection node_1
15 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB /* Table has no primary key */;
16 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
17
18 # All DML without a PK is rejected with an error
19 --error ER_LOCK_DEADLOCK,ER_ERROR_DURING_COMMIT
20 INSERT INTO t1 VALUES (1), (2);
21
22 # DML with a PK is allowed to proceed
23 INSERT INTO t2 VALUES (1), (2);
24 UPDATE t2 SET f1 = 3 WHERE f1 = 1;
25
26 --connection node_2
27 SELECT COUNT(*) = 0 FROM t1;
28 SELECT COUNT(*) = 2 FROM t2;
29 SELECT COUNT(*) = 1 FROM t2 WHERE f1 = 3;
30
31 --connection node_1
32 --eval SET GLOBAL wsrep_certify_nonPK = $wsrep_certify_nonPK_orig
33
34 --connection node_2
35 --eval SET GLOBAL wsrep_certify_nonPK = $wsrep_certify_nonPK_orig
36
37 DROP TABLE t1;
38 DROP TABLE t2;
39
40 --connection node_1
41 call mtr.add_suppression("SQL statement was ineffective");
42
43 --source include/galera_end.inc