
The source of this seems to be that I have mp3 files with multiple genre tags in the header, which I purposely did for use with a couple of other programs / devices.
For instance, I have files from Bela Fleck with two Genre Tags:
GENRE = Country
GENRE = Jazz
This is as opposed to having GENRE = Country;Jazz as I realize is more typical, but a couple of programs I use prefer having multiple GENRE tags rather than one with multiple genres in one GENRE tag. With one GENRE tag and multiple values it does work as expected with MediaMonkey but not for my other programs, but MediaMonkey is still relatively functional otherwise, whereas the other programs don't work. I just would hope that if I am looking for a track under Rock that there would be only one Rock option and not 3 as I have now.
The problem "bug" I think comes from the SQL not handling the multiple GENRE tags in the DB as it should, and I do believe that it isn't completely unusual to use multiple tags for items like GENRE, ARTIST, etc.
The other program I use, SqueezeServer (for a Squeezebox) does not show the same behavior in its SQL DB, so my guess is that it could be made to work right with MediaMonkey, and it may be just a matter of modifying an SQL statement accordingly.