Details
-
Bug
-
Resolution: Done
-
Major
-
8.12.8.6_3
-
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