[teiid-issues] [JBoss JIRA] (TEIID-5235) Could not find symbol in processing a subquery using except

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-5235:
-------------------------------------

             Summary: Could not find symbol in processing a subquery 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)