[IMPALA-6069] Incorrect handling of Nan with join and codegen

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 2.11.0
• Fix Version/s: Impala 2.11.0
• Component/s: Backend
• Epic Color: ghx-label-1
• Assignee: Thomas Tauber-Marshall
• Reporter: Thomas Tauber-Marshall
• Created: 17/Oct/17 21:59
• Updated: 14/Mar/18 16:30
• Resolved: 08/Dec/17 22:47

Description

Repro:

> create table test (col0 float);
> insert into test values (0), (cast('nan' as float));
> select * from test a, test b where a.col0 = b.col0;
+------+------+
| col0 | col0 |
+------+------+
| 0    | 0    |
| NaN  | NaN  |
+------+------+
> set disable_codegen=true;
> select * from test a, test b where a.col0 = b.col0;
+------+------+
| col0 | col0 |
+------+------+
| 0    | 0    |
+------+------+

I think the version without codegen is the intended behavior (because 'Nan' = 'Nan' is false)

Issue Links

• is related to: IMPALA-6661 Group by float results in one group per NaN value