IBM Support

IT17894: PREDICATE COMPARING SUBSTR ON CODEUNITES32 COLUMN IN THE COLUMNAR ORGANIZED TABLE TO HOST VAR COULD RETURN AN INCORRECT RESULT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • PREDICATE COMPARING SUBSTR ON CODEUNITES32 COLUMN  IN THE
    COLUMNAR
    ORGANIZED TABLE TO A HOST VARIABLE OR A LITERAL COULD RETURN AN
    INCORRECT RESULT
    
    Example:
    
    CREATE TABLE TEST_SUBSTR (TEST CHAR(2 CODEUNITS32)) organize by
    column;
    
    INSERT INTO TEST_SUBSTR VALUES ('AE');
    
    select * from TEST_SUBSTR WHERE SUBSTR(TEST, 1, 1) = 'A' ;
    
    should return a row, but could return with 0 rows
    
    select * from  TEST_SUBSTR WHERE  TEST= CAST('AE' as CHAR(2
    CODEUNITS32));
    
    should return a row, but could return with 0 rows
    

Local fix

  • Install this fix or use a an organized by row table.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 11.1 Mod 2 Fix Pack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT17894

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-11-10

  • Closed date

    2017-06-28

  • Last modified date

    2017-06-28

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

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

    IT18119 IT18237

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020