Canadian recording. Probably a traditional from Nova Scotia, while mostly viewed as Irish or Scottish (the places mentioned: Old Meldrum, Fyvie and Aberdeen are all Scottish). Linked with Carrickfergus, The Water Is Wide and The Banks Of The Sweet Primroses. Was a broadside in Boston in the 1830s, crediting Charles Dibdin.
Alan Mills & Jean Carignan [on Songs, Fiddle Tunes and a Folk Tale From Canada (Folkways)]
LaRena Clark [also from Canada]
Ted Ashlaw [singer from the Adirondacks]
Sinéad O'Connor [whispering it without gender-change as some lesbian lament]
Chieftains [with the Corrs]