Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 3/25/2007
For: Version 1.01 Build 1
# 2286 Using 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



Resolution Resolution
Fixed Problem on 3/26/2007 in version 1.02 build 1


Products Affected Products Affected
ElevateDB 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

Image