[DRILL-1295] Select returns null for non pivot fields with a nested select

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Execution - Data Types
• Assignee: DrillCommitter
• Reporter: Hanifi Gunes
• Created: 13/Aug/14 18:38
• Updated: 18/Aug/14 16:26
• Resolved: 18/Aug/14 16:26

Description

Take two simple csv files:

t1.csv:
ID,Name,Lastname
9711942,name0,last0
9707867,name1,last1

t2.csv
ID,Case Number
9711942,HX362083
9707867,HX357851

The following queries return:
select columns[0], columns[1], columns[2]
FROM dfs.`/path/to/t1.csv`;
--------------------------------

ID	Name	Lastname
9711942	name0	last0
9707867	name1	last1

--------------------------------

SELECT columns[0], columns[1] FROM dfs.`/path/to/t2.csv`;
----------------------+

ID	Case Number
9711942	HX362083
9707867	HX357851

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

This one returns all the fields null except the pivot field
select columns[0], columns[1], columns[2]
FROM dfs.`/path/to/t1.csv`
where columns[0] in
(SELECT columns[0] FROM dfs.`/path/to/t2.csv`);

--------------------------------

ID	null	null
9711942	null	null
9707867	null	null

--------------------------------