Closed jankovicgd closed 1 year ago
@lubojr @constantinius not sure where this edge case appears. Perhaps a table with footprints and the footprints in Coverage
and Product
could be foreign keys to avoid duplication. Although when writing queries such as in this case its not immediately obvious which one to use.
The fix should take parent product footprint only if coverage footprint is null (as a generic fix)
The query may use some advanced logic, and for our use case at the moment it may not be necessary, added reminder and merging
It is valid, its maybe designed a bit weirdly, since you can have coverages that don't share the footprint but share a single product.