Expressions in having clauses are not getting rewritten properly for join queries

The issue is not seen in test cases yet since somehow the order of child candidates in JoinCandidate has been fixed. We have observed the order being non-deterministic in production. And in one ordering, having clause works fine and in another it doesn't. Will be adding test cases to reproduce this issue and the fix as well.