Major Description
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');