[ 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, [~jinxing6...@126.com]! > 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)