tcbyurlconfig and mtbfconfig should constraint productdims_id to be unique. Expected: Duplicate inserts to configure a product / version should fail. Actual: Duplciates entries into either config are allowed.
Also, please ensure that productdims will not allow duplicate dims.
Summary: Add index or other constraints to tcbyurlconfig, mtbfconfig productdims_id column → Add index or other constraints to tcbyurlconfig, mtbfconfig productdims_id column; productdims
the two mentioned config tables will be going away 'soon' when the new materialized view code becomes effective. The new table, product_visibility will not allow duplicate productdims_id The (new) productdims table does not allow duplicate product/version pairs.
Resolved with last Thursday's drop onto production of the new materialized views
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
Component: Socorro → General
Product: Webtools → Socorro
You need to log in before you can comment on or make changes to this bug.