Informix - Problem description
Problem IT13889 | Status: Closed |
ERROR 556 WHEN QUERY INVOLVES REMOTE TABLE AND LEFT JOIN | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Error -556 is thrown when executing a query involving a remote table and a left join. The stack trace is as follows: afstack afhandler affail_interface check_traperror sqerr remgerr remprepmsg remprepare bldtext opbrstmt opbldremote sqoptim bldstructs sqcmd sq_cmnd sq_prepare sqmain listen_verify spawn_thread th_init_initgls startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of 12.10.xC1 through 12.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * An ISTAR query may return -556 error under the following * * conditions: * * - query is in ANSI JOIN syntax * * - query has two remote tables from the same remote site * * joined together, and the ON-clause contains a subquery * * - the subquery references another remote table from a * * different remote site * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.02.2016 28.06.2016 28.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC7 | |
Problem solved according to the fixlist(s) of the following version(s) |