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