Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4685

PrestoDB translator - IFNULL is translated as NULLIF

    Details

      Description

      Teiid translates NULLIF function to nullif. However, those functions have different functionality. Note, this is the case for COALESCE with two arguments as well as that function is rewritten to IFNULL.
      See PrestoDB doc

      Query

      SELECT IFNULL(intnum, intkey) FROM BQT1.SmallA
      

      Source command

      SELECT nullif(g_0.intnum, g_0.intkey) FROM smalla AS g_0
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jdurani Juraj Duráni
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: