Informix - Problem description
Problem IT16588 | Status: Closed |
SUBSTRING OPERATOR DOES NOT WORK CORRECTLY WITH A GLOBAL VARIABLE IN SPL | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Using the substring operator on a global variable in SPL returns the wrong result. Consider the following scenario: CREATE PROCEDURE test() returning char(10); define lx char(10); define global gx char(10) default "-" ; let gx='1234567890'; let gx[9,9]='X'; let lx=gx; let lx[9,9]='Y'; let gx=lx; return gx; end procedure; The end result should be '12345678Y0' but because of this defect, it is something like 'X2345678Y0'. It appears to be specific to global variables. Local variables do not seem to suffer the same fate. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Informix user with SPL having global string substr operation * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC8 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.08.2016 09.12.2016 09.12.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC8 | |
Problem solved according to the fixlist(s) of the following version(s) |