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

[Mike Higgins (Jira)]

Mike Higgins created TEIID-5834:
-----------------------------------

             Summary: Class cast exception using web service with bind varables
                 Key: TEIID-5834
                 URL: https://issues.jboss.org/browse/TEIID-5834
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 11.1.2
            Reporter: Mike Higgins
            Assignee: Steven Hawkins


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)