[DRILL-2349] null comparison behavior difference between drill and postgres

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Execution - Data Types
• Assignee: Parth Chandra
• Reporter: Chun Chang
• Created: 28/Feb/15 03:15
• Updated: 28/Apr/15 18:19

Description

It appears postgres returns null for the following comparison:

foodmart=# select null=1;
 ?column?
----------

(1 row)

foodmart=# select null <> 1;
 ?column?
----------

(1 row)

foodmart=# select null;
 ?column?
----------

(1 row)

Drill gives sqlValidatorException:

0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select null=1 from sys.drillbits;
Query failed: SqlValidatorException: Cannot apply '=' to arguments of type '<NULL> = <INTEGER>'. Supported form(s): '<COMPARABLE_TYPE> = <COMPARABLE_TYPE>'

Error: exception while executing query: Failure while executing query. (state=,code=0)