[DERBY-1869] lang/timestampArith.java fails if it starts right before midnight

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.1
• Fix Version/s: 10.3.1.4
• Component/s: Test
• Bug behavior facts: Regression Test Failure
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 20/Sep/06 09:00
• Updated: 29/Jun/09 22:42
• Resolved: 20/Sep/06 09:14

Description

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(
      Unknown macro: {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.
      ....