Note that currently, the OUTER JOIN tests (most likely) do not contain data which requires an OUTER JOIN, i.e. every record on the left side is matched by a record on the right side of the join. This needs to be updated so there are NULL records on the right side of the joined data.