2 Replies Latest reply on Nov 20, 2014 2:32 PM by Steven Hawkins

    TestFunction fails for the Cairo (GMT+2) time zone on Teiid-8.9.0-CR3

    Alex K. Newbie

      Hi all,

      if I switch my OS to the Cairo (GMT+2) time zone (other time zones seem ok)  and then run the following tests inside the engine folder of Teiid:

      mvn -Dtest=TestFunction#testTimestampDiffTimeStamp_Min_3 test
      

      or

      mvn -Dtest=TestFunction#testTimestampDiffTimeStamp_Min_4 test
      

       

      I got the following exception:

       

      Running org.teiid.query.function.TestFunction
      Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.103 sec <<< FAILURE!
      testTimestampDiffTimeStamp_Min_3(org.teiid.query.function.TestFunction)  Time elapsed: 0.032 sec  <<< FAILURE!
      java.lang.AssertionError: timestampDiff(SQL_TSI_MINUTE, 2001-09-26 12:07:58.000065497, 2001-09-29 11:25:42.000483219) failed expected:<4278> but was:<4338>
              at org.junit.Assert.fail(Assert.java:88)
              at org.junit.Assert.failNotEquals(Assert.java:743)
              at org.junit.Assert.assertEquals(Assert.java:118)
              at org.teiid.query.function.TestFunction.helpTestTimestampDiff(TestFunction.java:187)
              at org.teiid.query.function.TestFunction.testTimestampDiffTimeStamp_Min_3(TestFunction.java:940)
      
      
      Running org.teiid.query.sql.symbol.TestFunction
      Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
      
      
      Results :
      
      
      Failed tests:
        TestFunction.testTimestampDiffTimeStamp_Min_3:940->helpTestTimestampDiff:187 timestampDiff(SQL_TSI_MINUTE, 2001-09-26 12:07:58.000065497, 2001-09-29 11:25:42.000483219) failed expected:<4278> but was:<4338>
      
      
      Tests run: 1, Failures: 1, Errors: 0, Skipped: 0
      

       

       

      Any ideas?