IT03431: -392 RESULTS FROM COMPLEX ANSI JOIN QUERY WITH UNION ALL VIEW AND A SECOND 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 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. This was
  fixed by APAR IT03042. Subsequently it was discovered that when
  the STMT_CACHE is set to 2 in onconfig, the -392 error occurs
  again.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of 12.10.xC4.                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query may return -392 error under the following            *
  * conditions:                                                  *
  *   - statement cache is turned on in the ONCONFIG file        *
  * (STMT_CACHE 2)                                               *
  *   - query contains two derived tables, DT1, DT2              *
  *   - DT1 contains a UNION ALL and does not contain any group  *
  * by, order by or aggregates                                   *
  ****************************************************************
  * 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