From 8cf4ef03913d7866655f40eab3dff80f1559ac5b Mon Sep 17 00:00:00 2001 From: "mkanat%bugzilla.org" <> Date: Fri, 1 Aug 2008 05:05:24 +0000 Subject: Bug 448614: [Oracle] Logic error in _get_alter_type_sql Patch By Xiaoou Wu r=mkanat, a=mkanat --- Bugzilla/DB/Schema/Oracle.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Bugzilla/DB/Schema') diff --git a/Bugzilla/DB/Schema/Oracle.pm b/Bugzilla/DB/Schema/Oracle.pm index 6b6fa5c57..05c2bbeb3 100644 --- a/Bugzilla/DB/Schema/Oracle.pm +++ b/Bugzilla/DB/Schema/Oracle.pm @@ -322,7 +322,7 @@ sub _get_alter_type_sql { } # If this column is no longer TEXT/VARCHAR, we need to drop the trigger # that went along with it. - if ( $old_def->{TYPE} !~ /varchar|text/i + if ( $old_def->{TYPE} =~ /varchar|text/i && $old_def->{NOTNULL} && $new_def->{TYPE} !~ /varchar|text/i ) { -- cgit v1.2.3-24-g4f1b