Bug 3699 - When the Composer and Artist are the same, duplicate tracks created in playlist
: When the Composer and Artist are the same, duplicate tracks created in playlist
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.5b1
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-07-06 05:33 UTC by Christopher Key
Modified: 2008-09-15 14:39 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Christopher Key 2006-07-06 05:33:04 UTC
When playing all songs from an album, any tracks with the same artist and composer appear twice in the playlist.  This only occurs when the album has been reached via Browse -> Artists etc, and not via Browse -> Albums.

The SQL statement executed (from --d_sql) was:

2006-07-06 13:25:57.1034 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.tag, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me  JOIN albums album ON ( album.id = me.album ) LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id )  JOIN contributors contributor ON ( contributor.id = contributorTracks.contributor ) WHERE ( album.id = ? AND contributor.id = ? ) ORDER BY album.titlesort, me.disc, me.tracknum, me.titlesort (`57', `231')

Perhaps this should be a SELECT DISTINCT instead.
Comment 1 Richard Harnwell 2006-07-09 04:04:09 UTC
Just to add I see excatly the same behaviour on Linux 6.5b1 8330.
Comment 2 Chris Owens 2006-07-13 13:38:21 UTC
I am able to reliably reproduce this as well.
Comment 3 Dan Sully 2006-07-13 23:35:57 UTC
Fixed in change 8434