You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Olga Natkovich (JIRA)" <ji...@apache.org> on 2008/09/17 17:27:44 UTC
[jira] Resolved: (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 ]
Olga Natkovich resolved PIG-434.
--------------------------------
Resolution: Fixed
patch committed, thanks, pradeep
> 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
>
> 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.