[
https://issues.apache.org/jira/browse/PHOENIX-3633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16064376#comment-16064376
]
Sergey Soldatov commented on PHOENIX-3633:
------------------------------------------
[~jerryhe] Could you add a UT for this particular case? I've tested the patch
against main branch and haven't found any issues, but it would be nice to have
a separate UT for such kind of queries.
> 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)
