From 9ddb229412d652238dabd39f8c46d2e81c0466f6 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Ji=C5=99=C3=AD=20Netolick=C3=BD?= <netolish@netolish.cz>
Date: Mon, 23 Sep 2013 17:41:26 +0200
Subject: [PATCH] Bug 919475: [Oracle] Crash when non-mandatory free text
 custom fields are left empty on bug creation r=LpSolit a=justdave

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

diff --git a/Bugzilla/DB/Schema/Oracle.pm b/Bugzilla/DB/Schema/Oracle.pm
index 1bed5b5cad..1554a0fe19 100644
--- a/Bugzilla/DB/Schema/Oracle.pm
+++ b/Bugzilla/DB/Schema/Oracle.pm
@@ -205,6 +205,10 @@ sub get_add_column_ddl {
     }
     else {
         @sql = $self->SUPER::get_add_column_ddl(@_);
+        # Create triggers to deal with empty string. 
+        if ($definition->{TYPE} =~ /varchar|TEXT/i && $definition->{NOTNULL}) {
+            push(@sql, _get_notnull_trigger_ddl($table, $column));
+        }
     }
 
     return @sql;
-- 
2.47.2