[HIVE-20406] Nested Coalesce giving incorrect results

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Assignee: Vineet Garg
• Reporter: Riju Trivedi
• Created: 16/Aug/18 18:36
• Updated: 17/Nov/22 08:55
• Resolved: 18/Aug/18 04:52

Description

Below query is returning NULL instead of 'TEST' 

select coalesce(coalesce(null), 'TEST');

INFO  : OK

+-------+

|  _c0  |

+-------+

| NULL  |

+-------+