Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-6069

Incorrect handling of Nan with join and codegen

    Details

    • 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
    • Labels:
      None
    • Epic Color:
      ghx-label-1

      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)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                twmarshall Thomas Tauber-Marshall
                Reporter:
                twmarshall Thomas Tauber-Marshall
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: