[jira] [Created] (DRILL-5713) Doing joins on tables that share column names in a JDBC store returns incorrect results

["Timothy Farkas (JIRA)" <ji...@apache.org>]

Timothy Farkas created DRILL-5713:
-------------------------------------

             Summary: Doing joins on tables that share column names in a JDBC store returns incorrect results
                 Key: DRILL-5713
                 URL: https://issues.apache.org/jira/browse/DRILL-5713
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Relational Operators
    Affects Versions: 1.11.0
         Environment: My mac running the latest drill in embedded mode.
            Reporter: Timothy Farkas
            Assignee: Timothy Farkas


If there are two tables in Postgres that share column names, incorrect results are returned when a join is done between the two tables.

For example if we have two tables: categories and categories2 with the following contents:

+---------------+---------------------+---------------+
| categoryguid  | categoryparentguid  | categoryname  |
+---------------+---------------------+---------------+
| id1           | null                | restaurants   |
| null          | id1                 | food&Dining   |
| id2           | null                | Coffee Shops  |
| null          | id2                 | food&Dining   |
+---------------+---------------------+---------------+

Then the following join query returns incorrectly names columns and incorrect null values:

select cat.categoryname, cat2.categoryname from postgres.public.categories cat join postgres.public.categories2 cat2 on (cat.categoryguid = cat2.categoryguid) where cat.categoryguid IS NOT NULL;

+---------------+----------------+
| categoryname  | categoryname0  |
+---------------+----------------+
| restaurants   | null           |
| Coffee Shops  | null           |
+---------------+----------------+



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)