[
https://issues.apache.org/jira/browse/PIG-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13009338#comment-13009338
]
Olga Natkovich commented on PIG-1922:
-------------------------------------
We are following SQL semantics for NULL handling wherever possible. SQL is not
very consistent on this point; however, it is considered to be a standard for
relational processing and many people are familiar with its semantics so doing
this is the safest choice.
> null is being treated as string constant in expressions
> -------------------------------------------------------
>
> Key: PIG-1922
> URL: https://issues.apache.org/jira/browse/PIG-1922
> Project: Pig
> Issue Type: Bug
> Affects Versions: 0.8.0, 0.9.0
> Reporter: Thejas M Nair
> Fix For: 0.9.0
>
>
> In following statement, the null gets translated to string constant. The
> statement is invalid, and should result in an error.
> {code}
> fil = filter l by a != null; -- This does not give an error, the correct
> usage is "a is not null"
> fil = filter l by a != adsf; -- this does give an error message saying that
> there is no column asdf
> {code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
