Icon View Incident Report

Minor Minor
Reported By: Sanford Aranoff
Reported On: 6/10/2005
For: Version 4.21 Build 3
# 2079 Using the SQL STDDEV Aggregate Function with a HAVING Clause Causes Invalid Floating Point Exception

The following SQL causes an "Invalid floating point exception" error.

select  extract (year from s.TradeDate) as Year, sum(s.Profit) as [Real P&L],
sum(s.ImgProfit) as [Unreal P&L], Max(s.profit), Min(s.Profit),
Count(s.Profit), Avg(s.Profit), Round(StdDev(s.Profit)) from StockTraded s
group by year
having ([Real P&L] > 0.01 or [Real P&L] < -0.01)
order by year desc



Comments Comments
The STDDEV() function was being evaluated more than once, thus causing the error due to the invalid inputs on the second evaluation.


Resolution Resolution
Fixed Problem on 6/18/2005 in version 4.21 build 5


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

Image