[ 
https://issues.apache.org/jira/browse/DRILL-657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Nadeau resolved DRILL-657.
----------------------------------

    Resolution: Fixed

> Selecting all columns with filter only returns column specified in where 
> clause
> -------------------------------------------------------------------------------
>
>                 Key: DRILL-657
>                 URL: https://issues.apache.org/jira/browse/DRILL-657
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>    Affects Versions: m1
>            Reporter: Krystal
>            Assignee: Jacques Nadeau
>             Fix For: 0.4.0
>
>
> 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 |
> +------------+------------+



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to