IT00620: COMPLICATED QUERY USING TABLE EXPRESSIONS AND ANSI JOINS CAN CAUSE EXCEPTION IN AJ_ATTFL

APAR status

• Closed as program error.

Error description

• Server reported an assertion failure when application was
  executing a query using
  table expressions and ANSI joins. The stack reported in the af
  file looks like:
  
  oninit :: aj_attfl
  oninit :: opfiltr
  oninit :: opinit
  oninit :: op_opinit
  oninit :: sqoptim
  oninit :: optsubq
  oninit :: sqoptim
  oninit :: bldstructs
  oninit :: sqcmd
  oninit :: sq_cmnd
  oninit :: sq_prepare
  oninit :: sqmain
  oninit :: listen_verify
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All 11.70 users.                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query with view or derived table references may result in  *
  * assertion failure under the following conditions:            *
  *   - IFX_FOLDVIEW is set to 1 in onconfig file                *
  *   - a view or derived table has a correlated subquery in the *
  * projection list of the view or derived table definition;     *
  * let's refer to this subquery column as column "v_subq"       *
  *   - in the main query, or a subquery of the main query, ANSI *
  * JOIN syntax must be used, and in the WHERE clause of the     *
  * ANSI JOIN, there exists a filter predicate on the "v_subq"   *
  * column of a view or derived table, e.g., view.v_subq = 5     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC9                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC9
  

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