IC83913: SELECT FROM A VIEW RETURNS ILLEGAL COLUMN NAME ERROR

6.5 Fix Pack 11 download information for solidDB and solidDB Universal Cache

APAR status

• Closed as program error.

Error description

• In a database with a long view definition, solidDB returns 'SQL
  Error 13' when trying to query the view.
  
  SELECT * FROM TEST_VIEW;
  
  SOLID SQL Error 13: illegal column name 'column_A'
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM solidDB V6.5.0.10 Interim Fix 9.              *
  ****************************************************************
  

Problem conclusion

• Fix is included in IBM solidDB V6.5.0.10 Interim Fix 9.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IC83912

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SOLIDDB-DB2/IDS

• Fixed component ID

  5724V1700

Applicable component levels

• R650 PSY

     UP