Bug 147298

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.