Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE SEQUENCE Seq1_1 START WITH 1 INCREMENT BY 1 NOCACHE;
4 CREATE TABLE t1 (Id int(11) NOT NULL, PRIMARY KEY (Id));
5 INSERT INTO t1 VALUES (NEXT VALUE FOR Seq1_1);
6 INSERT INTO t1 VALUES (NEXT VALUE FOR Seq1_1);
7 INSERT INTO t1 VALUES (NEXT VALUE FOR Seq1_1);
8 INSERT INTO t1 VALUES (NEXT VALUE FOR Seq1_1);
9 DROP SEQUENCE Seq1_1;
10 CREATE SEQUENCE Seq1_1 START WITH 1 INCREMENT BY 1 NOCACHE;
11 INSERT INTO t1 VALUES (NEXT VALUE FOR Seq1_1);
12 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
13 DROP SEQUENCE Seq1_1;
14 DROP TABLE t1;