Archives of the TeradataForum
Message Posted: Mon, 01 May 2006 @ 22:20:19 GMT
| 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
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.