Bugzilla – Bug 3699
When the Composer and Artist are the same, duplicate tracks created in playlist
Last modified: 2008-09-15 14:39:24 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.
Just to add I see excatly the same behaviour on Linux 6.5b1 8330.
I am able to reliably reproduce this as well.
Fixed in change 8434