[ https://issues.apache.org/jira/browse/DRILL-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16654384#comment-16654384 ]
Carolina Gomes commented on DRILL-5713: --------------------------------------- Hello, is there any ETA to when this bug will be solved? It is pretty basic and prevents joining in cases where column names are the same, no matter the plugin. > 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, Storage - JDBC > Affects Versions: 1.11.0 > Environment: My mac running the latest drill in embedded mode. > Reporter: Timothy Farkas > Assignee: Timothy Farkas > Priority: Major > Labels: newbie > > 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 (v7.6.3#76005)