[DRILL-4942] incorrect result - case when (not null is null) then true else false end

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.13.0
• Component/s: Execution - Flow
• Assignee: Serhii Harnyk
• Reporter: Khurram Faraaz
• Created: 12/Oct/16 12:07
• Updated: 19/Jan/18 11:25
• Resolved: 19/Jan/18 09:50

Description

Drill's result is different from that of Calcite and Postgres result.

Postgres 9.3 results

postgres=# select (case when (not null is null) then true else false end) from (values(1)) foo;
 case
------
 f
(1 row)

Calcite release 1.8.0 too returns false

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)

Drill 1.9.0 git commit ID: 4edabe7a, returns true

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)

Issue Links

• depends upon: DRILL-3993 Rebase Drill on Calcite master branch