Informix - Problem description
Problem IT21645 | Status: Closed |
FOR A FOREIGN KEY CONSTRAINT USING A DISABLED INDEX A SEQ SCAN IS USED INSTEAD OF ANY OTHER INDEX FOR VERIFICATION | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
In a foreign key relation between 2 tables where the base index for the constraint is defined as DISABLED, the server decides to use a sequential scan for the master/detail verification in the event there are other indexes which could be also used for the check. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC10 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.07.2017 01.11.2017 01.11.2017 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC10 | |
Problem solved according to the fixlist(s) of the following version(s) |