Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Defect related to using the lpad function of version 12.10.FC14

    Posted 03/19/20 12:04 AM
    Edited by System Admin 01/20/23 04:10 PM
    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 1
Near character position 48
> select rpad ( '', 2, '0' ) from sysmaster:sysdual;

  202: An illegal character has been found in the statement.
Error in line 1
Near character position 48
>​


    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------
    #Informix


  • 2.  RE: Defect related to using the lpad function of version 12.10.FC14

    Posted 03/19/20 09:20 AM
    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
    ------------------------------



  • 3.  RE: Defect related to using the lpad function of version 12.10.FC14

    Posted 03/19/20 10:13 AM
    Sorry. I found on reflection that I had been very careless.
    Thank you for checking.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------

    Original Message


Related Content