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.
ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY
(START WITH 100000000
INCREMENT BY 1
I use the following:
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