Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi, Brian,
This is known defect #135783:
"NEXT SERIAL8 VALUE IS RESET AFTER ALTER TABLE TO ADD FRAGMENTATION"
------------------------------------------
Alexey Sonkin
Senior Database Administrator
> -----Original Message-----
> From: Brian Foster [mailto:bc_foster@hotmail.com]
> Sent: Tuesday, July 22, 2003 1:38 PM
> To: informix-list@iiug.org
> Subject: Alter Fragment Problems with Serial8
>
> Hi,
>
> I have a non-fragmented table that contains a serial8 column acting as the
> primary-key. When I attempt to consolidate space using 'Alter Fragment
> Init' the seed value for the serial8 column is reset and the engine tries
> to
> insert 1 as opposed to max(serial8 column)+1. This does not happen with
> serial columns (thank god). Is this a known bug? It is clearly not by
> design as the manual states that the engine will chose a next value using
> the lesser of SEED and (max(serial8 column)+1 ).
>
> -Brian
sending to informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.