ten24/Slatwall — pull request #856 by joebrislin (2012-09-25 18:31:15+00:00)
Title: Arithmetic overflow error converting expression to data type int.

This is a bug fix for when receiving the following error "Arithmetic overflow error converting expression to data type int." When using SUM in a SQL statement, MS SQL cannot promote an int to a bigint so receive the artithmetic overflow error because the number is too large. If you cast the POWER value within the sum to a bigint prior to the SUM method running, it corrects the issue. This has been tested with MS SQL and should work with the same syntax in MySQL but it has not been tested there.