fix: unassigned shards must return NULL by default for the `primary` column