I know of someone - I'll use John Smith as a pseudonym for him - who has gone through life officially as John Holder Smith. The middle name came about because both parents, little baby and toddler sister all went to register the birth. Father, who was a very abrupt character, was giving the information and was also carrying wriggling daughter. The Registrar asked for the new baby's name and Father said "John" then, to his wife "Hold her!" and handed the toddler over, then to Registrar, "Smith". He then realised that the Registrar had put the unwanted middle name in. The Registrar insisted that as the certificate had been filled the Father would have to pay again to have an amended one. Father refused and John's birth certificate will no doubt cause endless headaches for family researchers in the future, trying to tie in his middle name with non-existant connections.