[teiid-issues] [JBoss JIRA] (TEIID-5300) ClassCastException during query Optimization

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-5300:
----------------------------------
          Component/s: Query Engine
        Fix Version/s: 10.3
    Affects Version/s: 10.1


> ClassCastException during query Optimization
> --------------------------------------------
>
>                 Key: TEIID-5300
>                 URL: https://issues.jboss.org/browse/TEIID-5300
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 10.1
>         Environment: Teiid 10.1
>            Reporter: Mike Higgins
>            Assignee: Steven Hawkins
>             Fix For: 10.3
>
>
> Using Teiid 10.1 against an Oracle database, if I submit a query with exactly two bind variables such as the following:
>  
> SELECT "Small Molecules"."MOLREGNO", "Small Molecules"."CHEMBL_ID",
>     "Small Molecules_2"."FULL_MWT", CHEMBL_20.ACTIVITIES."ACTIVITY_ID",
>     CHEMBL_20.ACTIVITIES."ACTIVITY_ID", ((CHEMBL_20.ACTIVITIES."ASSAY_ID" ||
>     '#') || CHEMBL_20.ACTIVITIES."STANDARD_TYPE") "ID_RESULT",
>     CHEMBL_20.ACTIVITIES."STANDARD_UNITS",
>     CHEMBL_20.ACTIVITIES."ACTIVITY_COMMENT",
>     CHEMBL_20.ACTIVITIES."STANDARD_VALUE"
>   FROM (SELECT CHEMBL_20.COMPOUND_STRUCTURES."MOLREGNO",
>     SM_DICTIONARY_PRIME."CHEMBL_ID" FROM chembl_20.compound_structures INNER
>     JOIN chembl_20.molecule_dictionary SM_DICTIONARY_PRIME ON (
>     CHEMBL_20.COMPOUND_STRUCTURES."MOLREGNO" = SM_DICTIONARY_PRIME."MOLREGNO")
>     UNION ALL SELECT CHEMBL_20.SM_REPOSITORY."MOLREGNO",
>     CHEMBL_20.SM_REPOSITORY."CHEMBL_ID" FROM chembl_20.sm_repository)
>     "Small Molecules" LEFT OUTER JOIN chembl_20.compound_properties
>     "Small Molecules_2" ON ("Small Molecules"."MOLREGNO" =
>     "Small Molecules_2"."MOLREGNO") INNER JOIN chembl_20.activities ON ((
>     "Small Molecules"."MOLREGNO" = CHEMBL_20.ACTIVITIES."MOLREGNO") AND ((
>     CHEMBL_20.ACTIVITIES."STANDARD_TYPE" = 'IC50') AND (
>     CHEMBL_20.ACTIVITIES."ASSAY_ID" IN ('654926', '654933'))))
>   WHERE ("Small Molecules"."MOLREGNO" IN (?, ?)
>  
> I get the following traceback, indicating that a class that does not implement Comparable is being stored in a TreeMap:
>       [exec] 23 Mar 2018 15:04:28,282    [Worker67_QueryProcessorQueue3267]      ERROR   PROCESSOR-      TEIID30019 Unexpected exception for request RkVKlFhEnEgf.0: java.lang.ClassCastException: org.teiid.query.sql.symbol.Reference cannot be cast to java.lang.Comparable
>      [exec]     at java.util.TreeMap.getEntry(TreeMap.java:349)
>      [exec]     at java.util.TreeMap.containsKey(TreeMap.java:232)
>      [exec]     at java.util.TreeSet.contains(TreeSet.java:234)
>      [exec]     at java.util.AbstractCollection.containsAll(AbstractCollection.java:318)
>      [exec]     at org.teiid.query.sql.lang.SetCriteria.equals(SetCriteria.java:136)
>      [exec]     at org.teiid.query.optimizer.relational.rules.RuleCopyCriteria.copyCriteria(RuleCopyCriteria.java:169)
>      [exec]     at org.teiid.query.optimizer.relational.rules.RuleCopyCriteria.createCriteria(RuleCopyCriteria.java:341)
>      [exec]     at org.teiid.query.optimizer.relational.rules.RuleCopyCriteria.tryToCopy(RuleCopyCriteria.java:268)
>      [exec]     at org.teiid.query.optimizer.relational.rules.RuleCopyCriteria.visitChildern(RuleCopyCriteria.java:384)
>      [exec]     at org.teiid.query.optimizer.relational.rules.RuleCopyCriteria.tryToCopy(RuleCopyCriteria.java:294)
>      [exec]     at org.teiid.query.optimizer.relational.rules.RuleCopyCriteria.visitChildern(RuleCopyCriteria.java:384)
>      [exec]     at org.teiid.query.optimizer.relational.rules.RuleCopyCriteria.tryToCopy(RuleCopyCriteria.java:294)
>      [exec]     at org.teiid.query.optimizer.relational.rules.RuleCopyCriteria.execute(RuleCopyCriteria.java:99)
>      [exec]     at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:995)
>      [exec]     at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:228)
>      [exec]     at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
>      [exec]     at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:458)
>      [exec]     at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:124)
>      [exec]     at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
>      [exec]     at org.teiid.dqp.internal.process.PreparedStatementRequest.processRequest(PreparedStatementRequest.java:345)
>      [exec]     at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:660)
>      [exec]     at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339)
>      [exec]     at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
>      [exec]     at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)
>      [exec]     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
>      [exec]     at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
>      [exec]     at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
>      [exec]     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>      [exec]     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>      [exec]     at java.lang.Thread.run(Thread.java:745)
>      [exec]



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