Menu

#13 outer joins with constant values don't work

open
nobody
None
7
2003-08-26
2003-08-26
Alan Knight
No

If you do an outer join against something with a constant
value in it, then you don't get results back.
- first, asIndependentJoins is splitting up the clause and
losing the outerJoinness.
- beyond that, the constant test causes the join to be
effectively non-outer anyway.

We really need to detect this and generate a
(const IS NULL OR const = constValue)

Discussion


Log in to post a comment.