[Java] JDBC test failures for Windows build with timezone != UTC
- Dominant language
- Java
- Stars
- 94
- Forks
- 152
- Avg merge
- 3d 16h
- Merged PRs (30d)
- 11
Description
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`
**Environment**: Windows 10, Java 8
**Reporter**: [Bob Tinsman](https://issues.apache.org/jira/browse/ARROW-11957) / @bobtins
**Note**: *This issue was originally created as [ARROW-11957](https://issues.apache.org/jira/browse/ARROW-11957). Please see the [migration documentation](https://github.com/apache/arrow/issues/14542) for further details.*
Contributor guide
Research direction
Run "mvn install" from the java directory on Windows 10 with the timezone set to PST, then inspect the failing arrow-jdbc tests: JdbcToArrowDataTypesTest, JdbcToArrowNullTest, JdbcToArrowTest, and JdbcToArrowVectorIteratorTest. Done means the seven reported timezone-dependent failures no longer occur and the module's tests pass.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases, testing
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100