Treat null-key records the same way for joins and aggreations

Currently, on aggregation records with null-key get dropped while for joins we raise an exception.

We might want to drop in both cases or raise an exception in both cases to be consistent.