Alter Fragment Problems with Serial8

Posted in 2003

Brian Foster — Tue, 22 Jul 2003 13:37:46 -0400 — source: Usenet: comp.databases.informix

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

↪ replying to Brian Foster

Madison Pruet — Tue, 22 Jul 2003 17:59:55 GMT — source: Usenet: comp.databases.informix

Do you have a case open for this? "Brian Foster" <bc_foster@hotmail.com> wrote in message news:bfjsdt$fe79d$1@ID-78326.news.uni-berlin.de... > 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 > >