[
https://issues.apache.org/jira/browse/PHOENIX-3627?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Istvan Toth resolved PHOENIX-3627.
----------------------------------
Resolution: Duplicate
The issue is valid, but we already have a ticket for it.
> equi-join predicate should not return a row where null values are compared
> --------------------------------------------------------------------------
>
> Key: PHOENIX-3627
> URL: https://issues.apache.org/jira/browse/PHOENIX-3627
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.7.0
> Environment: Hortonworks 2.5.3
> Reporter: N Campbell
> Priority: Major
>
> Following query should not return a row where NULL values are compared with
> an equality predicate.
> select TINT.RNUM, TSINT.RNUM, TINT.CINT , TSINT.CSINT from TINT , TSINT where
> TINT.CINT = TSINT.CSINT
> TINT.RNUM TSINT.RNUM TINT.CINT TSINT.CSINT
> 0 0 <null> <null>
> 1 1 -1 -1
> 2 2 0 0
> 3 3 1 1
> 4 4 10 10
> create table if not exists TSINT ( RNUM integer not null primary key ,
> CSINT smallint );
> create table if not exists TINT ( RNUM integer not null primary key , CINT
> integer );
> upsert into TSINT(RNUM, CSINT) values ( 0, NULL);
> upsert into TSINT(RNUM, CSINT) values ( 1, -1);
> upsert into TSINT(RNUM, CSINT) values ( 2, 0);
> upsert into TSINT(RNUM, CSINT) values ( 3, 1);
> upsert into TSINT(RNUM, CSINT) values ( 4, 10);
> upsert into TINT(RNUM, CINT) values ( 0, NULL);
> upsert into TINT(RNUM, CINT) values ( 1, -1);
> upsert into TINT(RNUM, CINT) values ( 2, 0);
> upsert into TINT(RNUM, CINT) values ( 3, 1);
> upsert into TINT(RNUM, CINT) values ( 4, 10);
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
