[Bug] where predicate can not be pushed down when querying logic view #9476

Search before asking

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

Version

trunk

What's Wrong?

create table tbl1(k1 int, v1 int) distributed by hash(k1) buckets 1 properties("replication_num" = "1");
create view tblv1 as select k1, sum(v1) from tbl1 group by 1;
create view tblv2 as select k1, count(distinct v1) from tbl1 group by 1;

1. For query

select * from tblv1 where k1 =1;

the k1=1 can be pushed down to scan node.

2. For query

select * from tblv2 where k1 =1;

the k1=1 can NOT be pushed down to scan node.

What You Expected?

For both query, where predicate can be pushed down to scan node.

How to Reproduce?

No response

Anything Else?

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