From c2ea354af8f3c048999a2e7aded4b7167942b755 Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Tue, 24 Aug 2010 11:59:44 +0000
Subject: Use modified bug summary to locate associate packages even with
 version

---
 gentoobrowse/console/bugassociate.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/gentoobrowse/console/bugassociate.xml b/gentoobrowse/console/bugassociate.xml
index 626638e..655e33f 100644
--- a/gentoobrowse/console/bugassociate.xml
+++ b/gentoobrowse/console/bugassociate.xml
@@ -7,7 +7,7 @@
 			SELECT b.bugid, p.packageid
 			FROM bugs b, packages p, categories c
 			WHERE p.categoryid = c.categoryid
-			AND TO_TSVECTOR('english', b.summary) @@ PLAINTO_TSQUERY('english', c.name || '/' || p.name)
+			AND TO_TSVECTOR('english', REGEXP_REPLACE(b.summary,'-[0-9][^ ]*','')) @@ PLAINTO_TSQUERY('english', c.name || '/' || p.name)
 		</sql>
 		<columns>
 			<column key="true">bugid</column>
-- 
cgit v1.2.3