drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Serhii Harnyk (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4942) incorrect result - case when (not null is null) then true else false end
Date Thu, 01 Dec 2016 16:17:58 GMT

    [ https://issues.apache.org/jira/browse/DRILL-4942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15712377#comment-15712377
] 

Serhii Harnyk commented on DRILL-4942:
--------------------------------------

The problem is in Calcite - CALCITE-1095.
It was fixed in Calcite 1.9.0.
When Drill migrates to Calcite 1.9.0 or higher, issue will be resolved.

> incorrect result  - case when (not null is null) then true else false end
> -------------------------------------------------------------------------
>
>                 Key: DRILL-4942
>                 URL: https://issues.apache.org/jira/browse/DRILL-4942
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>    Affects Versions: 1.9.0
>            Reporter: Khurram Faraaz
>            Assignee: Serhii Harnyk
>
> Drill's result is different from that of Calcite and Postgres result.
> Postgres 9.3 results
> {noformat}
> postgres=# select (case when (not null is null) then true else false end) from (values(1))
foo;
>  case
> ------
>  f
> (1 row)
> {noformat}
> Calcite release 1.8.0 too returns false
> {noformat}
> 0: jdbc:calcite:model=target/test-classes/mod> select (case when (not null is null)
then true else false end) from (values(1));
> +--------+
> | EXPR$0 |
> +--------+
> | false  |
> +--------+
> 1 row selected (1.271 seconds)
> {noformat}
> Drill 1.9.0 git commit ID: 4edabe7a, returns true
> {noformat}
> 0: jdbc:drill:schema=dfs.tmp> select (case when (not null is null) then true else
false end) from (values(1));
> +---------+
> | EXPR$0  |
> +---------+
> | true    |
> +---------+
> 1 row selected (0.096 seconds)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message