[SPARK-28135] ceil/ceiling/floor/power returns incorrect values

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 21/Jun/19 08:25
• Updated: 25/Jun/19 19:47

Description

spark-sql> select ceil(double(1.2345678901234e+200)), ceiling(double(1.2345678901234e+200)), floor(double(1.2345678901234e+200)), power('1', 'NaN');
9223372036854775807	9223372036854775807	9223372036854775807	NaN

postgres=# select ceil(1.2345678901234e+200::float8), ceiling(1.2345678901234e+200::float8), floor(1.2345678901234e+200::float8), power('1', 'NaN');
         ceil         |       ceiling        |        floor         | power
----------------------+----------------------+----------------------+-------
 1.2345678901234e+200 | 1.2345678901234e+200 | 1.2345678901234e+200 |     1
(1 row)

Issue Links

• is related to: SPARK-10865 [Spark SQL] [UDF] the ceil/ceiling function got wrong return value type
• is related to: SPARK-10866 [Spark SQL] [UDF] the floor function got wrong return value type
• links to: GitHub Pull Request #24940