[
https://issues.apache.org/jira/browse/TAJO-1265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14268978#comment-14268978
]
Hudson commented on TAJO-1265:
------------------------------
ABORTED: Integrated in Tajo-master-CODEGEN-build #179 (See
[https://builds.apache.org/job/Tajo-master-CODEGEN-build/179/])
TAJO-1265: min(), max() does not handle null properly. (Keuntae Park) (sirpkt:
rev a1e03289b35d34115a449ab7d81b946f69400210)
*
tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoinWithEmptyTable4.result
*
tajo-core/src/test/java/org/apache/tajo/engine/function/TestBuiltinFunctions.java
*
tajo-core/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData8.result
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/SumFloat.java
*
tajo-core/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData4.result
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/AvgDouble.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/MinLong.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/MaxDouble.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/DistinctGroupbySortAggregationExec.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/MaxFloat.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/AvgLong.java
*
tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable4.result
*
tajo-core/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData7.result
*
tajo-core/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData3.result
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/MaxLong.java
*
tajo-core/src/test/resources/queries/TestBuiltinFunctions/testAvgLongOverflow.sql
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/Min.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/SumLong.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/MaxInt.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/AvgInt.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/MaxString.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/SumDouble.java
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestGroupByQuery.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/MinString.java
*
tajo-core/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData6.result
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/Max.java
*
tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable2.result
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/MinDouble.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/MinFloat.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/SumInt.java
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/AvgFloat.java
*
tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoinWithEmptyTable2.result
*
tajo-core/src/test/resources/results/TestBuiltinFunctions/testAvgLongOverflow.result
*
tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable5.result
* CHANGES
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/MinInt.java
*
tajo-core/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData2.result
> min(), max() does not handle null properly
> ------------------------------------------
>
> Key: TAJO-1265
> URL: https://issues.apache.org/jira/browse/TAJO-1265
> Project: Tajo
> Issue Type: Bug
> Reporter: Keuntae Park
> Assignee: Keuntae Park
> Priority: Minor
>
> In other DBs like oracle and postgreSQL,
> null is excluded from calculation of min() and max() value until there is no
> non-null value in the given column, in which case, it returns null.
> However, current implementation of Tajo considers null as
> 0 for int or long column, 0.0 for float or double column, or "" for text
> column.
> It needs to handle null value separately from non-null values in min() and
> max() calculation.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
