View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0009539 | MMW v4 | Framework: Scripts/Extensions | public | 2012-07-25 18:49 | 2012-12-22 02:32 |
| Reporter | Ludek | Assigned To | |||
| Priority | urgent | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 4.0 | ||||
| Target Version | 4.1 | Fixed in Version | 4.1 | ||
| Summary | 0009539: ISDBDatabase::GetAutoPlaylistQuery doesn't work correctly for limited auto-playlists | ||||
| Description | If an AutoPlaylist has a limit, no LIMIT clause is appended to the SQL. However, if you base your AutoPlaylist A on another AutoPlaylist B and B has a track limit then is the LIMIT clause appended the SQL of A (but still not on B). Example: "Last 50 played" ISDBDatabase::GetAutoPlaylistQuery generates this SQL which lacks the LIMIT clause: SELECT Songs.* FROM Songs WHERE Songs.PlayCounter>0 ORDER BY Songs.LastTimePlayed If you then create another AutoPlaylist which is based on "Last 50 played", you get this SQL which contains the LIMIT clause in the nested statement: SELECT Songs.* FROM Songs WHERE ( Songs.Id IN (SELECT Songs.Id FROM Songs WHERE Songs.PlayCounter>0 ORDER BY Songs.LastTimePlayed LIMIT 50) ) | ||||
| Additional Information | http://www.mediamonkey.com/wiki/index.php/ISDBDatabase::GetAutoPlaylistQuery | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1601 | ||||
