Floor & ceiling functions give wrong results with exact numeric arguments [CORE1677] #2102
Comments
Modified by: stephano (stephano)description: select floor(cast(1500 as numeric(18,5))) from rdb$database -> -4827 (wrong) Actually, any precision higher than 6 gives a wrong result. => select floor(cast(1500 as numeric(18,5))) from rdb$database -> -4827 (wrong) Actually, any precision higher than 6 gives a wrong result. summary: Floor functions gives wrong result with exact numeric argument => Floor & ceiling functions give wrong results with exact numeric arguments |
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
|
Commented by: @asfernandes The bug is fixed... I'm maintaining the ticket opened because: |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.1 RC1 [ 10201 ] |
Modified by: @pcisarWorkflow: jira [ 13802 ] => Firebird [ 14114 ] |
Modified by: @pmakowski |
|
Commented by: @pmakowski Q/A test made ok |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: stephano (stephano)
Is related to QA207
select floor(cast(1500 as numeric(18,5))) from rdb$database -> -4827 (wrong)
select floor(cast(1500 as numeric(18,4))) from rdb$database -> 1500 (correct)
select ceiling(cast(1500 as numeric(18,5))) from rdb$database -> -4826 (wrong)
Actually, any precision higher than 6 gives a wrong result.
Commits: 1c40b7d
The text was updated successfully, but these errors were encountered: