Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4395

equi-inner join of two tables in Postgres returns null one of the projected columns

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.5.0
    • 1.16.0
    • Storage - JDBC
    • None

    Description

      This query should return 1,2,3,4 in both columns but returns null in the second column. Both tables are in a Postgres 9.5 server mapped under Drill

      select tint.rnum, tbint.rnum from postgres.public.tint , postgres.public.tbint where tint.cint = tbint.cbint

      create table TINT ( RNUM integer not null , CINT integer ) ;
      insert into TINT(RNUM, CINT) values ( 0, NULL);
      insert into TINT(RNUM, CINT) values ( 1, -1);
      insert into TINT(RNUM, CINT) values ( 2, 0);
      insert into TINT(RNUM, CINT) values ( 3, 1);
      insert into TINT(RNUM, CINT) values ( 4, 10);

      create table TBINT ( RNUM integer not null , CBINT bigint ) ;
      insert into TBINT(RNUM, CBINT) values ( 0, NULL);
      insert into TBINT(RNUM, CBINT) values ( 1, -1);
      insert into TBINT(RNUM, CBINT) values ( 2, 0);
      insert into TBINT(RNUM, CBINT) values ( 3, 1);
      insert into TBINT(RNUM, CBINT) values ( 4, 10);

      Attachments

        Activity

          People

            Unassigned Unassigned
            the6campbells N Campbell
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: