[DRILL-657] Selecting all columns with filter only returns column specified in where clause

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.1.0-m1
• Fix Version/s: 0.4.0
• Component/s: SQL Parser
• Assignee: Jacques Nadeau
• Reporter: Krystal
• Created: 07/May/14 17:11
• Updated: 31/Jul/14 05:53
• Resolved: 31/Jul/14 05:53

Description

In the latest drill merge, select all columns with filters does not return all columns from table. Instead it returns only columns specified in the where clause.

select * from voter where age < 19;
------------

age

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

18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18

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

select * from voter where name like '%van%' and age < 30;
----------------------+

age

name

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

19	[B@52aadf7b
25	[B@50362ea3

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

Issue Links

• Is contained by: DRILL-931 Wildcard queries cause problems in certain schemaless situations