Hyoungjun Kim created TAJO-880:
----------------------------------
Summary: NULL in CASE clause occurs Exception.
Key: TAJO-880
URL: https://issues.apache.org/jira/browse/TAJO-880
Project: Tajo
Issue Type: Bug
Reporter: Hyoungjun Kim
Priority: Minor
The following query which contains NULL type in CASE clause occurs Exception.
{code:sql}
select
case when l_returnflag != 'R' then l_orderkey else null end
from lineitem
{code}
{noformat}
com.google.protobuf.ServiceException:
org.apache.tajo.engine.planner.PlanningException: No matched operation for
those types: type: INT4
, type: NULL_TYPE
at
org.apache.tajo.engine.planner.ExprAnnotator.assertEval(ExprAnnotator.java:76)
at
org.apache.tajo.engine.planner.ExprAnnotator.getWidestType(ExprAnnotator.java:130)
at
org.apache.tajo.engine.planner.ExprAnnotator.visitCaseWhen(ExprAnnotator.java:349)
at
org.apache.tajo.engine.planner.ExprAnnotator.visitCaseWhen(ExprAnnotator.java:51)
at
org.apache.tajo.engine.planner.BaseAlgebraVisitor.visit(BaseAlgebraVisitor.java:163)
at
org.apache.tajo.engine.planner.ExprAnnotator.createEvalNode(ExprAnnotator.java:71)
at
org.apache.tajo.engine.planner.LogicalPlanPreprocessor.visitProjection(LogicalPlanPreprocessor.java:204)
at
org.apache.tajo.engine.planner.LogicalPlanPreprocessor.visitProjection(LogicalPlanPreprocessor.java:38)
at
org.apache.tajo.engine.planner.BaseAlgebraVisitor.visit(BaseAlgebraVisitor.java:55)
at
org.apache.tajo.engine.planner.LogicalPlanner.createPlan(LogicalPlanner.java:119)
at
org.apache.tajo.engine.planner.LogicalPlanner.createPlan(LogicalPlanner.java:109)
at
org.apache.tajo.master.GlobalEngine.createLogicalPlan(GlobalEngine.java:480)
at
org.apache.tajo.master.GlobalEngine.executeQuery(GlobalEngine.java:148)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
