[1395] - Expanding AlbumArtist in a collection fails [#7985]

[toof4st]

I have a created Collection, and within that, I have a AlbumArtist (other nodes may also be affected). Expanding this node, fails with an error.
It fails even if there is no filter on the collection.
However it works on the main Music tree.

Error is:
---------------------------
MediaMonkey
---------------------------
Error executing SQL "SELECT Artists.ID, Artists.Artist,Artists.Albums AS cnt FROM Artists
WHERE Artists.ID IN (SELECT ArtistsSongs.IDArtist FROM ArtistsSongs WHERE ArtistsSongs.PersonType=1 AND ArtistsSongs.idSong IN (SELECT ID FROM Songs WHERE((1))))
OR Artists.ID IN (SELECT ArtistsAlbums.IDArtist FROM ArtistsAlb" : cannot use index: idxSongsTrackTypeAlbumID (1, 1)
---------------------------
OK
---------------------------


Thanks

[Stigg]

Yeah. I am having the same problem with v4.0.0.1395.

First Error


Second Error

[jiri]

Thanks, it will be fixed in the next build.

Jiri