You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2014/08/28 03:45:58 UTC

[jira] [Resolved] (OPTIQ-373) NULL values in NOT IN sub-queries

     [ https://issues.apache.org/jira/browse/OPTIQ-373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde resolved OPTIQ-373.
-------------------------------

       Resolution: Fixed
    Fix Version/s: 0.9.1-incubating

Fixed in  http://git-wip-us.apache.org/repos/asf/incubator-optiq/commit/793e5c4d.

> NULL values in NOT IN sub-queries
> ---------------------------------
>
>                 Key: OPTIQ-373
>                 URL: https://issues.apache.org/jira/browse/OPTIQ-373
>             Project: Optiq
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>             Fix For: 0.9.1-incubating
>
>         Attachments: OPTIQ-373.1.patch
>
>
> Write a test to check that NOT IN evaluates to unknown, and therefore returns all rows, if the sub-query returns a null.
> Fix if necessary. Also test composite keys.



--
This message was sent by Atlassian JIRA
(v6.2#6252)