IT24041: WRONG RESULTS OR SQL901N ERROR POSSIBLE WHEN EXECUTING SQL STATEMENT WITH SCALAR SUBQUERY ON COLUMN ORGANIZED TABLES

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Wrong results are possible when executing a SQL statement that
  1. references column organized tables,
  2. contains a scalar subquery, and
  3. the scalar subquery is referenced in an outer join or as part
  of a NOT IN or NOT EXISTS predicate
  
  A SQL901N error is also possible when executing a SQL statement
  that
  1. references column organized tables,
  2. contains a scalar subquery, and
  3. contains a GROUP BY ROLLUP clause
  
  The SQL0901N error will include the reason:  "unexpected error
  at Parser.cpp"
  
  This can only happen in  V11.1 Fixpak 1 and up.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 LUW                                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to the latest fix pack                               *
  ****************************************************************
  

Problem conclusion

• Problem is first fixed in DB2 V11.1 mode pack 3
  

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

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP