From 5be75754f810eb414b666f3894e2dbf8943e3f0f Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Wed, 9 Mar 2005 07:23:30 +0000
Subject: Bug 281582: Replace CONCAT and MATCH with Bugzilla::DB function call
 (Note: This patch also creates a database-agnostic fulltext search method.)
 Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=myk

---
 Bugzilla/DB/Mysql.pm | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

(limited to 'Bugzilla/DB/Mysql.pm')

diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm
index ae24d13bc..76cd0966d 100644
--- a/Bugzilla/DB/Mysql.pm
+++ b/Bugzilla/DB/Mysql.pm
@@ -88,7 +88,7 @@ sub sql_not_regexp {
 }
 
 sub sql_limit {
-    my ($self, $limit,$offset) = @_;
+    my ($self, $limit, $offset) = @_;
 
     if (defined($offset)) {
         return "LIMIT $offset, $limit";
@@ -97,6 +97,18 @@ sub sql_limit {
     }
 }
 
+sub sql_string_concat {
+    my ($self, @params) = @_;
+    
+    return 'CONCAT(' . join(', ', @params) . ')';
+}
+
+sub sql_fulltext_search {
+    my ($self, $column, $text) = @_;
+
+    return "MATCH($column) AGAINST($text)";
+}
+
 sub sql_to_days {
     my ($self, $date) = @_;
 
-- 
cgit v1.2.3-24-g4f1b