[SPARK-20211] `1 > 0.0001` throws Decimal scale (0) cannot be greater than precision (-2) exception

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0, 2.0.1, 2.0.2, 2.1.0, 2.1.1
• Fix Version/s: 2.0.3, 2.1.2, 2.2.0
• Component/s: SQL
• Labels: correctness
• Assignee: Xiao Li
• Reporter: StanZhai
• Created: 04/Apr/17 14:53
• Updated: 12/Dec/22 18:11
• Resolved: 14/Jun/17 11:19

Description

The following SQL:

select 1 > 0.0001 from tb

throws Decimal scale (0) cannot be greater than precision (-2) exception in Spark 2.x.

`floor(0.0001)` and `ceil(0.0001)` have the same problem in Spark 1.6.x and Spark 2.x.

Issue Links

• links to: [Github] Pull Request #17529 (stanzhai)
• links to: [Github] Pull Request #18244 (gatorsmile)
• links to: [Github] Pull Request #18297 (gatorsmile)