phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jerry He (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-3633) null pointer exception when subsquery for not exists returns empty result set
Date Sun, 09 Apr 2017 00:47:41 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-3633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jerry He updated PHOENIX-3633:
------------------------------
    Attachment: PHOENIX-3633.patch

Ran into this problem.  Attach a fix.

> 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
>         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.3.15#6346)

Mime
View raw message