[teiid-issues] [JBoss JIRA] (TEIID-5636) Planning error. Could not find symbol disiz__1.DischargeTime

Planning error. Could not find symbol disiz__1.DischargeTime ------------------------------------------------------------ Key: TEIID-5636 URL: https://issues.jboss.org/browse/TEIID-5636 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 10.3.4 Reporter: Bram Gadeyne Assignee: Steven Hawkins Priority: Critical Fix For: 12.1, 12.0.1, 11.2.3 Attachments: Planning Error 21-02-2019.txt, planning_error.txt Hi, We're running into this exception. It happens when adding "LEFT OUTER JOIN izisprod.P_DischargeData". I unfortunitaly have no smaller example. We use this table all the time without any previous errors. 2019-01-31 15:32:36,438 ERROR [org.teiid.PROCESSOR] (Worker172_QueryProcessorQueue57002) JesgvCmnKfP5 TEIID30019 Unexpected exception for request JesgvCmnKfP5.187: org.teiid.core.TeiidRuntimeException: Planning error. Could not find symbol: disiz__1.DischargeTime 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.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) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:135) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:480) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:350) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:277) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)