diff options
| author | randomdan <randomdan@localhost> | 2010-08-24 11:59:44 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-08-24 11:59:44 +0000 |
| commit | c2ea354af8f3c048999a2e7aded4b7167942b755 (patch) | |
| tree | 7d2d6bc5f139251e73f96f7f27562a1bdb24e744 | |
| parent | Tidy up and prettehize (diff) | |
| download | gentoobrowse-c2ea354af8f3c048999a2e7aded4b7167942b755.tar.bz2 gentoobrowse-c2ea354af8f3c048999a2e7aded4b7167942b755.tar.xz gentoobrowse-c2ea354af8f3c048999a2e7aded4b7167942b755.zip | |
Use modified bug summary to locate associate packages even with version
| -rw-r--r-- | gentoobrowse/console/bugassociate.xml | 2 |
1 files changed, 1 insertions, 1 deletions
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> |