optimize_projections rule breaks some view operation

[lewiszlw]

Describe the bug

commit: ee7ab0b
If comment out optimize_projections rule, then works fine.

To Reproduce

create table users (id int, name varchar);
insert into users values (1, 'Tom');
create view v as select count(id) from users;
select count(1) from v;

Expected behavior

No response

Additional context

No response

[alamb]

I wonder if @mustafasrepo 's PR #8960 could possible fix this issue

[lewiszlw]

I wonder if @mustafasrepo 's PR #8960 could possible fix this issue

No.

[Lordworms]

I would like to try this one

[simonvandel]

It seems there is already a fix here #8992

[Lordworms]

It seems there is already a fix here #8992

seems like it is fixed, thanks!