[SPARK-28028] Cast numeric to integral type need round

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 12/Jun/19 14:46
• Updated: 29/Dec/19 11:00

Description

For example
Case 1:

select cast(-1.5 as smallint);

Spark SQL returns -1, but PostgreSQL returns -2.

 

Case 2:

SELECT smallint(float('32767.6'))

Spark SQL returns 32767, but PostgreSQL throws ERROR: smallint out of range.