Informix - Problem description
Problem IT10285 | Status: Closed |
WHEN A PARTITION IS DROPPED AND ADDED BACK USING THE BEFORE KEYWORD, THE SERIAL VALUE RESETS BACK TO 1 | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
When a table has a serial column and is fragmented by expression, if you drop and add the partition back using the "BEFORE" keyword, it resets the serial value back to 1. If you don't use the BEFORE keyword, then it does not reset the value. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IBM Informix Server 11.70.xC9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.07.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) |