[SPARK-29956] A literal number with an exponent should be converted into Double

• 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: 19/Nov/19 07:43
• Updated: 02/Dec/19 23:22
• Resolved: 02/Dec/19 04:21

Description

Currently, for a literal with an exponent (e.g. 1e-45), Spark will convert it into Decimal.

However, according to the ansi standard, it should be converted into Double and this is what Presto does too.

Issue Links

• links to: GitHub Pull Request #26595