fix: raise when join introduces duplicates

fix: raise when join introduces duplicates #6294