IBM Support

IC76167: ASSERT FAILURE IF THE VALUE IN A SUBSCRIPT IS GREATER THAN THE NUMBER OF CHARACTERS WITHIN SINGLE QUOTES

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • If the value within brackets in a select statement is greater
    than the number of characters within single quotes, the engine
    will assert fail and crash.
    
    Example syntax:  SELECT '1234'[5] FROM TABLE'
    
    stack trace:
    
    afstack
    mt_ex_throw_sig
    afsig_handler
    p_smdotted
    p_smexpr
    p_smselect
    p_smunion
    p_smquery
    p_smstmt
    p_smentry
    spparse
    parsecmd
    sqcmd
    sq_cmnd
    sq_prepare
    sqmain
    spawn_thread
    startup
    *nosymtab
    

Local fix

  • Use this syntax instead:  SELECT '1234' FROM TABLE
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 11.50.XCX users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Server can crash when user uses this negative case i.e.      *
    * doing subscript operation on the constant string where the   *
    * index of the subscript is beyond the string length.          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IDS 11.50.xC9.                                    *
    ****************************************************************
    

Problem conclusion

  • Server will no longer crash but will return an error for the
    case i.e. doing subscript operation on the constant string where
    the index of the subscript is beyond the string length.  Fixed
    in IDS 11.50.xC9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76167

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-04

  • Closed date

    2011-09-27

  • Last modified date

    2011-09-27

  • 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

    IBM IDS ENTRP E

  • Fixed component ID

    5724L2304

Applicable component levels

  • RB15 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
27 September 2011