[DRILL-789] Left outer join returns "null" values for columns from the right table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Execution - Flow
• Assignee: Unassigned
• Reporter: Krystal
• Created: 20/May/14 17:34
• Updated: 16/Mar/17 18:37
• Resolved: 09/Jun/14 07:16

Description

git.commit.id.abbrev=5d7e3d3

0: jdbc:drill:schema=dfs> select voter.name voter_name, voter.registration registration, student.name student_name, student.gpa gpa from voter left outer join student on (student.name = voter.name) where voter.age < 30;
----------------------------------------------+

voter_name

registration

student_name

gpa

----------------------------------------------+

[B@6ca2652	[B@4199d4f9	null	null
[B@5a6d4914	[B@3cd8ee6d	null	null
[B@460d5550	[B@155c1b1e	null	null
[B@51f85986	[B@7bd9675	null	null
[B@2fe0df4b	[B@5463cd7b	null	null
[B@64477185	[B@e6e0632	null	null