apache / apache/arrow-java

[Java] JDBC test failures for Windows build with timezone != UTC

Open
#387 3 comments 0 reactions 0 assignees View on GitHub
Type: bug
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.