Issue Details (XML | Word | Printable)

Key: CORE-1582
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: prenosil
Votes: 0
Watchers: 0
Operations

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

ABS() rounds NUMERIC values

Created: 09/Nov/07 07:29 PM   Updated: 07/Oct/08 09:35 AM
Component/s: Engine
Affects Version/s: 2.1 Beta 2
Fix Version/s: 2.1 RC1

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
SELECT
  ABS(CAST(-1.23 AS NUMERIC(10,2))),
  ABS(CAST(-1.23 AS DECIMAL(10,2))),
  ABS(CAST(-1.98 AS NUMERIC(9,2))),
  ABS(CAST(-1.23 AS DECIMAL(9,2)))
  FROM RDB$DATABASE;

  ABS ABS ABS ABS
====== ====== ====== ======
  1.23 1.23 2 1

Last two values are returned as BIGINT.


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 07/Oct/08 09:35 AM
Q/A test ok