Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5235

Could not find symbol in processing an inline view using except

    Details

      Description

      With a query such as:

      SELECT case when agent_tin_id is null then 'Y' else 'N' end agent_tin_id from (SELECT agent_tin_id from MySQL_Server.bitool.AGENT_DIM where agent_tin_id>100 except( SELECT agent_tin_id from MySQL_Server.bitool.AGENT_DIM where agent_tin_id=100)) a

      When not fully pushed is processed as an anti semi join, but results in an exception:

      org.teiid.core.TeiidRuntimeException: Planning error. Could not find symbol: a.agent_tin_id
      	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.initialize(RelationalPlan.java:87)
      	at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:223)
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: