Issue Details (XML | Word | Printable)

Key: CORE-3493
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Critical Critical
Assignee: Dmitry Yemanov
Reporter: Marc Biegota
Votes: 0
Watchers: 2
Operations

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

Adding a value to a timestamp below '16.11.1858 00:00:01' throws 'value exceeds the range for valid timestamp'

Created: 25/May/11 10:02 AM   Updated: 08/Apr/14 12:51 PM
Component/s: Engine
Affects Version/s: 2.5.0
Fix Version/s: 2.5.1, 3.0 Alpha 1

Time Tracking:
Not Specified

Environment: firebird 2.5 on ubuntu
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
After updating from FB 2.1.3 to F 2.5 we've got some troubles with adding values to timestamps.
Following statement runs on FB 2.1.3 without problems (ISO8859_1):

SELECT CAST('01.01.0200 12:00:00' as timestamp) + 1 from rdb$database

On F 2.5 we've got 'value exceeds the range for valid timestamp'

The first timestamp value that is working on FB2.5 is November 16, 1858

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.