Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_sequence.inc
4
5 CREATE SEQUENCE Seq1_1 START WITH 1 INCREMENT BY 1 NOCACHE;
6 CREATE TABLE t1 (Id int(11) NOT NULL, PRIMARY KEY (Id));
7 INSERT INTO t1 VALUES (NEXT VALUE FOR Seq1_1);
8 INSERT INTO t1 VALUES (NEXT VALUE FOR Seq1_1);
9 INSERT INTO t1 VALUES (NEXT VALUE FOR Seq1_1);
10 INSERT INTO t1 VALUES (NEXT VALUE FOR Seq1_1);
11 DROP SEQUENCE Seq1_1;
12 CREATE SEQUENCE Seq1_1 START WITH 1 INCREMENT BY 1 NOCACHE;
13 --error ER_DUP_ENTRY
14 INSERT INTO t1 VALUES (NEXT VALUE FOR Seq1_1);
15 DROP SEQUENCE Seq1_1;
16 DROP TABLE t1;