-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Normal
-
Affects Version/s: None
-
Component/s: Edit system
-
None
While working on MBS-3494, I've noticed that there are some duplicate artist credits in the database. For example:
acoustid=> select * from artist_credit_name where artist_credit in (832431, 44954);
artist_credit | position | artist | name | join_phrase
---------------+----------+--------+--------+-------------
44954 | 0 | 44954 | 590816 |
832431 | 0 | 44954 | 590816 |
(2 rows)
acoustid=> select * from artist_credit where id in (832431, 44954);
id | name | artist_count | ref_count | created
--------+--------+--------------+-----------+-------------------------------
44954 | 590816 | 1 | 3471 | 2011-05-16 16:32:11.963929+00
832431 | 590816 | 1 | 280 | 2011-06-21 18:59:35.986056+00
(2 rows)