[ https://issues.apache.org/jira/browse/SPARK-28135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16870106#comment-16870106 ]
Yuming Wang commented on SPARK-28135: ------------------------------------- Thank you [~Tonix517], Could you submit pull request to fix this issue? > ceil/ceiling/floor/power returns incorrect values > ------------------------------------------------- > > Key: SPARK-28135 > URL: https://issues.apache.org/jira/browse/SPARK-28135 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.0.0 > Reporter: Yuming Wang > Priority: Major > > {noformat} > 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 > {noformat} > {noformat} > 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) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org