[teiid-issues] [JBoss JIRA] (TEIID-2669) In subquery with no values returns wrong result

Fri Sep 20 09:16:04 EDT 2013

Steven Hawkins created TEIID-2669:
-------------------------------------

             Summary: In subquery with no values returns wrong result
                 Key: TEIID-2669
                 URL: https://issues.jboss.org/browse/TEIID-2669
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 7.4
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
            Priority: Critical
             Fix For: 8.6

If an in subquery is entered such that no rows will be returned and it is not pushed down, then the rewriter will incorrectly convert the in predicate to an is not null check.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira