[
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)
