prefer explicit NonEmpty.Pairings for test data, fix test issue with mysql's case insentivity and case varied keys