Debian Codegraph @

mysql-test/suite/galera/r/galera_sequences_recovery.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE SEQUENCE s INCREMENT=0 CACHE=5 ENGINE=InnoDB;
5 CREATE TABLE t1 (f1 INT PRIMARY KEY DEFAULT NEXTVAL(s), f2 INT) ENGINE=InnoDB;
6 connection node_1;
7 BEGIN;
8 INSERT INTO t1(f2) values (1);
9 INSERT INTO t1(f2) values (1);
10 INSERT INTO t1(f2) values (1);
11 INSERT INTO t1(f2) values (1);
12 INSERT INTO t1(f2) values (1);
13 connection node_2;
14 BEGIN;
15 INSERT INTO t1(f2) values (2);
16 INSERT INTO t1(f2) values (2);
17 INSERT INTO t1(f2) values (2);
18 Killing server ...
19 SELECT NEXTVAL(s);
20 NEXTVAL(s)
21 12
22 connection node_1;
23 INSERT INTO t1(f2) values (1);
24 INSERT INTO t1(f2) values (1);
25 INSERT INTO t1(f2) values (1);
26 INSERT INTO t1(f2) values (1);
27 INSERT INTO t1(f2) values (1);
28 COMMIT;
29 SELECT LASTVAL(s);
30 LASTVAL(s)
31 29
32 SELECT * FROM t1;
33 f1 f2
34 1 1
35 3 1
36 5 1
37 7 1
38 9 1
39 21 1
40 23 1
41 25 1
42 27 1
43 29 1
44 connection node_2;
45 SELECT LASTVAL(s);
46 LASTVAL(s)
47 12
48 SELECT NEXTVAL(s);
49 NEXTVAL(s)
50 32
51 SELECT * FROM t1;
52 f1 f2
53 1 1
54 3 1
55 5 1
56 7 1
57 9 1
58 21 1
59 23 1
60 25 1
61 27 1
62 29 1
63 connection node_1;
64 DROP TABLE t1;
65 DROP SEQUENCE s;
66 connection node_1;
67 CREATE SEQUENCE s INCREMENT=0 CACHE=5 ENGINE=InnoDB;
68 CREATE TABLE t1 (f1 INT PRIMARY KEY DEFAULT NEXTVAL(s), f2 INT) ENGINE=InnoDB;
69 connection node_1;
70 BEGIN;
71 INSERT INTO t1(f2) values (1);
72 INSERT INTO t1(f2) values (1);
73 INSERT INTO t1(f2) values (1);
74 INSERT INTO t1(f2) values (1);
75 INSERT INTO t1(f2) values (1);
76 connection node_2;
77 BEGIN;
78 INSERT INTO t1(f2) values (2);
79 INSERT INTO t1(f2) values (2);
80 INSERT INTO t1(f2) values (2);
81 INSERT INTO t1(f2) values (2);
82 INSERT INTO t1(f2) values (2);
83 INSERT INTO t1(f2) values (2);
84 Killing server ...
85 connection node_1;
86 INSERT INTO t1(f2) values (1);
87 INSERT INTO t1(f2) values (1);
88 INSERT INTO t1(f2) values (1);
89 INSERT INTO t1(f2) values (1);
90 INSERT INTO t1(f2) values (1);
91 COMMIT;
92 SELECT LASTVAL(s);
93 LASTVAL(s)
94 19
95 SELECT * FROM t1;
96 f1 f2
97 1 1
98 3 1
99 5 1
100 7 1
101 9 1
102 11 1
103 13 1
104 15 1
105 17 1
106 19 1
107 connection node_2;
108 SELECT NEXTVAL(s);
109 NEXTVAL(s)
110 22
111 SELECT * FROM t1;
112 f1 f2
113 1 1
114 3 1
115 5 1
116 7 1
117 9 1
118 11 1
119 13 1
120 15 1
121 17 1
122 19 1
123 connection node_1;
124 SELECT LASTVAL(s);
125 LASTVAL(s)
126 19
127 SELECT NEXTVAL(s);
128 NEXTVAL(s)
129 33
130 connection node_1;
131 DROP TABLE t1;
132 DROP SEQUENCE s;