count(distinct _row_id) causing other count(distinct ...) producing wrong result

[stdrc]

Describe the bug

No response

Error message/log

No response

To Reproduce

dev=> create table t (foo int, bar int);
CREATE_TABLE
dev=> insert into t values (1, 1), (2, 2), (1, 1);
INSERT 0 3
dev=> select count(foo), count(distinct foo) from t;
 count | count 
-------+-------
     3 |     2
(1 row)

dev=> select count(foo), count(distinct foo), count(distinct _row_id) from t;
 count | count | count 
-------+-------+-------
     3 |     1 |     3
             ^
           wrong
(1 row)

dev=> select count(foo), count(distinct foo), count(distinct bar) from t;
 count | count | count 
-------+-------+-------
     3 |     2 |     2
(1 row)

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

No response