You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org> on 2006/09/20 11:12:25 UTC

[jira] Updated: (DERBY-1869) lang/timestampArith.java fails if it starts right before midnight

     [ http://issues.apache.org/jira/browse/DERBY-1869?page=all ]

Knut Anders Hatlen updated DERBY-1869:
--------------------------------------

    Attachment: 1869.diff

The test already has code to prevent it from being run too close to midnight. The code checks whether the time is 23:58, and if it is, waits until it is 23:59. This is obviously not correct. The attached patch changes the test so that it waits until it is past midnight if the time is more than 23:58.

> lang/timestampArith.java fails if it starts right before midnight
> -----------------------------------------------------------------
>
>                 Key: DERBY-1869
>                 URL: http://issues.apache.org/jira/browse/DERBY-1869
>             Project: Derby
>          Issue Type: Bug
>          Components: Test, Regression Test Failure
>    Affects Versions: 10.0.2.1
>            Reporter: Knut Anders Hatlen
>         Assigned To: Knut Anders Hatlen
>            Priority: Minor
>         Attachments: 1869.diff
>
>
> If lang/timestampArith.java is started right before midnight, it might fail because timestamps that should have had the same date, get different dates.
> ********* Diff file derbyall/derbylang/timestampArith.diff
> *** Start: timestampArith jdk1.5.0_04 derbyall:derbylang 2006-09-12 23:59:52 ***
> 2 del
> < PASSED.
> 2 add
> > Unexpected exception from Statement 'values( {fn TIMESTAMPDIFF( SQL_TSI_FRAC_SECOND, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx'},{t '10:00:00'})})'
> > Unexpected exception:
> >     The resulting value is outside the range for the data type INTEGER.
> > ERROR 22003: The resulting value is outside the range for the data type INTEGER.
> ....

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira