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:02:22 UTC
[jira] Created: (DERBY-1869) lang/timestampArith.java fails if it
starts right before midnight
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: Regression Test Failure, Test
Affects Versions: 10.0.2.1
Reporter: Knut Anders Hatlen
Assigned To: Knut Anders Hatlen
Priority: Minor
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
[jira] Updated: (DERBY-1869) lang/timestampArith.java fails if it
starts right before midnight
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ 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
[jira] Closed: (DERBY-1869) lang/timestampArith.java fails if it
starts right before midnight
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1869?page=all ]
Knut Anders Hatlen closed DERBY-1869.
-------------------------------------
Fix Version/s: 10.3.0.0
Resolution: Fixed
Committed revision 448133.
> 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
> Fix For: 10.3.0.0
>
> 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