Revisiting the Artist and All Artists Index

[simbun]

If we use this Elton John album as an example, it sounds like you're storing:

TRACK 1: ARTIST=Elton John & Dua Lipa
TRACK 2: ARTIST=Elton John, Young Thug & Nicki Minaj
...

Then storing the multi-valued artist tag in ARTISTS e.g.

TRACK 1: ARTISTS=Elton John
TRACK 1: ARTISTS=Dua Lipa
TRACK 2: ARTISTS=Elton John
TRACK 2: ARTISTS=Young Thug
TRACK 2: ARTISTS=Nicki Minaj
...


These are the results for my UPnP search for 'Elton John' in BubbleUPnP:
   

As you can see I have 1 Artist returned, and that Artist is Elton John. If I click through it will lead me to all of his tracks where he's a track artist.

If I performed the same search against just this one album using your data I'd have 16 results for Artist, containing:
Elton John & Dua Lipa
Elton John, Young Thug & Nicki Minaj
...

Obviously the AlbumArtist search problem won't be as bad as this Artist example, but I hope you understand the potential issue.