on 10-30-2015 3:37 PM
Hi everyone,
I faced with strange behavior of auto-increment column.
It happens in ordinary table without Foreign Constraints, Triggers and etc.
Auto-increment for id column (numeric(10)) works as usual - add 1 to every new row.
But sometime it 'jumps' to billion. You can see it on pictures bellow:
You can see the jumps happen randomly. First was after 200 records second was after next 690.
At the moment I have 4 such jumps and I am not sure this won't happen again.
Has anybody seen something like this before?
Are you using MobiLink or SQL Remote?
Have these rows been inserted on remote databases where the column is defined with DEFAULT GLOBAL AUTOINCREMENT ( 1000000000 ), and then uploaded to the consolidated database that you are looking at?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Torsten,
I have never seen this kind of phenomenon before.
Could you explain the detailed procedure that confirmed this phenomenon to me?
What is the detailed version of the SQL Anywhere? (SA16.0.1.xxxx)
Thanks,
Atsushi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.