[jira] [Assigned] (PHOENIX-3633) null pointer exception when subsquery for not exists returns empty result set
[ https://issues.apache.org/jira/browse/PHOENIX-3633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Istvan Toth reassigned PHOENIX-3633: Assignee: Istvan Toth (was: Jerry He) > 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 >Assignee: Istvan Toth >Priority: Major > Attachments: PHOENIX-3633.patch > > > 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 (v8.3.4#803005)
[jira] [Assigned] (PHOENIX-3633) null pointer exception when subsquery for not exists returns empty result set
[ https://issues.apache.org/jira/browse/PHOENIX-3633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal reassigned PHOENIX-3633: -- Assignee: Jerry He (was: NIDHI GAMBHIR) > 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 >Assignee: Jerry He > Attachments: PHOENIX-3633.patch > > > 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.4.14#64029)
[jira] [Assigned] (PHOENIX-3633) null pointer exception when subsquery for not exists returns empty result set
[ https://issues.apache.org/jira/browse/PHOENIX-3633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] NIDHI GAMBHIR reassigned PHOENIX-3633: -- Assignee: NIDHI GAMBHIR > 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 >Assignee: NIDHI GAMBHIR > > 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.15#6346)
