Skip to Content
avatar image
Former Member

Issue with auto increment column in ASA 16

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?

Jump_1.jpg (4.4 kB)
jump_2.jpg (5.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 19, 2016 at 01:10 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 19, 2016 at 09:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded