INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

System throws 674 error when SYS_CONNECT_BY_PATH is used more
than once in SQL query in IDS version 12.10.FC11.

Scenario 1 (SYS_CONNECT_BY_PATH used only once):

Below sql  query executes without any error.

SELECT empid, name, mgrid, SYS_CONNECT_BY_PATH( name,'/') as
hierarchy
   FROM employee
   START WITH name = 'Henry'
   CONNECT BY PRIOR empid = mgrid;

Scenario 2 (SYS_CONNECT_BY_PATH used more than once):

Below sql query when executed throws 674 error.

SELECT empid, name, mgrid,
SYS_CONNECT_BY_PATH( name,'/') as hierarchy,
SYS_CONNECT_BY_PATH( name,'/') as hierarchy1,
   FROM employee
   START WITH name = 'Henry'
   CONNECT BY PRIOR empid = mgrid;

Error message:
 674: Routine (sys_connect_by_path) can not be resolved.

Note: In IBM Informix Dynamic Server Version 12.10.FC10, the
same sql query (query with SYS_CONNECT_BY_PATH more than once)
executes without any error.
The issue is only in IDS 12.10.FC11.

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to 12.10.xC13.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* System throws 674 error when SYS_CONNECT_BY_PATH is used     *
* more than once in SQL query.                                 *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

not known / see Local fix

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

27.12.2018
03.10.2019
03.10.2019

12.10.xC13