Archives of the TeradataForum

Message Posted: Mon, 01 May 2006 @ 22:20:19 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Problem Creating SEQUENCE using Identity column

From:		Anomy Anom

<-- Anonymously Posted: Monday, May 01, 2006 17:54 -->

I tried to create a system generated SEQUENCE using identity column and have defined the identity column as.

     ID_COL INTEGER GENERATED ALWAYS AS IDENTITY
          (START WITH 1
           INCREMENT BY 1
           MINVALUE 1
           MAXVALUE 2147483647
           NO CYCLE))

When rows are inserted with a Ins-Sel, the value for ID_COL starts with 1 and goes until, say some 12343 and suddenly the next row value jumps to 6 digit number 100001 and from then on increments by 1. Is this a bug or the system just tries to find a unique value for each row. I understand row_count() would be useful here, but looking for a system generated SEQUENCE.


	<Prev	Next>		<<First	<Prev	Next>	Last>>