1088834 - flaginclusions contains inconsistent data

Status: NEW

(bugzilla.mozilla.org :: General, defect)

Description

[Dylan Hardison [:dylan] (he/him)]

While I am not sure how, flaginclusions contains some entries that refer to a (product_id, component_id) pair that are not longer associated with each other. The following query illustrates this:

SELECT distinct c.name, realproduct.name AS real_product, flagproduct.name AS flag_product 
FROM flaginclusions as f
JOIN components as c ON c.id = component_id
JOIN products as realproduct ON realproduct.id = c.product_id
JOIN products as flagproduct ON flagproduct.id = f.product_id
WHERE c.product_id != f.product_id;