You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Gera Shegalov (Jira)" <ji...@apache.org> on 2023/08/24 08:23:00 UTC

[jira] [Updated] (SPARK-44943) CONV produces incorrect result near Long.MIN_VALUE, fails to detect overflow

     [ https://issues.apache.org/jira/browse/SPARK-44943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gera Shegalov updated SPARK-44943:
----------------------------------
    Affects Version/s: 4.0.0
                           (was: 3.4.1)

> CONV produces incorrect result near Long.MIN_VALUE, fails to detect overflow
> ----------------------------------------------------------------------------
>
>                 Key: SPARK-44943
>                 URL: https://issues.apache.org/jira/browse/SPARK-44943
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 4.0.0
>            Reporter: Gera Shegalov
>            Priority: Major
>
> {{>>> spark.conf.set('spark.sql.ansi.enabled', True)}}
> {{>>> sql("SELECT conv('-9223372036854775809', 10, -10)").show(truncate=False)}}
> {{+-----------------------------------+}}
> {{|conv(-9223372036854775809, 10, -10)|}}
> {{+-----------------------------------+}}
> {{|-9223372036854775807               |}}
> {{+-----------------------------------+}}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org