Bug 1492346 - scripts/syncflags.pl should also add the target product to any tracking flags that the source product is a member

1 files changed, 12 insertions, 0 deletions

diff --git a/scripts/syncflags.pl b/scripts/syncflags.pl
index e6b521e62..c99fd5160 100755
--- a/scripts/syncflags.pl
+++ b/scripts/syncflags.pl
@@ -75,6 +75,7 @@ if (!$tgtprodid) {
     exit(1);
 }
 
+# Normal flags such as bug flags and attachment flags
 $dbh->do("INSERT INTO flaginclusions(component_id, type_id, product_id)
                SELECT fi1.component_id, fi1.type_id, ? FROM flaginclusions fi1
             LEFT JOIN flaginclusions fi2
@@ -85,6 +86,17 @@ $dbh->do("INSERT INTO flaginclusions(component_id, type_id, product_id)
         undef,
         $tgtprodid, $tgtprodid, $srcprodid);
 
+# Tracking type flags
+$dbh->do("INSERT INTO tracking_flags_visibility (tracking_flag_id, product_id, component_id)
+               SELECT tf1.tracking_flag_id, ?, tf1.component_id FROM tracking_flags_visibility tf1
+            LEFT JOIN tracking_flags_visibility tf2
+                      ON tf1.tracking_flag_id = tf2.tracking_flag_id
+                      AND tf2.product_id = ?
+                WHERE tf1.product_id = ?
+                      AND tf2.tracking_flag_id IS NULL",
+        undef,
+        $tgtprodid, $tgtprodid, $srcprodid);
+
 # It's complex to determine which items now need to be flushed from memcached.
 # As this is expected to be a rare event, we just flush the entire cache.
 Bugzilla->memcached->clear_all();