This bothers me too. It is known from Ireland and the British Isles, but little evidence of the song in America before the Civil War. It may never have been sung by the troops during the time of the Mexican War. Evidence is largely second-hand even for the 1860 and later period.