[teiid-issues] [JBoss JIRA] (TEIID-5152) "No value was available" error message when evaluating an expression

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5152.
-----------------------------------
    Fix Version/s: 9.3.5
                   10.1
                   10.0.1
       Resolution: Done


The root issue was that the logic allowing view removal did not fully scan further joins for lateral correlated references and allowed the removal.  While it is possible to support this for the literal only case eventually, it was better to address the root issue first.

> "No value was available" error message when evaluating an expression
> --------------------------------------------------------------------
>
>                 Key: TEIID-5152
>                 URL: https://issues.jboss.org/browse/TEIID-5152
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 9.3.4
>         Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
>            Reporter: dalex dalex
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 9.3.5, 10.1, 10.0.1
>
>
> 1. When running the following query:
> {code:sql}
> SELECT *
> 	FROM (SELECT 'League' AS type, 1 AS arg0) xxx, "test_pg.test_nva" dl, table(CALL "views.pr0"(arg0)) x
> 	JOIN "test_pg.test_nva" d ON d.type = 'str_val' ;;
> {code}
> teiid throws out the following error:
> {code:noformat}
> 2017-11-16 17:23:24,159 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue8) DopCSsLeK9Oy TEIID30019 Unexpected exception for request DopCSsLeK9Oy.2: org.teiid.core.TeiidCompon
> entException: TEIID30328 Unable to evaluate xxx.arg0: No value was available
>         at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:514)
>         at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:771)
>         at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1387)
>         at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:761)
>         at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:727)
>         at org.teiid.query.processor.proc.ProcedurePlan.evaluateExpression(ProcedurePlan.java:857)
>         at org.teiid.query.processor.proc.ProcedurePlan.open(ProcedurePlan.java:225)
>         at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:82)
>         at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
>         at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
>         at org.teiid.query.processor.relational.LimitNode.open(LimitNode.java:146)
>         at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95)
>         at org.teiid.query.processor.relational.NestedTableJoinStrategy.openLeft(NestedTableJoinStrategy.java:74)
>         at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:145)
>         at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
>         at org.teiid.query.processor.relational.LimitNode.open(LimitNode.java:146)
>         at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:105)
>         at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:149)
>         at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
>         at org.teiid.query.processor.relational.LimitNode.open(LimitNode.java:146)
>         at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
>         at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:136)
>         at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:232)
>         at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
>         at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:115)
>         at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
>         at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
>         at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:479)
>         at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349)
>         at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
>         at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
>         at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284)
>         at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
>         at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>         at java.lang.Thread.run(Thread.java:745)
> {code}
> 2. When running the following query:
> {code:sql}
> SELECT *
> 	FROM (SELECT 'League' AS type, 1 AS arg0) xxx, "test_pg.test_nva" dl, table(CALL "views.pr0"(arg0)) x
> 	JOIN "test_pg.test_nva" d ON x.col1 = d.start_date AND d.type = 'str_val' ;;
> {code}
> teiid complains showing the following error message:
> {code:noformat}
> 2017-11-16 17:37:59,372 WARN  [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue23) DopCSsLeK9Oy TEIID30020 Processing exception for request DopCSsLeK9Oy.9 'TEIID31172 Could not reso
> lve expressions being compared to a common type excluding character conversions: x.col1 = d.start_date'. Originally QueryResolverException ResolverVisitor.java:1045. Enable more deta
> iled logging to see the entire stacktrace.
> {code}
> It seems that in the x.col1 = d.start_date comparison the d.start_date must be converted to string explicitly but I don't know if it's a bug or not, if we indeed must use the conversion here explicitly.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)