Informix - Problem description
Problem IT12041 | Status: Closed |
874 ERROR/SEGV IN OPSELEC AFTER FIX FOR APAR IT10693 WHEN USING EXPRESSION NOT EQUAL ( ) ON DATE DECEMBER 31ST, 9999 | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
After getting fix for IT10693, if the expression on the date December 31st, 9999 is changed from equal to not equal, the server will get a SEGV in opselec() and report a 874 error trying to optimize the query. Top portion of stack trace for AF'ing thread: oninit :: opselec oninit :: opselec oninit :: mc_toplevel oninit :: mc_calculate oninit :: mc_calculate oninit :: mc_calculate oninit :: mc_toplevel oninit :: oridxclausecost The important part is that opselec be in the stack twice as the 2nd call to opselec is where the problem happens. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users using patched build including fix for IT10693 * **************************************************************** * 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 : | 30.10.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) |