Informix - Problem description
Problem IT35235 | Status: Closed |
-626/-103 ALTERING A TABLE WHEN COLUMN IS CHANGED TO SERIAL AND PRIMARY KEY CONSTRAINT IS ADDED SAME TIME | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Consider these SQL commands: drop table t10; create table t10 (f1 int, f2 char(10)); insert into t10 values (1,"eins"); insert into t10 values (2,"zwei"); alter table t10 modify f1 serial, add constraint primary key (f1); The last alter statement fails with: 626: Cannot obtain or set serial value. 103: ISAM error: illegal key descriptor (too many parts or too long). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC4. * **************************************************************** | |
Local Fix: | |
A workaround is: alter table t10 add constraint primary key (f1), modify f1 serial; ...but that is a defect and is fixed where this is fixed. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC4. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC4. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.12.2020 10.12.2020 10.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |