cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with auto increment column in ASA 16

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member188493
Contributor
0 Kudos

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?

former_member186998
Contributor
0 Kudos

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