From 2f3084922bfe7cb8759fe4064c46311385fa23f0 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Fri, 16 Sep 2005 21:57:00 +0000
Subject: =?UTF-8?q?Bug=20308653:=20The=20error=20'relation=20"map=5Fproduc?=
 =?UTF-8?q?ts"=20does=20not=20exist'=20is=20returned=20using=20PostgreSQL?=
 =?UTF-8?q?=20when=20the=20classification=20column=20is=20displayed=20-=20?=
 =?UTF-8?q?Patch=20by=20Fr=C3=A9d=C3=A9ric=20Buclin=20<LpSolit@gmail.com>?=
 =?UTF-8?q?=20r=3Dmkanat=20a=3Djustdave?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
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 55113f641..fc66d7f24 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -139,11 +139,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) {
-- 
cgit v1.2.1