INFORMIX SERVER / 5725A3900 / E10 - 

Procedure should return same values in both arguments but it
truncates the second return value:

DROP PROCEDURE IF EXISTS test_pr1;
CREATE PROCEDURE test_pr1 ()
RETURNING VARCHAR(255), VARCHAR(255);

DEFINE init_str
VARCHAR(255) ;
DEFINE v_var                                            CHAR(1);

LET init_str                                            =
'3000.0 in int the value of my card 221) ' ;
LET v_var
= 'N';

RETURN 'Insufficient Balance' || trim(init_str),
                NVL (
                        DECODE (v_var, 'Y', v_var, null),
                        'Insufficient Balance' || trim(init_str)
                        );

END PROCEDURE;
UPDATE STATISTICS FOR PROCEDURE test_pr1;
================================================

echo "EXECUTE PROCEDURE test_pr1();"|dbaccess stores_demo


Database selected.



(expression)  Insufficient Balance3000.0 in int the value of my
card 221)
(expression)  Insufficient Balance3000.0 in int the va


1 row(s) retrieved.



Database closed.



CREATE PROCEDURE test_ffo ()

RETURNING VARCHAR(255), VARCHAR(255);


DEFINE init_str  VARCHAR(255) ;

DEFINE v_var     CHAR(1);


LET init_str     = 'NVL TEST OUT OF THE PROCEDURE' ;

LET v_var        = 'N';


RETURN 'Address unknown' || trim(init_str),

        NVL (DECODE (v_var, 'Y', v_var, null),

             'Address unknown' || trim(init_str));


END PROCEDURE;

UPDATE STATISTICS FOR PROCEDURE test_ffo;


(expression)  Address unknownNVL TEST INSIDE THE PROCEDURE
(expression)  Address unknownNVL TEST INSIDE THE PROCE

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC15 (when available) or    *
* 14.10.xC5.                                                   *
****************************************************************

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC15 (when available) or    *
* 14.10.xC5.                                                   *
****************************************************************

Fixed in Informix Server 12.10.xC15 and 14.10.xC5.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.07.2020
07.12.2020
07.12.2020