[Bug]: Smart Playlists - Genre 'does not contain' gives unexpected results with multiple genres about navidrome HOT 5 OPEN

The opening issue (secondary genra LofiGirl not being correctly filtered out) existed in 0.49.3, but I just lived with it, figuring I'd done something wrong. After I upgraded and it persisted, I finally decided to debug some and file this issue.

I'd recommend filing separate issues for the genre bugs you've experienced that's new in 0.50.X

from navidrome.

I've tested this more, to try and narrow this down more.

It seems like it's possible 'does not contain' may only be getting applied correctly if there is only one genre.

A good test is using something like

• Contains: Alt
• Contains Rock
  gives me entries with genres like:
• Alternative Rock
• Pop Punk, Alternative rock, Rock

but

• Contains: Alt
• does not contain: Rock
  yields songs with genres like:
• Alternative Metal, Rock, Alternative Rock
• Alternative Rock, Alternative Metal
• Alternative & Punk
• Alternative
  But I don't see any single genre songs with 'Rock' in the result

So I believe the reduced/core symptom is that 'Does not contain' appears to only correctly apply if there is a single genre. If there are multiple genres, even matching the first genre (e.g. Rock, Alternative) seems insufficient for smart playlists to omit the song.

from navidrome.

Can confirm this behaviour.
"genre isNot X" or "genre notContains X" only filters out tracks that have this genre X and only X
As soon as a track has multiple genres, this filter kinda becomes useless.

My guess is that this filter just translates to filtering the media_file_genres table and then grouping them by song again.

from navidrome.

But I've seen some other genre-related weirdness related to the 0.50.x versions. I had to go back to 0.49.3 to work around this. Something changed here.

from navidrome.