[SPARK-30252] Disallow negative scale of Decimal under ansi mode

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: wuyi
• Reporter: wuyi
• Created: 13/Dec/19 08:51
• Updated: 22/Jan/20 02:08
• Resolved: 21/Jan/20 13:16

Description

According to SQL standard,

4.4.2 Characteristics of numbers
An exact numeric type has a precision P and a scale S. P is a positive integer that determines the number of significant digits in a particular radix R, where R is either 2 or 10. S is a non-negative integer.

scale of Decimal should always be non-negative. And other mainstream databases, like Presto, PostgreSQL, also don't allow negative scale.

 

Issue Links

• links to: GitHub Pull Request #26881