[recursive]

Yes. That's part of the semantics of outer joins.

But there is no stored null representing 'no value'.