[PIG-434] AND and OR do not give right results with nulls

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.2.0
• Fix Version/s: 0.2.0
• Patch Info: Patch Available
• Assignee: Pradeep Kamath
• Reporter: Pradeep Kamath
• Created: 16/Sep/08 21:41
• Updated: 24/Mar/10 22:04
• Resolved: 17/Sep/08 15:26

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)

        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