Bug 147298

Summary: smartplaylists: "does not contain label" doesn't match songs with no label
Product: [Applications] amarok Reporter: Eric Vaandering <ewv>
Component: Playlists/Saved PlaylistsAssignee: Amarok Bugs <amarok-bugs-null>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: NOR    
Version First Reported In: 1.4.6   
Target Milestone: ---   
Platform: Ubuntu   
OS: Linux   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:

Description Eric Vaandering 2007-06-27 18:11:02 UTC 
Version:           1.4.6 (using KDE KDE 3.5.6)
Installed from:    Ubuntu Packages
OS:                Linux

When using labels on Amarok 1.4.6 with SQLite I don's see this problem, but with MySQL I do. The issue is that Dynamic Playlists using "Label does not contain" searches do not work correctly.


To reproduce this, take (say) 200 tracks and divide them into 4 groups of 50.

Group 1: No labels
Group 2: assign "LabelA"
Group 3: assign "LabelB"
Group 4: assign "LabelA" and "LabelB"

Now create a dynamic playlist that "does not contain" "LabelB". What you will get is just group 2, while you should get groups 1&2. As mentioned, the behavior seems to be OK on SQLite which I use on my laptop but not on MySQL which I use with my media PC. Just a guess, but I think MySQL defines *any* comparison operation with NULL to be FALSE.
Comment 1 Eric Vaandering 2007-06-28 04:12:49 UTC 
The same symptoms were also in 1.4.5
Comment 2 Seb Ruiz 2007-09-26 05:40:11 UTC 

*** This bug has been marked as a duplicate of 140542 ***