You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jira@arrow.apache.org by "Bob Tinsman (Jira)" <ji...@apache.org> on 2021/03/13 23:06:00 UTC

[jira] [Commented] (ARROW-11957) [Java] JDBC test failures for build with timezone != UTC

    [ https://issues.apache.org/jira/browse/ARROW-11957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17301004#comment-17301004 ] 

Bob Tinsman commented on ARROW-11957:
-------------------------------------

The errors show up in time, timestamp, and date types. Sometimes the wrong values show up 8 hours ahead of the expected values, and sometimes they show up 8 hours behind. 

The test config in _pom.xml_ sets the system property _user.timezone_ to UTC. In theory this should remove the system timezone as a factor in test results, but it doesn't affect the results one way or the other. This reminds me that timezone handling is always more complicated than you think it is. :)

I can fix the errors in JdbcToArrowDataTypesTest by changing the Calendar passed to _JdbcToArrow.sqlToArrow()_ from _Calendar.getInstance()_ to _JdbcToArrowUtils.getUtcCalendar()_ but it doesn't fix other errors.

Continuing to try other possible solutions...

 

> [Java] JDBC test failures for build with timezone != UTC
> --------------------------------------------------------
>
>                 Key: ARROW-11957
>                 URL: https://issues.apache.org/jira/browse/ARROW-11957
>             Project: Apache Arrow
>          Issue Type: Bug
>          Components: Java
>            Reporter: Bob Tinsman
>            Priority: Major
>
> Run "mvn install" in the java directory on a system with timezone set to PST (Pacific Standard, 8 hours behind UTC).
> For the arrow-jdbc module, the following errors occur:
> {{[INFO]}}
> {{[INFO] Results:}}
> {{[INFO]}}
> {{[ERROR] Failures:}}
> {{[ERROR] JdbcToArrowDataTypesTest.testJdbcToArrowValues:146->testDataSets:209 expected:<45935000> but was:<74735000>}}
> {{[ERROR] JdbcToArrowDataTypesTest.testJdbcToArrowValues:146->testDataSets:213 expected:<1518439535000> but was:<1518468335000>}}
> {{[ERROR] JdbcToArrowDataTypesTest.testJdbcToArrowValues:146->testDataSets:205 expected:<-365> but was:<-364>}}
> {{[ERROR] JdbcToArrowNullTest.testJdbcToArrowValues:123->testDataSets:165->testAllVectorValues:209 expected:<17574> but was:<17573}}
> {{>}}
> {{[ERROR] JdbcToArrowTest.testJdbcToArrowValues:138->testDataSets:206 expected:<17574> but was:<17573>}}
> {{[ERROR] JdbcToArrowVectorIteratorTest.testJdbcToArrowValuesNoLimit:107->validate:199->assertDateDayVectorValues:277 expected:<17}}
> {{574> but was:<17573>}}
> {{[ERROR] JdbcToArrowVectorIteratorTest.testJdbcToArrowValues:95->validate:199->assertDateDayVectorValues:277 expected:<17574> but}}
> {{ was:<17573>}}
> {{[INFO]}}
> {{[ERROR] Tests run: 93, Failures: 7, Errors: 0, Skipped: 0}}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)