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

Pradeep Kamath updated PIG-434:
-------------------------------

    Description: 
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)

{code}

        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

{code}

  was:
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)

{code}

        // 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

{code}


> 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: types_branch
>            Reporter: Pradeep Kamath
>             Fix For: types_branch
>
>
> 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)
> {code}
>         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
> {code}

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

Reply via email to