[
https://issues.apache.org/jira/browse/OPTIQ-373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated OPTIQ-373:
------------------------------
Description:
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.
was:
Write a test to check that NOT IN evaluates to true, and therefore returns all
rows, if the sub-query returns a null.
Fix if necessary.
Also test composite keys.
> NOT IN and NULL values
> ----------------------
>
> Key: OPTIQ-373
> URL: https://issues.apache.org/jira/browse/OPTIQ-373
> Project: Optiq
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> 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)
