IT43752: 9952 - AGGREGATE WITHIN A ROW IN A SELECT PROJECTION LIST IS NOTALLOWED

APAR status

• Closed as program error.

Error description

• Aggregate within a ROW in a SELECT projection list is not
  allowed
  
  create view "dbo".dirdoc1
  (
  typv,
  predpona,
  eecyear,
  eecnum,
  popivaz
  ) as select x0.typv ,
  min(row(x1.eecyear ,x1.eecnum , x1.predpona )::eec ).predpona ,
  min(row(x1.eecyear , x1.eecnum , x1.predpona )::eec ).eecyear ,
  min(row(x1.eecyear , x1.eecnum , x1.predpona )::eec ).eecnum ,
  max(x0.popivaz ) from "dbo".typv x0 , outer("dbo".dirdoc x1 )
  where ( x0.typv = x1.typv ) group by x0.typv ;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC16 and 14.10.xC11. *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC16 or 14.10.xC11 (when    *
  * available).                                                  *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC16 and 14.10.xC11.
  

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