Did you know ... Search Documentation:
CQL: Retrieved nulls have special logic to handle outer joins