View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005355 | MMW v4 | Other | public | 2009-03-04 21:45 | 2009-06-11 19:17 |
| Reporter | Bex | Assigned To | |||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 3.1 | ||||
| Target Version | 3.1 | Fixed in Version | 3.1 | ||
| Summary | 0005355: Active filter is not correctly applied in Duplicated Tracks Node | ||||
| Description | The active filter is not considered when the duplicates are selected into the temp table but it is applied when the result from it is shown. This leads to that single tracks are shown as duplicates sometimes. (The Duplicate Content Node does this correctly.) Current SQL: INSERT INTO _SongDupTits SELECT DISTINCT upperw(Artist) COLLATE IUNICODE Art, upperw(SongTitle) COLLATE IUNICODE Tit FROM Songs GROUP BY upperw(Artist), upperw(SongTitle) HAVING Count(*)>1 It should be: INSERT INTO _SongDupTits SELECT DISTINCT upperw(Artist) COLLATE IUNICODE Art, upperw(SongTitle) COLLATE IUNICODE Tit FROM Songs WHERE "ACTIVE FILTER SQL" GROUP BY upperw(Artist), upperw(SongTitle) HAVING Count(*)>1 But I suggest this SQL since I don't see the reason to have the parts I removed. It should be faster. :) INSERT INTO _SongDupTits SELECT Artist, SongTitle FROM Songs WHERE "ACTIVE FILTER SQL" GROUP BY Artist, SongTitle HAVING Count(*)>1 | ||||
| Additional Information | Reported here: http://www.mediamonkey.com/forum/viewtopic.php?f=4&t=37725&p=194223 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1254 | ||||
|
|
Fixed in build 1226. |
|
|
Verified 1226. |
|
|
As reported here: http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=40373 The issue isn't fully solved. The Filter-SQL also needs to be applied when the result from the temp-table is retrieved and not only when it's created. |
|
|
Fixed in build 1254. |
|
|
Verified no regressions in 1254. |
