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)