Optimize coalesce of join keys

[kaikalur]

We have seen queries like:

COALESCE(l.id, r.id) FROM l INNER/LEFT JOIN r ON l.id=r.id

Here for both inner ad left joins we can simplify it to l.id since it's a join key. Similarly for the converse for right join. We should apply this rule before join reordering