[SPARK-23175] Type conversion does not make sense under case like select ’0.1’ = 0

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Shaoquan Zhang
• Created: 22/Jan/18 02:30
• Updated: 22/Jan/18 05:35
• Resolved: 22/Jan/18 05:35

Description

SQL select '0.1' = 0 returns true. The result seems unreasonable.

From the logical plan, the sql is parsed as 'Project (cast(cast(0.1 as decimal(20,0)) as int) = 0) AS #6'. The type conversion converts the string to integer, which leads to the unreasonable result.

Issue Links

• duplicates: SPARK-21646 Add new type coercion rules to compatible with Hive