Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-24598

SPARK SQL:Datatype overflow conditions gives incorrect result

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 2.2.0
    • Fix Version/s: 2.4.0
    • Component/s: SQL
    • Labels:
      None

      Description

      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)'

        Attachments

          Activity

            People

            • Assignee:
              mgaido Marco Gaido
              Reporter:
              nkrishnappa navya
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: