IT33874: QUERY USING ROWID AND DOUBLE QUOTES WITH DELIMIDENT SET CRASHES IN EVALCOLS

APAR status

• Closed as program error.

Error description

• Facing several assertions when issuing the following type of
  query:
  Running the following query I was able to reproduce the issue:
    SELECT rowid, "xyz" FROM (SELECT COUNT(*) "xyz" FROM
        "stores":"informix"."table_a" "table_xyz") abc WHERE
      "xyz">(0)
  
  The stack signature shows:
  oninit :: evalcols
  oninit :: getrow
  oninit :: fetchrow
  oninit :: exfetch
  oninit :: sql_nfetch
  oninit :: sq_nfetch
  oninit :: sqmain
  oninit :: listen_verify
  oninit :: spawn_thread
  oninit :: th_init_initgls
  oninit :: startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Facing several assertions when issuing the following type of *
  * query:                                                       *
  *                                                              *
  * Running the following query reproduces the issue:            *
  *                                                              *
  *   SELECT rowid, "xyz" FROM (SELECT COUNT(*) "xyz" FROM       *
  *       "stores":"informix"."table_a" "table_xyz") abc WHERE   *
  *     "xyz">(0)                                                *
  *                                                              *
  * The stack signature shows:                                   *
  * oninit :: evalcols                                           *
  * oninit :: getrow                                             *
  * oninit :: fetchrow                                           *
  * oninit :: exfetch                                            *
  * oninit :: sql_nfetch                                         *
  * oninit :: sq_nfetch                                          *
  * oninit :: sqmain                                             *
  * oninit :: listen_verify                                      *
  * oninit :: spawn_thread                                       *
  * oninit :: th_init_initgls                                    *
  * oninit :: startup                                            *
  ****************************************************************
  * 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 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