You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "caoxuewen (JIRA)" <ji...@apache.org> on 2017/05/24 03:10:04 UTC
[jira] [Resolved] (SPARK-20850) Improve division and multiplication
mixing process the data
[ https://issues.apache.org/jira/browse/SPARK-20850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
caoxuewen resolved SPARK-20850.
-------------------------------
Resolution: Fixed
> Improve division and multiplication mixing process the data
> -----------------------------------------------------------
>
> Key: SPARK-20850
> URL: https://issues.apache.org/jira/browse/SPARK-20850
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.2.0
> Reporter: caoxuewen
>
> spark-sql> select (1234567890123456789012 / 12345678901234567890120) * 12345678901234567890120;
> NULL
> spark-sql> select (12345678901234567890 / 123) * 123;
> NULL
> when the length of the getText is greater than 19, The result is not what we expected.
> but mysql handle the value is ok.
> mysql> select (1234567890123456789012 / 12345678901234567890120) * 12345678901234567890120;
> +------------------------------------------------------------------------------+
> | (1234567890123456789012 / 12345678901234567890120) * 12345678901234567890120 |
> +------------------------------------------------------------------------------+
> | 1234567890123456789012.0000 |
> +------------------------------------------------------------------------------+
> 1 row in set (0.00 sec)
> mysql> select (12345678901234567890 / 123) * 123;
> +------------------------------------+
> | (12345678901234567890 / 123) * 123 |
> +------------------------------------+
> | 12345678901234567890.0000 |
> +------------------------------------+
> 1 row in set (0.00 sec)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org