View Issue Details

IDProjectCategoryView StatusLast Update
0018888MMW 5Main Panelpublic2022-03-04 18:54
Reporterbarrym Assigned To 
PriorityurgentSeverityminorReproducibilityalways
Status closedResolutionfixed 
PlatformWindowsOS-OS Version10
Product Version5.0.3 
Target Version5.0.3Fixed in Version5.0.3 
Summary0018888: Filter syntax genre:xxx is unreliable where tracks have multiple genre tags (regression 2609)
Descriptionversion: 2609
try using a filter genre:xxx
where xxx is a tag that is used with tracks with multiple genre tags
in MM4 this filter found all tracks using this genre tag, including those with multiple genre tags
in MM5 this filter does not work reliably

I have 1458 tracks which contain the taped genre (ie. audience taped)
all of those tracks have multiple genre tags, ie. taped and something other genre, joined by a semi colon
MM5 is returning just one album, with 13 tracks, from the filter genre:taped

After some digging I see your query in the debug log
SELECT Songs.* FROM Songs WHERE Songs.ID IN (SELECT rowid FROM SongsText WHERE SongsText MATCH ' genre: taped* ')

that is only going to select tracks where taped is the first of multiple genre tags that are assigned to a track, isn't it?
This is verified by looking at the album that is chosen. Unlike all the other tracks it has Genre as its first tag
Steps To Reproduce1. modify a track to have multiple genre tags; eg xxx; yyy
2. try to filter to that track with genre:yyy
3. ==> track not found
4. in MM4 filter genre:yyy found the track successfully
Additional Informationarising out of Mantis 18877
and forum thread https://www.mediamonkey.com/forum/viewtopic.php?t=101462
TagsNo tags attached.
Fixed in build2610

Relationships

related to 0018883 closedLudek 'The H' does not find 'The Human League' (regression 2609) 
related to 0018893 closedbarrym Filtering is broken by "Ignore Prefixes" settings when using the (default) Ignore Diacritics sort options (2609) 

Activities

Ludek

2022-03-02 22:37

developer   ~0067166

Couldn't this be a test error? I can't replicate, see:
image.png (20,617 bytes)   
image.png (20,617 bytes)   

Ludek

2022-03-02 22:38

developer   ~0067167

Probably a small testing MM5.DB and or video + description of exact search settings would help here...

barrym

2022-03-03 01:56

updater   ~0067168

maybe you fixed it with 18883?
I have sort set to Ignore Diacritics & Match beginning of words .... that's the default isn't it?
video: https://www.dropbox.com/s/l9ua9g4ycv1rcd7/mantis%2018888.mp4?dl=0
image of sort settings: https://www.dropbox.com/s/l9ua9g4ycv1rcd7/mantis%2018888.mp4?dl=0

can send database if required

barrym

2022-03-03 01:59

updater   ~0067169

whoops, one link incorrect:
image of sort settings: https://www.dropbox.com/s/nx1q5u4jrfz2t2t/mantis%2018888.png?dl=0

Ludek

2022-03-03 13:04

developer   ~0067170

Last edited: 2022-03-03 13:04

Ok, this was fixed y the same fix as 0018883
i.e. was regression in 2609 caused by fixing 0018863

i.e. already fixed in 2610

lowlander

2022-03-04 18:54

developer   ~0067197

Verified in 2610 as fixed in 0018883