APAR status
Closed as program error.
Error 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
Local fix
The problem doesn't occur when view folding is turned off (onconfig IFX_FOLDVIEW 0).
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. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
Temporary fix
Comments
APAR Information
APAR number
IT33945
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-08-19
Closed date
2021-01-25
Last modified date
2021-01-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
Document Information
Modified date:
26 January 2021