Sequence number being resetted

Database
KVB
Enthusiast

Sequence number being resetted

Hi all,

I have a table with one of the columns using sequence generator.It is being resetted after somepoint of time.below is the identity column.Is there anythign wrong with the declaration.Though I mentioned CYCLE it should repeat after the end of the maximum number.

CT ABC

(

ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY

           (START WITH 100000000

            INCREMENT BY 1

            MINVALUE 100000000

            MAXVALUE 2147483647

            CYCLE)

);

Regards

KVB

2 REPLIES
Enthusiast

Re: Sequence number being resetted

I use the following:

CT ABC
(
ID INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 100000000 NO CYCLE)

);

It creates a unique value, but not a sequential number

Muliple inserts in the table are possible without having duplicates on ID

regards

Youri

KVB
Enthusiast

Re: Sequence number being resetted

Thank you Youri.