Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-827

SUM() overflow in the case of INT4

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0, 0.8.1
    • Component/s: None
    • Labels:
      None

      Description

      See the title and a next query result.

       
      babokim> select * from iii;
      a
      -------------------------------
      1182614790
      1182614790
      1182614790
      1182614790
      1182614790
      1182614790
       
      babokim> select sum(a) from iii;
      ?sum
      -------------------------------
      -1494245852
      
      1. TAJO-827.patch
        4 kB
        Hyoungjun Kim

        Activity

        Hide
        hyunsik Hyunsik Choi added a comment -

        +1

        the patch looks good to me. I've verified 'mvn clean install'.

        Show
        hyunsik Hyunsik Choi added a comment - +1 the patch looks good to me. I've verified 'mvn clean install'.
        Hide
        hyunsik Hyunsik Choi added a comment -

        committed it to master and 0.8.1 branch. Thank you for your contribution!

        Show
        hyunsik Hyunsik Choi added a comment - committed it to master and 0.8.1 branch. Thank you for your contribution!
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-0.8.1-build #101 (See https://builds.apache.org/job/Tajo-0.8.1-build/101/)
        TAJO-827: SUM() overflow in the case of INT4. (Hyoungjun Kim via hyunsik) (hyunsik: rev 46c1cf564058891fb3681dc4183628888426f98f)

        • tajo-core/src/test/resources/results/TestSelectQuery/testSumIntOverflow.result
        • tajo-core/src/test/java/org/apache/tajo/engine/query/TestSelectQuery.java
        • tajo-core/src/test/resources/queries/TestSelectQuery/testSumFloatOverflow.sql
        • tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/SumInt.java
        • tajo-core/src/test/resources/queries/TestSelectQuery/testSumIntOverflow.sql
        • CHANGES
        • tajo-core/src/test/resources/results/TestSelectQuery/testSumFloatOverflow.result
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-0.8.1-build #101 (See https://builds.apache.org/job/Tajo-0.8.1-build/101/ ) TAJO-827 : SUM() overflow in the case of INT4. (Hyoungjun Kim via hyunsik) (hyunsik: rev 46c1cf564058891fb3681dc4183628888426f98f) tajo-core/src/test/resources/results/TestSelectQuery/testSumIntOverflow.result tajo-core/src/test/java/org/apache/tajo/engine/query/TestSelectQuery.java tajo-core/src/test/resources/queries/TestSelectQuery/testSumFloatOverflow.sql tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/SumInt.java tajo-core/src/test/resources/queries/TestSelectQuery/testSumIntOverflow.sql CHANGES tajo-core/src/test/resources/results/TestSelectQuery/testSumFloatOverflow.result
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-master-build #221 (See https://builds.apache.org/job/Tajo-master-build/221/)
        TAJO-827: SUM() overflow in the case of INT4. (Hyoungjun Kim via hyunsik) (hyunsik: rev e7051ef343d2a97bd8af4aa6b2f8a345b3567c76)

        • tajo-core/src/test/resources/queries/TestSelectQuery/testSumFloatOverflow.sql
        • tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/SumInt.java
        • tajo-core/src/test/resources/results/TestSelectQuery/testSumFloatOverflow.result
        • tajo-core/src/test/resources/results/TestSelectQuery/testSumIntOverflow.result
        • tajo-core/src/test/resources/queries/TestSelectQuery/testSumIntOverflow.sql
        • tajo-core/src/test/java/org/apache/tajo/engine/query/TestSelectQuery.java
        • CHANGES
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-master-build #221 (See https://builds.apache.org/job/Tajo-master-build/221/ ) TAJO-827 : SUM() overflow in the case of INT4. (Hyoungjun Kim via hyunsik) (hyunsik: rev e7051ef343d2a97bd8af4aa6b2f8a345b3567c76) tajo-core/src/test/resources/queries/TestSelectQuery/testSumFloatOverflow.sql tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/SumInt.java tajo-core/src/test/resources/results/TestSelectQuery/testSumFloatOverflow.result tajo-core/src/test/resources/results/TestSelectQuery/testSumIntOverflow.result tajo-core/src/test/resources/queries/TestSelectQuery/testSumIntOverflow.sql tajo-core/src/test/java/org/apache/tajo/engine/query/TestSelectQuery.java CHANGES

          People

          • Assignee:
            hjkim Hyoungjun Kim
            Reporter:
            hjkim Hyoungjun Kim
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development