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

SPARK SQL:Datatype overflow conditions gives incorrect result

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Done
    • 2.2.0
    • 2.4.0
    • SQL
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: