[teiid-issues] [JBoss JIRA] (TEIID-5235) Could not find symbol in processing an inline view using except
Steven Hawkins (JIRA)
issues at jboss.org
Thu Jan 25 14:48:00 EST 2018
[ https://issues.jboss.org/browse/TEIID-5235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-5235.
-----------------------------------
Resolution: Done
Updated the logic to insert a project node to account for the source node above the created join.
> Could not find symbol in processing an inline view using except
> ---------------------------------------------------------------
>
> Key: TEIID-5235
> URL: https://issues.jboss.org/browse/TEIID-5235
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 10.1
>
>
> With a query such as:
> SELECT case when agent_tin_id is null then 'Y' else 'N' end agent_tin_id from (SELECT agent_tin_id from MySQL_Server.bitool.AGENT_DIM where agent_tin_id>100 except( SELECT agent_tin_id from MySQL_Server.bitool.AGENT_DIM where agent_tin_id=100)) a
> When not fully pushed is processed as an anti semi join, but results in an exception:
> {code}
> org.teiid.core.TeiidRuntimeException: Planning error. Could not find symbol: a.agent_tin_id
> at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:363)
> at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:129)
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:92)
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:98)
> at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:87)
> at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:223)
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list