Lirong Jian

Please check the description of this issue above. You can create a very simple table, and insert some data. Then, you can use the above SQL statements to reproduce this...

I think you had reproduced the problem: we generated two different plans for those two SQL statements which are functionally equivalent. One uses the GroupAggregate node to perform deduplication, while...

Does it only work when the key of distinct is the same as the distribution key, or it doesn't matter?

> > Yes! > > I want to believe we one time could reduce the number of rows in SubqueryScan. And use Forward and Backward filter pass ) > >...

Thank you very much for bringing up this issue and providing the corresponding patch. Yes, we've run into this problem as well - the same database version behaving inconsistently when...