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

Incorrect handling of Nan with join and codegen

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • Impala 2.11.0
    • Impala 2.11.0
    • Backend
    • None
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment