[Enhancement] there is redundant column in scannode

[englefly]

Search before asking

• I had searched in the issues and found no similar issues.

Description

mysql> explain verbose select count(*) from lineorder where lo_quantity<25;
There are two columns (lo_custkey and lo_quantity) in scan_node plan. However, scan on lo_custkey is unnecessary.

Solution

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[morrySnow]

This is related to column pruner. Some work has already been done on join node (#8618). However, in current framework, we still have a lot of work to do to get accurate column prune capabilities.

[englefly]

done #10615

[Kikyou1997]

done #10615

This issue could be reopened now, This PR #10615 has some memory problems which was triggerred during TPC-DS tests as described in issue #10725.