[teiid-issues] [JBoss JIRA] Created: (TEIID-1617) Incorrect rewrite of subquery

[Steven Hawkins (JIRA)]

Incorrect rewrite of subquery
-----------------------------

                 Key: TEIID-1617
                 URL: https://issues.jboss.org/browse/TEIID-1617
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 7.4
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
            Priority: Critical
             Fix For: 7.4.1


when performing a semi-join against a query with a key preserved in the semi join criteria and a non-distinct subquery the planner will incorrectly created an unnested query that does not preserve the semi-join.  This can happen with either the explicit mj hint or with the query unnesting property set.

e.g.

select col2 from tbl where keyCol IN (select dupCol from tbl2)

will become

select col2 from tbl, tbl2 where keyCol = tbl2

rather than

select col2 from tbl, (select distinct dupCol from tbl2) x where keyCol = tbl2

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