hadoop-pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pradeep Kamath (JIRA)" <j...@apache.org>
Subject [jira] Updated: (PIG-434) AND and OR do not give right results with nulls
Date Tue, 16 Sep 2008 21:45:46 GMT

     [ 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)

{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}

  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)
> {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.


Mime
View raw message