You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Alan Gates (JIRA)" <ji...@apache.org> on 2009/11/12 05:15:39 UTC

[jira] Assigned: (PIG-434) AND and OR do not give right results with nulls

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

Alan Gates reassigned PIG-434:
------------------------------

    Assignee: Pradeep Kamath

> AND and OR do not give right results with nulls
> -----------------------------------------------
>
>                 Key: PIG-434
>                 URL: https://issues.apache.org/jira/browse/PIG-434
>             Project: Pig
>          Issue Type: Bug
>    Affects Versions: 0.2.0
>            Reporter: Pradeep Kamath
>            Assignee: Pradeep Kamath
>             Fix For: 0.2.0
>
>         Attachments: PIG-434.patch
>
>
> Here are the truth tables for AND and OR - currently we do not short circuit and return a null if either operand is null (for both AND and OR)
> {noformat}
>         truth table for AND 
>         t = true, n = null, f = false
>         AND  t n f
>               t    t n f
>              n   n n f
>              f    f f f
>         truth table for OR 
>         t = true, n = null, f = false
>         OR   t n f
>              t    t t t
>             n    t n n
>             f     t n f
> {noformat}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.