[ https://issues.apache.org/jira/browse/SPARK-24598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16568005#comment-16568005 ]
Marco Gaido commented on SPARK-24598: ------------------------------------- [~smilegator] as we just enhanced the doc, but we have not really addressed the overflow condition, which I think we are targeting for a fix for 3.0, shall we leave this open for now and resolve it once the actual fix is in place? What do you think? Thanks. > SPARK SQL:Datatype overflow conditions gives incorrect result > ------------------------------------------------------------- > > Key: SPARK-24598 > URL: https://issues.apache.org/jira/browse/SPARK-24598 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.2.0 > Reporter: navya > Assignee: Marco Gaido > Priority: Major > Fix For: 2.4.0 > > > Execute an sql query, so that it results in overflow conditions. > EX - SELECT 9223372036854775807 + 1 result = -9223372036854776000 > > Expected result - Error should be throw like mysql. > mysql> SELECT 9223372036854775807 + 1; > ERROR 1690 (22003): BIGINT value is out of range in '(9223372036854775807 + > 1)' -- 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