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

PrestoDB translator - IFNULL is translated as NULLIF

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.2, 9.1.3
    • 8.12.8.6_3
    • Misc. Connectors
    • None

    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
      

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            jdurani Juraj DurĂ¡ni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: