From d3772b039fe6bf91badc3756a5f9d1e2484497e6 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Fri, 16 Sep 2005 22:02:56 +0000
Subject: [PATCH] =?utf8?q?Bug=20308653:=20The=20error=20'relation=20"map?=
 =?utf8?q?=5Fproducts"=20does=20not=20exist'=20is=20returned=20using=20Pos?=
 =?utf8?q?tgreSQL=20when=20the=20classification=20column=20is=20displayed?=
 =?utf8?q?=20-=20Patch=20by=20Fr=C3=A9d=C3=A9ric=20Buclin=20<LpSolit@gmail?=
 =?utf8?q?.com>=20r=3Dmkanat=20a=3Djustdave?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 Bugzilla/Search.pm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index 7ac64ec968..56d2846f37 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -136,11 +136,11 @@ sub init {
     }
 
     if (lsearch($fieldsref, 'map_classifications.name') >= 0) {
+        push @supptables, "INNER JOIN products AS map_products " .
+                          "ON bugs.product_id = map_products.id";
         push @supptables,
                 "INNER JOIN classifications AS map_classifications " .
                 "ON map_products.classification_id = map_classifications.id";
-        push @supptables, "INNER JOIN products AS map_products " .
-                          "ON bugs.product_id = map_products.id";
     }
 
     if (lsearch($fieldsref, 'map_components.name') >= 0) {
-- 
2.47.2