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

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12850864#comment-12850864 ] 

RH Bugzilla Integration commented on TEIID-2669:
------------------------------------------------

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1010344|https://bugzilla.redhat.com/show_bug.cgi?id=1010344] from MODIFIED to ON_QA
                
> 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: Blocker
>             Fix For: 8.4.1, 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