[teiid-issues] [JBoss JIRA] (TEIID-1785) EDS cross join attempting to join on mismatching datatypes

[Steven Hawkins (Resolved) (JIRA)]

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

Steven Hawkins resolved TEIID-1785.
-----------------------------------

    Resolution: Duplicate Issue


Dup of TEIID-1778
                
> EDS cross join attempting to join on mismatching datatypes
> ----------------------------------------------------------
>
>                 Key: TEIID-1785
>                 URL: https://issues.jboss.org/browse/TEIID-1785
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.4.1
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>
> When running a query which appears to be attempting a cross join, from looking at the query plan. This is resulting in an error and stack trace, pointing to the merge join implementation trying to convert from integer to string.
> This is when we provide one item to filter on, so it appears EDS is selecting the number 1 to indicate if it is present, and I think this is what it's trying to join to. When providing more than one thing to filter on, so EDS selects the book ID, the query runs.
> Good and bad query plans are attached.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira