From a9fd0d7e538ed6c14f4f9b8a855e91393f1b902d Mon Sep 17 00:00:00 2001 From: "mkanat%bugzilla.org" <> Date: Wed, 13 Aug 2008 11:12:41 +0000 Subject: Bug 442882: Populating bugs_fulltext can be very slow on large installations Patch By Max Kanat-Alexander r=dkl, a=mkanat --- Bugzilla/DB/Mysql.pm | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'Bugzilla/DB') diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm index 43646d8de..d645d79c5 100644 --- a/Bugzilla/DB/Mysql.pm +++ b/Bugzilla/DB/Mysql.pm @@ -106,6 +106,15 @@ sub bz_last_key { return $last_insert_id; } +sub sql_group_concat { + my ($self, $column, $separator) = @_; + my $sep_sql; + if ($separator) { + $sep_sql = " SEPARATOR $separator"; + } + return "GROUP_CONCAT($column$sep_sql)"; +} + sub sql_regexp { my ($self, $expr, $pattern, $nocheck) = @_; -- cgit v1.2.3-24-g4f1b