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?