[teiid-issues] [JBoss JIRA] (TEIID-4685) PrestoDB translator - IFNULL is translated as NULLIF

PrestoDB translator - IFNULL is translated as NULLIF ---------------------------------------------------- Key: TEIID-4685 URL: https://issues.jboss.org/browse/TEIID-4685 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.12.8.6_3 Reporter: Juraj Duráni Assignee: Steven Hawkins 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}