aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJiří Netolický <netolish@netolish.cz>2013-09-23 17:44:20 +0200
committerFrédéric Buclin <LpSolit@gmail.com>2013-09-23 17:44:20 +0200
commit79d280aa1b772eb53fc5772341a79c8a34456767 (patch)
tree6a236d7c501e5a6da1e551baf5aac5e6b5298914
parentBug 848063: [Oracle] importxml.pl fails with ORA-01830: comment timestamps ar... (diff)
downloadbugzilla-79d280aa1b772eb53fc5772341a79c8a34456767.tar.gz
bugzilla-79d280aa1b772eb53fc5772341a79c8a34456767.tar.bz2
bugzilla-79d280aa1b772eb53fc5772341a79c8a34456767.zip
Bug 919475: [Oracle] Crash when non-mandatory free text custom fields are left empty on bug creation
r=LpSolit a=justdave
-rw-r--r--Bugzilla/DB/Schema/Oracle.pm4
1 files changed, 4 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema/Oracle.pm b/Bugzilla/DB/Schema/Oracle.pm
index 9fafc4515..a61b1e323 100644
--- a/Bugzilla/DB/Schema/Oracle.pm
+++ b/Bugzilla/DB/Schema/Oracle.pm
@@ -219,6 +219,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;