Informix - Problem description
Problem IT16176 | Status: Closed |
-768 ERROR IN OPJOIN WITH IFX_FOLDVIEW SET | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When a specific query using ANSI JOINS and table expressions is run with IFX_FOLDVIEW set to 1 , the server reports an error -768 in routine. The -768 error comes with the following stack: (oninit) afstack (oninit) afhandler (oninit) affail_interface (oninit) check_traperror (oninit) sqerr (oninit) sqerr1 (oninit) opjoin (oninit) op_join (oninit) op_phasejoin (oninit) sqoptim (oninit) bldstructs (oninit) sqcmd (oninit) sq_cmnd (oninit) sq_prepare (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of 12.10.xC1 through 12.10.xC7 * **************************************************************** * PROBLEM DESCRIPTION: * * An ANSI JOIN query referencing a view or derived table may * * give -768 error under the following conditions: * * - view or derived table is in ANSI JOIN syntax, e.g. FROM * * view1 LEFT JOIN t2 on ... * * - the view definition has a nested view reference, e.g. * * FROM (t1 join t2 on ...) LEFT JOIN view2 * * - the nested view (view2) is joined in as a subservient * * table, and it's definition contains more than 1 table * * - there are at least 2 tables being joined together before * * view2 is being joined * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC8 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.07.2016 09.12.2016 09.12.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC8 | |
Problem solved according to the fixlist(s) of the following version(s) |