IT13537: DUBIOUS OR EXCESS SYSCOLAUTH ENTRIES FOR VIEW CONTAINING MATH EXPRESSIONS, FUNCTIONS OR ORDER BY

APAR status

• Closed as program error.

Error description

• When using math expressions or functions on columns of
  underlying
  tables in a view definition, you'd see syscolauth entries that
  normally aren't there after mere view creation.  This even can
  go
  as far as more such syscolauth entries than there are columns in
  the view and/or higher column numbers than those assigned to
  view
  columns.
  
  E.g. when creating a two column view (colnos 1 and 2), you might
  see syscolauth entries for colnos 2, 3 and 4 for this tabid.
  
  oncheck -cc then would complain like this:
  
      Validating syscolauth for database stores7
  ISAM error:  no record found.
  ERROR:  No column found for syscolauth record.
      Grantor
      Grantee                        informix
      Tabid                          144
      Column number                  3
      Authorization                  SU
  ISAM error:  no record found.
  ERROR:  No column found for syscolauth record.
      Grantor
      Grantee                        informix
      Tabid                          144
      Column number                  4
      Authorization                  SU
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of 11.70.xC1 through 11.70.xC8.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Creating a view may result in extra rows to be inserted in   *
  * syscolauth table under the following conditions:             *
  *   - view contains complex expressions in its projection      *
  * column, e.g., OLAP functions, math functions, etc            *
  *   - view has an ORDER BY clause, and at least some of the    *
  * ORDER BY columns (or expressions) are not present in the     *
  * projection clause                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 11.70.xC9                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 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

• RB70 PSN

     UP