[CALCITE-3405] Prune columns for ProjectableFilterableTable when Project is not simple mapping

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Labels: pull-request-available
• Assignee: Jin Xing
• Reporter: Jin Xing
• Created: 12/Oct/19 04:01
• Updated: 06/Mar/20 04:35
• Resolved: 07/Nov/19 01:51

Description

Say beatles is a ProjectableFilterableTable, below Sqls fail to do column pruning by BindableTableScan

Schema of beatles:
i int
j int
k int


select k, 3 from beatles;

select k + j from beatles;

The reason is that ProjectableFilterableTable only works when the Project is a simple mapping.

 

Issue Links

• relates to: CALCITE-2039 AssertionError when pushing project to ProjectableFilterableTable
• links to: GitHub Pull Request #1500
• links to: GitHub Pull Request #1500