[
https://issues.apache.org/jira/browse/TAJO-830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14009040#comment-14009040
]
Hudson commented on TAJO-830:
-----------------------------
FAILURE: Integrated in Tajo-master-build #223 (See
[https://builds.apache.org/job/Tajo-master-build/223/])
TAJO-830: Some filter conditions with a SUBQUERY are removed by optimizer.
(Hyoungjun Kim via hyunsik) (hyunsik: rev
e2d0464747a08dd1c0df5fd6010c878d66802ace)
* tajo-core/src/test/resources/queries/TestUnionQuery/testUnion11.sql
* tajo-common/src/main/java/org/apache/tajo/conf/TajoConf.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/LogicalPlan.java
* tajo-core/src/test/resources/results/TestUnionQuery/testUnion15.result
* tajo-core/src/test/resources/queries/TestUnionQuery/testUnion14.sql
* tajo-core/src/test/resources/queries/TestUnionQuery/testUnion16.sql
* tajo-core/src/test/resources/queries/TestUnionQuery/testUnion13.sql
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestUnionQuery.java
* tajo-core/src/test/resources/results/TestUnionQuery/testUnion11.result
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/LogicalPlanPreprocessor.java
* tajo-core/src/test/resources/queries/TestSelectQuery/testWhereCond2.sql
* tajo-core/src/test/resources/results/TestUnionQuery/testUnion16.result
* tajo-core/src/test/resources/results/TestUnionQuery/testUnion13.result
* tajo-core/src/test/resources/queries/TestUnionQuery/testUnion15.sql
* tajo-client/src/main/java/org/apache/tajo/jdbc/TajoResultSet.java
* tajo-core/src/test/resources/results/TestSelectQuery/testWhereCond2.result
* tajo-core/src/test/resources/queries/TestUnionQuery/testUnion12.sql
* CHANGES
* tajo-core/src/main/java/org/apache/tajo/engine/planner/LogicalOptimizer.java
* tajo-core/src/test/resources/results/TestUnionQuery/testUnion14.result
* tajo-core/src/test/resources/results/TestUnionQuery/testUnion12.result
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/BasicLogicalPlanVisitor.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/LogicalPlanner.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/rewrite/FilterPushDownRule.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/logical/GroupbyNode.java
*
tajo-core/src/test/resources/queries/TestJoinQuery/testJoinCoReferredEvalsFilterPushdown.sql
> Some filter conditions with a SUBQUERY are removed by optimizer.
> ----------------------------------------------------------------
>
> Key: TAJO-830
> URL: https://issues.apache.org/jira/browse/TAJO-830
> Project: Tajo
> Issue Type: Bug
> Reporter: Hyoungjun Kim
> Assignee: Hyoungjun Kim
> Fix For: 0.9.0
>
> Attachments: TAJO-830.patch
>
>
> In the case of a next query, "col3 like '1993-11-24%';" condition removed by
> optimized.
> {code:sql}
> select a.*
> from (
> select
> L_RETURNFLAG as col1,
> L_EXTENDEDPRICE as col2,
> concat(L_RECEIPTDATE, L_LINESTATUS) as col3
> from lineitem
> ) a
> where col2 > 0 && col3 like '1993-11-24%';
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
