Comment 1 for bug 523901

> It's actually called patch-2207-09.0.sql. That's not right.

Thank you. the name should be -0.sql.

I'll need to clean the data again before the constrain is applied...okay there were only 2 bad packages in staging created over 3 months, that was an easy fix.

I cannot create the insane data using the views, but I can see the bzr-upload was created 3 weeks ago. Either the views were fixed in the last release, or there is way to create a duplicate package that does not use +ubuntupkg.

Before we do our next rollout, a losa should ping me if this SQL query returns dupes. I can fix them in a few minutes.
https://pastebin.canonical.com/28142/