Informix - Problem description
Problem IT33945 | Status: Closed |
CRASH IN FOLDVIEWS() ... VIEWINFO() WITH UNION VIEW JOINED TO TABLE EXPRESSION | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A query joining a UNION view to a table expression would fail with an exception in the optimizer. It either would return error 874 (general optimizer exception, indicating exception got handled) or errors 959/172, indicating the session crashed but could be suspended or even "25582: Network connection is broken" if the whole server crashed. The assertion stack would contain the following up to the signal frame: viewinfo process_view_colltbl_expr processview foldviews sqoptim | |
Problem Summary: | |
**************************************************************** * 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. * **************************************************************** | |
Local Fix: | |
The problem doesn't occur when view folding is turned off (onconfig IFX_FOLDVIEW 0). | |
Solution | |
Workaround | |
**************************************************************** * 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. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.08.2020 25.01.2021 25.01.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |