[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1683) Error Code:0 Message: Remote org.teiid.core.TeiidException:Error Code: 0 Message:Symbol EMAIL.EMAILDOCUMENT.MAPPINGCLASSES.EMAIL_1.id is specified with an unknown group context

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-1683.
-----------------------------------

    Resolution: Done


Updated the criteria planning logic to correctly form the join.

> Error Code:0 Message: Remote org.teiid.core.TeiidException:Error Code: 0 Message:Symbol EMAIL.EMAILDOCUMENT.MAPPINGCLASSES.EMAIL_1.id is specified with an unknown group context
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-1683
>                 URL: https://issues.jboss.org/browse/TEIID-1683
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.4
>            Reporter: Caleb Corliss
>            Assignee: Steven Hawkins
>             Fix For: 7.4.1
>
>
> Teiid 7.4 encounters an issue when you try to run a query against an Teiid database mapped via an XML document that requires multiple joins.  We are able to successfully query the VDB and return the XML if we map a single join, however, when we attempt to map a second join table we receive the following error:
> A little background:
>   We have a email schema with a variety of attributes and elements (simple and complex.)  For example:
> Our schema looks similar to this:
> <code>
> <element name="Email" type="email" />
> <complex-type name="email">
>   <sequence>
>     <element name="sent"    type="dateTime" />
>     <element name="subject" type="string" />
>     <element name="address" type="emailAddress" maxOccurs="unbounded" />
>     <element name="body"    type="string" maxOccurs="unbounded" />
>   </sequence>
>     <attribute name="id" type="long" use="required" />
> </complex-type>
> <complex-type name="emailAddress">
>   <sequence>
>     <element name="address" type="emailAddress"/>
>     <element name="type"    type="string" />
>   </sequence>
> </complex-type>
> </code>
> We are able to successfully build the VDB mapping it from the "email" element from the schema.  The id from the email object is used from the INPUTS to map the bodies and emailAddress tables to the email document.  The XML document is mapped to 3 PostgreSQL tables (email, address, and body.)  We are able to run queries that have filter criteria for two tables (the primary and one other;) however, when we try to place criteria against the third we get the following TeiidException:
> "Error Code:0 Message: Remote org.teiid.core.TeiidException:Error Code: 0 Message:Symbol EMAIL.EMAILDOCUMENT.MAPPINGCLASSES.EMAIL_1.id is specified with an unknown group context"
> For example the following "mock" queries would work just fine:
> <code>SELECT * FROM emailDocument WHERE subject like '%' OR body like '%'</code>
> <code>SELECT * FROM emailDocument WHERE subject like '%' OR emailAddress.address like '%'</code>
> However, this query would fail and throw the exception specified above.
> <code>SELECT * FROM emailDocument WHERE subject like '%' OR body like '%' OR emailAddress.address like '%'</code>

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira