View Incident Report

Serious

Reported By: Robert Kaplan
Reported On: 12/19/2001
For: Version 3.03 Build 1

# 988 CAST Function Not Working Properly When Casting to DECIMAL (BCD) Field Type

The following SQL returns 0 for the InUse column even though it should not:

SELECT ID, CR_NAME, CR_SHNAME,
    PL_CUST, SUM(PL_TOTPRIN) Balance, SUM(IF (PL_UNDERLINE = FALSE THEN 
CAST (0 AS DECIMAL) ELSE PL_TOTPRIN)) InUse
FROM PLANS  
LEFT OUTER JOIN CUSTTABLE ON  ID =  PL_CUST
group by ID
ORDER BY CR_SHNAME

Resolution

Fixed Problem on 12/20/2001 in version 3.04 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap