Debian Codegraph @

mysql-test/suite/galera/t/MDEV-27862.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_sequence.inc
4
5 --disable_ps2_protocol
6
7 # NEXTVAL
8
9 --connection node_1
10
11 CREATE SEQUENCE seq NOCACHE ENGINE=InnoDB;
12
13 SELECT NEXTVAL(seq) = 1;
14
15 --connection node_2
16
17 SELECT NEXTVAL(seq) = 2;
18
19 --connection node_1
20
21 SELECT NEXTVAL(seq) = 3;
22
23
24 # SETVAL
25
26 SELECT SETVAL(seq, 100);
27
28 --connection node_2
29
30 SELECT NEXTVAL(seq) = 101;
31
32 --connection node_1
33
34 SELECT NEXTVAL(seq) = 102;
35
36 DROP SEQUENCE seq;
37
38 # TRANSACTIONS
39
40 CREATE TABLE t1(f1 INT);
41 CREATE SEQUENCE seq_transaction NOCACHE ENGINE=InnoDB;
42
43 START TRANSACTION;
44 INSERT INTO t1 VALUES (0);
45 SELECT NEXTVAL(seq_transaction);
46 INSERT INTO t1 VALUES (NEXTVAL(seq_transaction));
47 COMMIT;
48
49 --connection node_2
50
51 SELECT COUNT(*) = 2 FROM t1;
52 SELECT NEXTVAL(seq_transaction) = 3;
53
54 --connection node_1
55 SELECT NEXTVAL(seq_transaction) = 4;
56
57 DROP SEQUENCE seq_transaction;
58 DROP TABLE t1;
59
60 --enable_ps2_protocol