This has occurred before; see: https://www.researchgate.net/post/The_join_command_seems_to_be_messing_up_when_using_numbers_as_the_comparing_fields_Any_ideas
Alas, my actual data are IPv4 addresses, numbered in the millions; that workaround may be unworkable.
