|
Problem IT46185
|
Status: Closed |
HUGE MEMORY CONSUMPTION USING AN LVARCHAR WITH A LIKE WITHIN A STORED PROCEDURE IN A UTF8 DATABASE
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
Using the simple SP
CREATE PROCEDURE example() ;
DEFINE p_loop INTEGER;
DEFINE p_like LVARCHAR(50);
let p_loop = 0;
while p_loop < 1000
let p_like = "12346789";
IF p_like like '%0%' then
-- do nothing
END IF
let p_loop = p_loop + 1;
END WHILE
end procedure;
where we execute a simple like on a local lvarchar variable,
each run of the SP will
cause an very large memory allocation. Its only in an UTF8
database. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.xC11. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.05.2024
12.06.2024
01.07.2024 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
