[ https://issues.jboss.org/browse/TEIID-4685?page=com.atlassian.jira.plugin... ] Juraj Duráni updated TEIID-4685: -------------------------------- 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|https://prestodb.io/docs/current/functions/conditional.html] {code:sql|title=Query} SELECT IFNULL(intnum, intkey) FROM BQT1.SmallA {code} {code:sql|title=Source command} SELECT nullif(g_0.intnum, g_0.intkey) FROM smalla AS g_0 {code} was: Teiid translates *COALESCE* function to *nullif*. However, those functions have different functionality. PrestoDB contains *coalesce* function. Please correct the function alias. {code:sql|title=Query} SELECT COALESCE(intnum, intkey) FROM BQT1.SmallA {code} {code:sql|title=Source command} SELECT nullif(g_0.intnum, g_0.intkey) FROM smalla AS g_0 {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)