Jack Chen

I think this approach makes sense and works, but have we considered these alternative approaches: 1. I think it could also be fixed it by pulling the in/exists expression into...

Yeah, in the prior examples it worked because the group-by columns will determine the value of the exists - that was only true when the aggregates did not use any...

@andylam-db @vitaliili-db

Sure, I'll update the PR. > Not related to this PR. It seems we should move the test case Test logic for determining whether a query is semantically sorted to...

Hi @HyukjinKwon @dongjoon-hyun can you do a quick review of the updated PR?