[DRILL-772] Null values are not filtered out in query result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Execution - Relational Operators
• Assignee: Unassigned
• Reporter: Krystal
• Created: 19/May/14 16:22
• Updated: 15/Mar/17 16:07
• Resolved: 20/Jun/14 20:28

Description

git.commit.id.abbrev=70fab8c

0: jdbc:drill:schema=dfs> select voter_id, name, age from voter where age not between 20 and 80;
--------------------------------

voter_id

name

age

--------------------------------

3	[B@183c94e6	18
17	[B@31539478	null
22	[B@66386b94	19
57	[B@21ef5fa	19
59	[B@3ea6f12c	18
70	[B@42239fd6	18
85	[B@30d2bc86	19
92	[B@5b571a74	null
109	[B@3389e485	18
111	[B@21f9f232	18

The output above returned age with "null" values. In oracle and postgres, the rows with "null" value for age are filtered out.