[
https://issues.apache.org/jira/browse/PHOENIX-2779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197906#comment-15197906
]
ckran commented on PHOENIX-2779:
--------------------------------
To reproduce this problem:
create table a (code varchar(8) primary key, name varchar(8)) ;
create table b (code varchar(8) primary key, name varchar(8)) ;
upsert into a values ('1', 'James') ;
upsert into b values ('1', 'James') ;
upsert into a (code) values ('2') ;
upsert into b (code) values ('2') ;
select * from a inner join b on a.name = b.name ;
> JOIN on NULL valued columns returns result
> -------------------------------------------
>
> Key: PHOENIX-2779
> URL: https://issues.apache.org/jira/browse/PHOENIX-2779
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.6.0
> Reporter: ckran
>
> A JOIN of two tables with an ON condition for columns where there is no value
> returns those rows as though they were equal.
> Arguably an equality condition NULL=NULL should evaluate as NULL.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
