[jira] [Created] (PHOENIX-3633) null pointer exception when subsquery for not exists returns empty result set

[N Campbell (JIRA)]

N Campbell created PHOENIX-3633:
-----------------------------------

             Summary: null pointer exception when subsquery for not exists 
returns empty result set
                 Key: PHOENIX-3633
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3633
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.7.0
            Reporter: N Campbell


phoenix-4.7.0.2.5.3.0-37-client

select RNUM, C1, C2 from TJOIN2 where not exists ( select C1 from TJOIN1 where 
C2=500)

Error while executing SQL "select RNUM, C1, C2 from TJOIN2 where not exists ( 
select C1 from TJOIN1 where C2=500)": Remote driver error: 
NullPointerException: (null exception message)

create table  if not exists TJOIN1 (RNUM integer  not null primary key , C1 
integer, C2 integer);

upsert into TJOIN1 (RNUM, C1, C2) values ( 0, 10, 15);
upsert into TJOIN1 (RNUM, C1, C2) values ( 1, 20, 25);
upsert into TJOIN1 (RNUM, C1, C2) values ( 2, NULL, 50);

create table  if not exists TJOIN2 (RNUM integer  not null primary key , C1 
integer, C2 char(2));

upsert into TJOIN2 (RNUM, C1, C2) values ( 0, 10, 'BB');
upsert into TJOIN2 (RNUM, C1, C2) values ( 1, 15, 'DD');
upsert into TJOIN2 (RNUM, C1, C2) values ( 2, NULL, 'EE');
upsert into TJOIN2 (RNUM, C1, C2) values ( 3, 10, 'FF');




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)