[
https://issues.apache.org/jira/browse/DRILL-4582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15227497#comment-15227497
]
ASF GitHub Bot commented on DRILL-4582:
---------------------------------------
GitHub user ykrips opened a pull request:
https://github.com/apache/drill/pull/464
DRILL-4582: TestCastFunctions#testToDateForTimeStamp returns error by
timezone difference
DRILL-4582: TestCastFunctions#testToDateForTimeStamp returns error by
timezone difference
- changed parameter of to_timestamp function, and appended timezone string
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/ykrips/drill DRILL-4582
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/464.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #464
----
commit d01d138ec2fd11ec7fb4606b2e4b39b941bd9cbc
Author: Jihun Kang <[email protected]>
Date: 2016-04-06T01:11:24Z
DRILL-4582: TestCastFunctions#testToDateForTimeStamp returns error by
timezone difference
----
> TestCastFunctions#testToDateForTimeStamp returns error by timezone difference
> -----------------------------------------------------------------------------
>
> Key: DRILL-4582
> URL: https://issues.apache.org/jira/browse/DRILL-4582
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 1.7.0
> Reporter: Jihun Kang
> Priority: Minor
>
> When running drill tests on a machine with positive offsets of timezone,
> following error is created. This error comes from the joda datetime, because
> joda datetime create an object with default timezone.
> {noformat}
> Running org.apache.drill.exec.fn.impl.TestCastFunctions#testToDateForTimeStamp
> java.lang.Exception: at position 0 column '`col`' mismatched values,
> expected: 1969-12-31T00:00:00.000+09:00(DateTime) but received
> 1970-01-01T00:00:00.000+09:00(DateTime)
> Expected Records near verification failure:
> Record Number: 0 { `col` : 1969-12-31T00:00:00.000+09:00, }
> Actual Records near verification failure:
> Record Number: 0 { `col` : 1970-01-01T00:00:00.000+09:00, }
> For query: select to_date(to_timestamp(-1)) as col
> from (values(1))
> at
> org.apache.drill.DrillTestWrapper.compareMergedOnHeapVectors(DrillTestWrapper.java:436)
> at
> org.apache.drill.DrillTestWrapper.compareOrderedResults(DrillTestWrapper.java:390)
> at org.apache.drill.DrillTestWrapper.run(DrillTestWrapper.java:126)
> at
> org.apache.drill.exec.fn.impl.TestCastFunctions.testToDateForTimeStamp(TestCastFunctions.java:74)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at java.lang.reflect.Method.invoke(Method.java:606)
> Caused by: java.lang.Exception: at position 0 column '`col`' mismatched
> values, expected: 1969-12-31T00:00:00.000+09:00(DateTime) but received
> 1970-01-01T00:00:00.000+09:00(DateTime)
> Expected Records near verification failure:
> Record Number: 0 { `col` : 1969-12-31T00:00:00.000+09:00, }
> Actual Records near verification failure:
> Record Number: 0 { `col` : 1970-01-01T00:00:00.000+09:00, }
> at
> org.apache.drill.DrillTestWrapper.compareMergedVectors(DrillTestWrapper.java:174)
> at
> org.apache.drill.DrillTestWrapper.compareMergedOnHeapVectors(DrillTestWrapper.java:434)
> ... 7 more
> Caused by: java.lang.Exception: at position 0 column '`col`' mismatched
> values, expected: 1969-12-31T00:00:00.000+09:00(DateTime) but received
> 1970-01-01T00:00:00.000+09:00(DateTime)
> at
> org.apache.drill.DrillTestWrapper.compareValuesErrorOnMismatch(DrillTestWrapper.java:552)
> at
> org.apache.drill.DrillTestWrapper.compareMergedVectors(DrillTestWrapper.java:172)
> ... 8 more
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
