The SAS FedSQL SUM function returns incorrect results when the sum of integers is outside of the supported integer range.  

For information about the FedSQL data types, including the supported range of integer values, see the "Data Types" section in SAS 9.4 FedSQL Language Reference.

Click the Hot Fix tab in this note to access the hot fix for this issue.

After you apply the hot fix, instead of receiving an incorrect result, an error message is written to the SAS log stating that the SUM function result is out of range.

Update Your Software to Fix This Issue

The correction for the issue is to update your version of SAS^® Viya^®. A link to the instructions about how to access and apply the software update is available on the Hot Fix tab. 

Verify That the Update Has Been Installed

To verify that the fix is installed, run the following rpm commands:

To complete this process, make sure that the package versions shown in the rpm output either match or are newer than the following:

Operating System and Release Information

An update for this issue is available for SAS Viya 3.3. For instructions on how to access and apply software updates, see the Managing Your Software section of the SAS Viya 3.3 Administration document at