Informix - Problem description
Problem IT12813 | Status: Closed |
SERIAL COLUMN GOES OUT OF SEQUENCE WHEN ALTERED FROM SERIAL TO SERIAL8 AND SERIAL HAS WRAPPED | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
When you insert the value 0 into a serial column, the next available value will be inserted. When that value reaches the maximum value 2147483647 the internal variable tracking the serial value will wrap-around to the maximum negative value and the advance towards zero. For this range of values a positive number will still be inserted into the row. If you alter your table from a SERIAL to SERIAL8 while this internal reference is in this negative range, the sequence inserted is wrong. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Using ALTER TABLE to change a SERIAL column to either * * SERIAL8 or BIGSERIAL data type after a wrap around of the * * serial value happened. * **************************************************************** * PROBLEM DESCRIPTION: * * Doing an ALTER TABLE to change a SERIAL column to either * * SERIAL8 or BIGSERIAL data type after a wrap around of the * * serial value happened causes the serial value to restart * * from 1 instead of continuing with a value of MAXINT + 1. * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 or later version. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.12.2015 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |