Defect related to using the lpad function of version 12.10.FC14
Hello All,
I would like to share the defects found in the Informix 12.10.FC14 version of the customer's development environment.
If the source string of the lpad function is an empty string, -202 error occurs as shown below. So was the rpad.
If the locale of the database is en_us.utf8 or ko_kr.ksc, an error occurs. No error in en_us.819. I'm guessing this is probably a problem with a multi-byte codeset.
The lpad function works well in 12.10.FC13 and 11.70.FC9 that customers are using.
Today I asked IBM to open the case, and it has not yet been officially confirmed as a defect by IBM.
Please refer to those who plan to apply the 12.10.FC14 fix pack.
/work2/INFORMIX/1210FC14]export DB_LOCALE=en_us.utf8
/work2/INFORMIX/1210FC14]export CLIENT_LOCALE=en_us.utf8
/work2/INFORMIX/1210FC14]echo "create database tdb with log" | dbaccess -
Database created.
Database closed.
/work2/INFORMIX/1210FC14]dbaccess tdb -
Database selected.
> select lpad ( '', 2, '0' ) from sysmaster:sysdual;
202: An illegal character has been found in the statement.
Error in line 1Near character position 48
> select rpad ( '', 2, '0' ) from sysmaster:sysdual;
202: An illegal character has been found in the statement.
Error in line 1Near character position 48
>
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
#Informix
APAR IT32236 "LPAD() and RPAD() on empty string getting -202 when used in multi-byte character set database" has been entered. And yup, this seems to be new in 12.10.xC14. Thanks for reporting! Still, please, don't make it a habit to report here instead of or prior to raising with tech support ;-) ------------------------------ Andreas Legner ------------------------------
Sorry. I found on reflection that I had been very careless. Thank you for checking. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------