# 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.

## 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()
```

## 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
```

## APAR Information

IC87303

• ### Reported component name

SOLID UNIVERSL

5724W9100

650

CLOSED PER

NoPE

NoHIPER

NoSpecatt

2012-10-17

2012-10-22

2012-10-22

IC88017

## Fix information

• ### Fixed component name

SOLID UNIVERSL

5724W9100

UP

## Document information

### More support for:

IBM solidDB
solidDB Universal Cache

650

IC87303

2012-10-22