IT03042: -392 error in complex ANSI JOIN query when it includes a UNION ALL view and another view with group by and aggregation.

APAR status

• Closed as program error.

Error description

• The error   "392: SYSTEM ERROR - UNEXPECTED NULL POINTER
  ENCOUNTERED." may occur  on 12.10.FC3XB and 12.10.FC3XE.
  
  A UNION ALL view folding enhancement was included in these
  releases. As a result of the fixes for two other defect fixes
  and this enhancement,
  the UNION ALL gets folded but the other part of the view is
  improperly materialized when there is a group by and aggregation
  in the view definition.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of 12.10.xC4                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query may return -392 error under the following            *
  * conditions:                                                  *
  *   - at least two views are involved, one UNION ALL view, and *
  * another view which contains group by and aggregation in its  *
  * definition                                                   *
  *   - the UNION ALL view is folded into the main query (i.e.   *
  * no temp table creation)                                      *
  *   - the other view with group by and aggregation is          *
  * materialized into a temp table                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-12.10.xC5                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-12.10.xC5
  

Temporary fix

Comments

APAR Information

• 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

• RC10 PSN

     UP