From 4192ccfd0318d1772df6ff58ad06966ddd0c5449 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Fri, 20 Feb 2009 14:12:49 +0000
Subject: =?UTF-8?q?Bug=20477459:=20buglist.cgi=20crashes=20for=20logged=20?=
 =?UTF-8?q?out=20users=20if=20the=20"Reporter"=20column=20is=20displayed?=
 =?UTF-8?q?=20-=20Patches=20by=20Fr=C3=83=C2=A9d=C3=83=C2=A9ric=20Buclin?=
 =?UTF-8?q?=20<LpSolit@gmail.com>=20and=20Xiaoou=20<xiaoou.wu@oracle.com>?=
 =?UTF-8?q?=20r/a=3Dmkanat?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 Bugzilla/DB/Oracle.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'Bugzilla/DB')

diff --git a/Bugzilla/DB/Oracle.pm b/Bugzilla/DB/Oracle.pm
index ee150c024..83ece2a05 100644
--- a/Bugzilla/DB/Oracle.pm
+++ b/Bugzilla/DB/Oracle.pm
@@ -52,7 +52,7 @@ use base qw(Bugzilla::DB);
 use constant EMPTY_STRING  => '__BZ_EMPTY_STR__';
 use constant ISOLATION_LEVEL => 'READ COMMITTED';
 use constant BLOB_TYPE => { ora_type => ORA_BLOB };
-use constant GROUPBY_REGEXP => '((CASE\s+WHEN.+END)|(TO_CHAR\(.+\))|(\(SCORE.+\))|(\(MATCH.+\))|(\w+(\.\w+)?))(\s+AS\s+)?(.*)?$';
+use constant GROUPBY_REGEXP => '((CASE\s+WHEN.+END)|(SUBSTR.+\))|(TO_CHAR\(.+\))|(\(SCORE.+\))|(\(MATCH.+\))|(\w+(\.\w+)?))(\s+AS\s+)?(.*)?$';
 
 sub new {
     my ($class, $user, $pass, $host, $dbname, $port) = @_;
-- 
cgit v1.2.1