12:16 p.m.
[
https://issues.jboss.org/browse/TEIID-5636?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5636:
---------------------------------------
I don't see this issue with the patch applied to 10.2.1 either.
The difference in the query plan comes down to:
SELECT g_0."_PRICETYPORDRE" AS c_0, g_0."_CODEOPERATEUR" AS c_1,
g_1."_NUMEROINT" AS c_2 FROM OmegaModel_qgWs.Omega.Cpte.ORDRES AS g_0 LEFT OUTER
JOIN OmegaModel_qgWs.Omega.Cpte.OPERAT AS g_1 ON g_0."_CODEOPERATION" =
g_1."_CODEOPERATION" ORDER BY c_0
which has missing projected symbol without the patch.
If you can still reproduce the issue with master or one of the other fix branches please
let me know.
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)
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
2130
days inactive
2130
days old
0 comments
1 participants
participants (1)
-
Steven Hawkins (Jira)