Derby
  1. Derby
  2. DERBY-1869

lang/timestampArith.java fails if it starts right before midnight

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.1
    • Fix Version/s: 10.3.1.4
    • Component/s: Test
    • Labels:
      None
    • Bug behavior facts:
      Regression Test Failure

      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.
            ....

      1. 1869.diff
        0.8 kB
        Knut Anders Hatlen

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Knut Anders Hatlen
            Reporter:
            Knut Anders Hatlen
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development