From 16ff305f8bebcb4b9187fe17fa9d739c19dabbbe Mon Sep 17 00:00:00 2001
From: Dave Miller <justdave@bugzilla.org>
Date: Fri, 31 Jul 2026 00:24:36 -0400
Subject: [PATCH] Bug 1308109: Fix crash when displaying "Blocks" or "Dedends
 on" as column on Oracle (#236)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Co-authored-by: Frédéric Buclin <LpSolit@gmail.com>
---
 Bugzilla/DB/Oracle.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/Bugzilla/DB/Oracle.pm b/Bugzilla/DB/Oracle.pm
index 30015a0d7..13e8f0631 100644
--- a/Bugzilla/DB/Oracle.pm
+++ b/Bugzilla/DB/Oracle.pm
@@ -117,7 +117,7 @@ sub sql_group_concat {
   my ($self, $text, $separator) = @_;
   $separator = $self->quote(', ') if !defined $separator;
   my ($distinct, $rest) = $text =~ /^(\s*DISTINCT\s|)(.+)$/i;
-  return "group_concat($distinct T_CLOB_DELIM(NVL($rest, ' '), $separator))";
+  return "group_concat($distinct T_CLOB_DELIM(NVL(TO_CHAR($rest), ' '), $separator))";
 }
 
 sub sql_regexp {
-- 
2.47.3