From f2df808db17259949894a6431f4bdee6448ef6b5 Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Sat, 3 Jun 2006 05:58:53 +0000 Subject: Bug 340116: Flag::FormToNewFlags() uses incorrect data - Patch by Frédéric Buclin r=kiko a=myk MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- Bugzilla/FlagType.pm | 25 ++++++++++--------------- 1 file changed, 10 insertions(+), 15 deletions(-) (limited to 'Bugzilla/FlagType.pm') diff --git a/Bugzilla/FlagType.pm b/Bugzilla/FlagType.pm index c1dff6bd4..572c4fad7 100644 --- a/Bugzilla/FlagType.pm +++ b/Bugzilla/FlagType.pm @@ -528,26 +528,21 @@ sub sqlify_criteria { # Add inclusions to the query, which simply involves joining the table # by flag type ID and target product/component. - push(@$tables, "INNER JOIN flaginclusions ON " . - "flagtypes.id = flaginclusions.type_id"); - push(@criteria, "(flaginclusions.product_id = $product_id " . - " OR flaginclusions.product_id IS NULL)"); - push(@criteria, "(flaginclusions.component_id = $component_id " . - " OR flaginclusions.component_id IS NULL)"); + push(@$tables, "INNER JOIN flaginclusions AS i ON flagtypes.id = i.type_id"); + push(@criteria, "(i.product_id = $product_id OR i.product_id IS NULL)"); + push(@criteria, "(i.component_id = $component_id OR i.component_id IS NULL)"); # Add exclusions to the query, which is more complicated. First of all, # we do a LEFT JOIN so we don't miss flag types with no exclusions. # Then, as with inclusions, we join on flag type ID and target product/ # component. However, since we want flag types that *aren't* on the - # exclusions list, we add a WHERE criteria to use only records with - # NULL exclusion type, i.e. without any exclusions. - my $join_clause = "flagtypes.id = flagexclusions.type_id " . - "AND (flagexclusions.product_id = $product_id " . - "OR flagexclusions.product_id IS NULL) " . - "AND (flagexclusions.component_id = $component_id " . - "OR flagexclusions.component_id IS NULL)"; - push(@$tables, "LEFT JOIN flagexclusions ON ($join_clause)"); - push(@criteria, "flagexclusions.type_id IS NULL"); + # exclusions list, we add a WHERE criteria to use only records with + # NULL exclusion type, i.e. without any exclusions. + my $join_clause = "flagtypes.id = e.type_id " . + "AND (e.product_id = $product_id OR e.product_id IS NULL) " . + "AND (e.component_id = $component_id OR e.component_id IS NULL)"; + push(@$tables, "LEFT JOIN flagexclusions AS e ON ($join_clause)"); + push(@criteria, "e.type_id IS NULL"); } if ($criteria->{group}) { my $gid = $criteria->{group}; -- cgit v1.2.3-24-g4f1b