Issue Details (XML | Word | Printable)

Key: CORE-1428
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

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

Incorrect timestamp substraction in 3 dialect when result is negative number

Created: 27/Aug/07 05:41 PM   Updated: 06/Oct/08 11:12 AM
Component/s: Engine
Affects Version/s: 2.0.0, 2.0.1, 2.1 Beta 1, 2.0.2
Fix Version/s: 2.1 Beta 2

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
SELECT (CAST('2007-08-22 00:00:00.0019' AS TIMESTAMP) - CAST('2007-08-22 00:00:00.0000' AS TIMESTAMP)) *86400*10000
  FROM RDB$DATABASE

produced 19,008

while

SELECT (CAST('2007-08-22 00:00:00.0000' AS TIMESTAMP) - CAST('2007-08-22 00:00:00.0019' AS TIMESTAMP)) *86400*10000
  FROM RDB$DATABASE

produced -18,144

 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 - 06/Oct/08 11:12 AM
Q/A test ok