Informix - Problem description
Problem IT11265 | Status: Closed |
WHERE CLAUSE SELECTION BEHAVIOR IN TRIGGER IS INCORRECT | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A trigger is created to provide an incremental value based on two fields. In simplest terms, if col1 + col2 are the same, increment col3 by 1. Example output: 1|111|1001 2|111|1001 3|111|1001 4|111|1001 1|111|1002 2|111|1002 3|111|1002 4|111|1002 4|111|1003 The behavior on 11.50 works correctly. On 11.70 and 12.10 it appears to ignore the second column needed in the the trigger as it selects the column. Example output: 1|111|1001 2|111|1001 3|111|1001 4|111|1001 1|111|1001 2|111|1001 3|111|1001 4|111|1001 4|111|1001 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users having triggers in their application * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.09.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) |