[
https://issues.apache.org/jira/browse/CALCITE-3405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Haisheng Yuan resolved CALCITE-3405.
------------------------------------
Fix Version/s: 1.22.0
Resolution: Fixed
Fixed in
https://github.com/apache/calcite/commit/4bc45cd12ca53ce902e03de45f144a0ac938fbae.
Thanks for the PR, [[email protected]]!
> Prune columns for ProjectableFilterableTable 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
> Labels: pull-request-available
> Fix For: 1.22.0
>
> Time Spent: 2h 20m
> Remaining Estimate: 0h
>
> 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)