| Ticket Hash: | a8b1e82b8f93415ed4601be04469bcfee91ff43d | |||
| Title: | CAST failing for numeric | |||
| Status: | Closed | Type: | Code_Defect | |
| Severity: | Severe | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Not_A_Bug | |
| Last Modified: | 2009-09-22 13:00:57 | |||
| Version Found In: | 3.6.18 | |||
| Description: | ||||
|
While
SELECT CAST(COALESCE(SUM(amount), 0) AS INTEGER returns as expected an integer, CAST doesn't work for NUMERIC: SELECT CAST(COALESCE(SUM(amount), 0) AS NUMERIC always returns float drh added on 2009-09-22 13:00:57: | ||||