Informix - Problembeschreibung
Problem IT27610 | Status: Geschlossen |
SYSTEM THROWS 674 ERROR WHEN SYS_CONNECT_BY_PATH IS USED MORE THAN ONCE IN SQL QUERY | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
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. | |
Problem-Zusammenfassung: | |
**************************************************************** * 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: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.12.2018 03.10.2019 03.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC13 | |
Problem behoben lt. FixList in der Version |