IT26685: DB2 MAY RETURN SQL0901N WHEN EXECUTING A QUERY INVOLVING VARCHARCODEUNITS32 IMPLICIT CASTING AND COLUMNAR TABLES

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• DB2 may produce -901 error with  "unexpected error at
  MinMaxPartialEvaluator.cpp:98" when the following conditions are
  satisfied:
  1. Default string units are CODEUNITS32.
  2. The query implicitly casts non-string values (e.g. numerical,
  datetime, boolean) to VARCHAR.
  3. The query contains columnar tables.
  4. There exists a MIN or MAX aggregate function over the
  implicit cast.
  
  For example:
      UPDATE DB CFG FOR TESTDB USING STRING_UNITS CODEUNITS32;
      CREATE TABLE T( I INT ) ORGANIZE BY COLUMN;
      SELECT MAX( I || '' ) FROM T;
  

Local fix

• Modify the above query to perform an explicit cast to VARCHAR:
  SELECT MAX( CAST( I AS VARCHAR(20) ) || '' ) FROM T;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * server side fix                                              *
  ****************************************************************
  

Problem conclusion

• Problem was fixed in DB2 VERSION 111 fix pack XX
  

Temporary fix

• see local 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