Debian Codegraph @

mysql-test/suite/galera/r/MDEV-27862.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE SEQUENCE seq NOCACHE ENGINE=InnoDB;
5 SELECT NEXTVAL(seq) = 1;
6 NEXTVAL(seq) = 1
7 1
8 connection node_2;
9 SELECT NEXTVAL(seq) = 2;
10 NEXTVAL(seq) = 2
11 1
12 connection node_1;
13 SELECT NEXTVAL(seq) = 3;
14 NEXTVAL(seq) = 3
15 1
16 SELECT SETVAL(seq, 100);
17 SETVAL(seq, 100)
18 100
19 connection node_2;
20 SELECT NEXTVAL(seq) = 101;
21 NEXTVAL(seq) = 101
22 1
23 connection node_1;
24 SELECT NEXTVAL(seq) = 102;
25 NEXTVAL(seq) = 102
26 1
27 DROP SEQUENCE seq;
28 CREATE TABLE t1(f1 INT);
29 CREATE SEQUENCE seq_transaction NOCACHE ENGINE=InnoDB;
30 START TRANSACTION;
31 INSERT INTO t1 VALUES (0);
32 SELECT NEXTVAL(seq_transaction);
33 NEXTVAL(seq_transaction)
34 1
35 INSERT INTO t1 VALUES (NEXTVAL(seq_transaction));
36 COMMIT;
37 connection node_2;
38 SELECT COUNT(*) = 2 FROM t1;
39 COUNT(*) = 2
40 1
41 SELECT NEXTVAL(seq_transaction) = 3;
42 NEXTVAL(seq_transaction) = 3
43 1
44 connection node_1;
45 SELECT NEXTVAL(seq_transaction) = 4;
46 NEXTVAL(seq_transaction) = 4
47 1
48 DROP SEQUENCE seq_transaction;
49 DROP TABLE t1;