Issue Details (XML | Word | Printable)

Key: CORE-1677
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Adriano dos Santos Fernandes
Reporter: stephano
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Floor & ceiling functions give wrong results with exact numeric arguments

Created: 07/Jan/08 03:12 PM   Updated: 26/Jan/09 08:25 AM
Component/s: None
Affects Version/s: 2.1 Beta 2
Fix Version/s: 2.1 RC1

Time Tracking:
Not Specified

Environment: WinXP, P4
Issue Links:
Relate
 


 Description  « Hide
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.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes added a comment - 07/Jan/08 07:55 PM
The bug is fixed... I'm maintaining the ticket opened because:
1) I don't know if it can be included in RC1
2) There is no 2.1 RC2 version in the tracker

Philippe Makowski added a comment - 13/Sep/08 03:29 PM
Q/A test made ok