[teiid-issues] [JBoss JIRA] (TEIID-5834) Class cast exception using web service with bind varables

[ https://issues.jboss.org/browse/TEIID-5834?page=com.atlassian.jira.plugin... ] Mike Higgins updated TEIID-5834: -------------------------------- Description: I am using a restful web service, which works fine if literal values are used to constrain it. However, when I use bind variables, it gives me a traceback: java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352) at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60) at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88) at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79) at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101) at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256) at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148) 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:492) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362) ... 8 more The SQL is: <deleted for internal security reasons -- showed a dependent join to a web service using an 'in' operator>, Where WS_CLUSTER is the web service. I didn't find any issues about this so I was not sure if a later version would work. was: I am using a restful web service, which works fine if literal values are used to constrain it. However, when I use bind variables, it gives me a traceback: java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352) at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60) at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88) at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79) at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101) at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256) at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148) 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:492) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362) ... 8 more The SQL is: SELECT CAIMANM.LM_BIOLOGICAL_SYSTEM."BIOLOGICAL_SYSTEM_UID", WS_CLUSTER.WS_CLUSTER_T."VH_SPECIES", WS_CLUSTER.WS_CLUSTER_T."PROJECT_SHORT_NAME", WS_CLUSTER.WS_CLUSTER_T."biosysid" FROM caimanm.lm_biological_system LEFT OUTER JOIN WS_cluster.WS_cluster_t ON (CAIMANM.LM_BIOLOGICAL_SYSTEM."BIOLOGICAL_SYSTEM_UID" = WS_CLUSTER.WS_CLUSTER_T."biosysid") AND (WS_CLUSTER.WS_CLUSTER_T."biosysid" in (?, ?, ?)) WHERE (CAIMANM.LM_BIOLOGICAL_SYSTEM."BIOLOGICAL_SYSTEM_UID" in (?, ?, ?)) Where WS_CLUSTER is the web service. I didn't find any issues about this so I was not sure if a later version would work. -- This message was sent by Atlassian Jira (v7.13.8#713008)