]
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: