Re: Alter Fragment Problems with Serial8

Thanks, I actually tried to look it up in the 'Product Defect Query' but gave up as I almost always do when trying to find useful information there. After all of the down-time we have experienced with that site, I think IBM owes us a better search engine! Thanks again. -Brian Alexey Sonkin wrote in message ... > >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