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

Sean Hsuan-Yi Chu updated DRILL-3019:
-------------------------------------
    Description: 
A query which has a pattern:
column IN (1, 1 + 1, 1 + 2)

For the tuple, Calcite makes a plan like
{code}
UnionAll(all=[true])
  UnionAll(all=[true])
    Project(EXPR$0=[+(1, 1)])
      Values
    Project(EXPR$0=[+(1, 2)])
      Values
  Values
{code}

At execution, the schema of the recordbatch from scanning Values is 
[`ZERO`(BIGINT: OPTIONAL),  `*`(BIGINT: OPTIONAL)].

The second column (i.e., `*`) is not supposed to be there.

  was:
A query which has a pattern:
column IN (1, 1 + 1, 1 + 2)

For the tuple, Calcite makes a plan like
{code}
UnionAll(all=[true])
  UnionAll(all=[true])
    Project(EXPR$0=[+(1, 1)])
      Values
    Project(EXPR$0=[+(1, 2)])
      Values
  Values
{/code}

At execution, the schema of the recordbatch from scanning Values is 
[`ZERO`(BIGINT: OPTIONAL),  `*`(BIGINT: OPTIONAL)].

The second column (i.e., `*`) is not supposed to be there.


> Extra column in Schema of Recordbatch from scanning Values 
> -----------------------------------------------------------
>
>                 Key: DRILL-3019
>                 URL: https://issues.apache.org/jira/browse/DRILL-3019
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Other
>            Reporter: Sean Hsuan-Yi Chu
>            Assignee: Jacques Nadeau
>         Attachments: DRILL-3019.1.patch
>
>
> A query which has a pattern:
> column IN (1, 1 + 1, 1 + 2)
> For the tuple, Calcite makes a plan like
> {code}
> UnionAll(all=[true])
>   UnionAll(all=[true])
>     Project(EXPR$0=[+(1, 1)])
>       Values
>     Project(EXPR$0=[+(1, 2)])
>       Values
>   Values
> {code}
> At execution, the schema of the recordbatch from scanning Values is 
> [`ZERO`(BIGINT: OPTIONAL),  `*`(BIGINT: OPTIONAL)].
> The second column (i.e., `*`) is not supposed to be there.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to