Reported By: Ole Willy Tuv Reported On: 3/25/2007 For: Version 1.01 Build 1
# 2286Using SUM, RUNSUM, or AVG with SMALLINT Columns Results in NULL Seems to be an issue with SMALLINT (the column type of "Order Details".Quantity). A cast to any other numeric type returns the correct values.
SELECT
ProductName,
SUM(Quantity) AS Total
FROM
Products P
JOIN "Order Details" OD ON OD.ProductID = P.ProductID
JOIN Orders O ON O.OrderID = OD.OrderId
JOIN Customers C ON C.CustomerID = O.CustomerID
WHERE
C.CustomerID = 'BERGS'
GROUP BY ProductName
ResolutionFixed Problem on 3/26/2007 in version 1.02 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial