Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3633

null pointer exception when subsquery for not exists returns empty result set

    Details

    • Type: Bug
    • Status: Patch Available
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.7.0
    • Fix Version/s: None
    • Labels:
      None

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

        Attachments

          Activity

            People

            • Assignee:
              jerryhe Jerry He
              Reporter:
              the6campbells N Campbell
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: