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

jin xing updated CALCITE-3405:
------------------------------
    Description: 
Say *beatles* is a *ProjectableFilterableTable*, below Sqls fail to do column 
pruning by *BindableTableScan*
{code:java}
Schema of beatles:
i int
j int
k int


select k, 3 from beatles;

select k + j from beatles;{code}
The reason is that *ProjectableFilterableTable* only works when the *Project* 
is a simple mapping.

 

> Prune columns for ProjectableFilterable when project is not simple mapping
> --------------------------------------------------------------------------
>
>                 Key: CALCITE-3405
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3405
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: jin xing
>            Assignee: jin xing
>            Priority: Major
>
> Say *beatles* is a *ProjectableFilterableTable*, below Sqls fail to do column 
> pruning by *BindableTableScan*
> {code:java}
> Schema of beatles:
> i int
> j int
> k int
> select k, 3 from beatles;
> select k + j from beatles;{code}
> The reason is that *ProjectableFilterableTable* only works when the *Project* 
> is a simple mapping.
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to