[
https://issues.apache.org/jira/browse/DRILL-5606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16079131#comment-16079131
]
Muhammad Gelbana commented on DRILL-5606:
-----------------------------------------
For the
*org.apache.drill.exec.fn.impl.TestCastFunctions.testToDateForTimeStamp()*
method, I found that when the test query
{code:sql}select to_date(to_timestamp(-1)) as col from (values(1)){code}
against Drill, the result is
{noformat}1970-01-01T00:00:00.000+02:00{noformat}
If I set the timezone to *UTC* (i.e. *-Duser.timezone=UTC*), the result becomes
{noformat}1969-12-31T00:00:00.000Z{noformat}
which is what the test case expects, I guess.
I looked around for a test case that sets the timezone but I found a couple of
test cases ignored because they rely on timezones !
Would someone please tell me how can I set the timezone for a test case ?
> Some tests fail after creating a fresh clone
> --------------------------------------------
>
> Key: DRILL-5606
> URL: https://issues.apache.org/jira/browse/DRILL-5606
> Project: Apache Drill
> Issue Type: Bug
> Components: Tools, Build & Test
> Environment: {noformat}
> $ uname -a
> Linux mg-mate 4.4.0-81-generic #104-Ubuntu SMP Wed Jun 14 08:17:06 UTC 2017
> x86_64 x86_64 x86_64 GNU/Linux
> $ lsb_release -a
> No LSB modules are available.
> Distributor ID: Ubuntu
> Description: Ubuntu 16.04.2 LTS
> Release: 16.04
> Codename: xenial
> $ java -version
> openjdk version "1.8.0_131"
> OpenJDK Runtime Environment (build 1.8.0_131-8u131-b11-0ubuntu1.16.04.2-b11)
> OpenJDK 64-Bit Server VM (build 25.131-b11, mixed mode)
> {noformat}
> Environment variables JAVA_HOME, JRE_HOME, JDK_HOME aren't configured. Java
> executable is found as the PATH environment variables links to it. I can
> provide more details if needed.
> Reporter: Muhammad Gelbana
> Attachments: failing_tests.tar.gz, full_log.txt.tar.gz,
> surefire-reports.tar.gz
>
>
> I cloned Drill from Github using this url:
> [https://github.com/apache/drill.git] and I didn't change the branch
> afterwards, so I'm using *master*.
> Afterwards, I ran the following command
> {noformat}
> mvn clean install
> {noformat}
> I attached the full log but here is a snippet indicating the failing tests:
> {noformat}
> Failed tests:
> TestExtendedTypes.checkReadWriteExtended:60 expected:<...ateDay" :
> "1997-07-1[6"
> },
> "drill_timestamp" : {
> "$date" : "2009-02-23T08:00:00.000Z"
> },
> "time" : {
> "$time" : "19:20:30.450Z"
> },
> "interval" : {
> "$interval" : "PT26.400S"
> },
> "integer" : {
> "$numberLong" : 4
> },
> "inner" : {
> "bin" : {
> "$binary" : "ZHJpbGw="
> },
> "drill_date" : {
> "$dateDay" : "1997-07-16]"
> },
> "drill_...> but was:<...ateDay" : "1997-07-1[5"
> },
> "drill_timestamp" : {
> "$date" : "2009-02-23T08:00:00.000Z"
> },
> "time" : {
> "$time" : "19:20:30.450Z"
> },
> "interval" : {
> "$interval" : "PT26.400S"
> },
> "integer" : {
> "$numberLong" : 4
> },
> "inner" : {
> "bin" : {
> "$binary" : "ZHJpbGw="
> },
> "drill_date" : {
> "$dateDay" : "1997-07-15]"
> },
> "drill_...>
> Tests in error:
> TestCastFunctions.testToDateForTimeStamp:79 » at position 0 column '`col`'
> mi...
> TestNewDateFunctions.testIsDate:61 » After matching 0 records, did not
> find e...
> Tests run: 2128, Failures: 1, Errors: 2, Skipped: 139
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Reactor Summary:
> [INFO]
> [INFO] Apache Drill Root POM .............................. SUCCESS [ 19.805
> s]
> [INFO] tools/Parent Pom ................................... SUCCESS [ 0.605
> s]
> [INFO] tools/freemarker codegen tooling ................... SUCCESS [ 7.077
> s]
> [INFO] Drill Protocol ..................................... SUCCESS [ 7.959
> s]
> [INFO] Common (Logical Plan, Base expressions) ............ SUCCESS [ 7.734
> s]
> [INFO] Logical Plan, Base expressions ..................... SUCCESS [ 8.099
> s]
> [INFO] exec/Parent Pom .................................... SUCCESS [ 0.575
> s]
> [INFO] exec/memory/Parent Pom ............................. SUCCESS [ 0.513
> s]
> [INFO] exec/memory/base ................................... SUCCESS [ 4.666
> s]
> [INFO] exec/rpc ........................................... SUCCESS [ 2.684
> s]
> [INFO] exec/Vectors ....................................... SUCCESS [01:11
> min]
> [INFO] contrib/Parent Pom ................................. SUCCESS [ 0.547
> s]
> [INFO] contrib/data/Parent Pom ............................ SUCCESS [ 0.496
> s]
> [INFO] contrib/data/tpch-sample-data ...................... SUCCESS [ 2.698
> s]
> [INFO] exec/Java Execution Engine ......................... FAILURE [19:09
> min]
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
