[SPARK-20291] NaNvl(FloatType, NullType) should not be cast to NaNvl(DoubleType, DoubleType)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0, 2.0.1, 2.0.2, 2.1.0
• Fix Version/s: 2.0.3, 2.1.1, 2.2.0
• Component/s: SQL
• Assignee: DB Tsai
• Reporter: DB Tsai
• Created: 11/Apr/17 09:03
• Updated: 12/Apr/17 16:09
• Resolved: 12/Apr/17 03:19

Description

`NaNvl(float value, null)` will be converted into `NaNvl(float value, Cast(null, DoubleType))` and finally `NaNvl(Cast(float value, DoubleType), Cast(null, DoubleType))`.

This will cause mismatching in the output type when the input type is float.

By adding extra rule in TypeCoercion can resolve this issue.

Issue Links

• links to: [Github] Pull Request #17606 (dbtsai)
• links to: [Github] Pull Request #17618 (dbtsai)