RE: Alter Fragment Problems with Serial8

Posted in 2003

Alexey Sonkin — Tue, 22 Jul 2003 20:44:08 -0400 — source: Usenet: comp.databases.informix

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