From c9a255ebf46695b350cc5a9f917247537b5be911 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Thu, 26 Feb 2009 20:52:40 +0000
Subject: Bug 477745: [Oracle] Search doesn't work because of sql_string_until
 - Patch by Xiaoou <xiaoou.wu@oracle.com> r/a=mkanat

---
 Bugzilla/DB/Oracle.pm | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'Bugzilla/DB')

diff --git a/Bugzilla/DB/Oracle.pm b/Bugzilla/DB/Oracle.pm
index 83ece2a05..23b97a0d2 100644
--- a/Bugzilla/DB/Oracle.pm
+++ b/Bugzilla/DB/Oracle.pm
@@ -149,6 +149,13 @@ sub sql_string_concat {
     return 'CONCAT(' . join(', ', @params) . ')';
 }
 
+sub sql_string_until {
+    my ($self, $string, $substring) = @_;
+    return "SUBSTR($string, 1, " 
+           . $self->sql_position($substring, $string)
+           . " - 1)";
+}
+
 sub sql_to_days {
     my ($self, $date) = @_;
 
-- 
cgit v1.2.3-24-g4f1b