[
https://issues.apache.org/jira/browse/HIVE-4575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13661083#comment-13661083
]
Eric Hanson commented on HIVE-4575:
-----------------------------------
I did the following in SQL Server:
create table t(a int);
insert t values(1);
insert t values(2);
insert t values(3);
insert t values(NULL);
select * from t where NOT (a >= 2); -- result: 1
select * from t where NOT (a <= 2); -- result: 3
The value NULL is never returned.
I think the repro here in our code is that you'd get 1 & NULL and 3 & NULL
returned.
> In place filtering in Not Filter doesn't handle nulls correctly.
> ----------------------------------------------------------------
>
> Key: HIVE-4575
> URL: https://issues.apache.org/jira/browse/HIVE-4575
> Project: Hive
> Issue Type: Sub-task
> Reporter: Jitendra Nath Pandey
> Assignee: Jitendra Nath Pandey
>
> The FilterNotExpr evaluates the child expression and takes the compliment of
> the selected vector. Since child expression filters out null values, the
> compliment includes the nulls in the output. This is incorrect because
> not(null) = null.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
