[PackageType]Reflowing packages with package types cause the records to be duplicated

[joelverhagen]

There should only be one.

[joelverhagen]

There are 219 packages on PROD with duplicate package types. This query can be used to find them. After this change ships to PROD gallery we can just reflow these packages:

SELECT MAX(pr.Id) AS Id, MAX(p.NormalizedVersion) AS NormalizedVersion, MAX(p.[Key]) AS PackageKey, pt.[Name], COUNT(*) AS [Count]
FROM PackageTypes pt
INNER JOIN Packages p ON pt.PackageKey = p.[Key]
INNER JOIN PackageRegistrations pr ON pr.[Key] = p.PackageRegistrationKey
GROUP BY p.[Key], pt.[Name]
HAVING COUNT(*) > 1
ORDER BY MAX(pr.Id), MAX(p.NormalizedVersion)

[joelverhagen]

Verified and fixed all affected packages.