IC87303: NUMERIC VALUES USE DOUBLE PRECISION WITH SUM() TYPE FUNCTIONS

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

  • The solidDB server promotes numeric type values to DOUBLE
    PRECISION (not NUMERIC or DECIMAL) in some calculations. When
    DOUBLE PRECISION is used, required precision can be lost.
    
    The following functions are affected:
    SUM()
    AVG()
    ABS()
    FLOOR()
    CEILING()
    

Local fix

Problem summary

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

Problem conclusion

  • Fix is available in IBM solidDB 6.5 Interim Fix 12.
    
    With the fix, the precision level can be controlled with the new
    parameter SQL.PreferExactNumericFunctions=yes.
    
    The factory value of SQL.PreferExactNumericFunctions is 'no'.
    
    When set to 'yes':
    
    - If the argument of SUM() or AVG() function is of exact numeric
    datatype (TINYINT, SMALLINT, INTEGER,
    BIGINT, NUMERIC or DECIMAL), the function returns the result in
    DECIMAL data type. The default precision of DECIMAL is 52 and
    scale is floating.
    
    - Functions FLOOR() CEILING() and ABS() return their result in
    the same data type as the argument.
    
    Note: The parameter can be set only by editing the solid.ini
    file.
    
    [SQL]
    PreferExactNumericFunctions=yes
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC87303

  • Reported component name

    SOLID UNIVERSL

  • Reported component ID

    5724W9100

  • Reported release

    650

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-17

  • Closed date

    2012-10-22

  • Last modified date

    2012-10-22

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

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

    IC88017

Fix information

  • Fixed component name

    SOLID UNIVERSL

  • Fixed component ID

    5724W9100

Applicable component levels

  • R650 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM solidDB
solidDB Universal Cache

Software version:

650

Reference #:

IC87303

Modified date:

2012-10-22

Translate my page

Machine Translation

Content navigation