There are also fringe externalities from this too. I have my mom's last name for my middle name and my dad's for my last name. But back in the 90s, my state would erroneously handle that scenario as having no middle name and both names hyphenated for a last name. I didn't find this out until I turned 18 and tried to get a retail job and they wouldn't hire me until it got fixed.

First I had to go to the Dept of Health and get a new birth certificate, then I had to do the same at the social security administration for a new social security card. Hours and hours over multiple days just so I could earn minimum wage folding and selling used clothing. Ironically, the name mixup never was a problem when I did taxes previously.