diff options
| author | Xiaoou Wu <xiaoou.wu@oracle.com> | 2010-03-02 00:26:08 +0100 |
|---|---|---|
| committer | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-03-02 00:26:08 +0100 |
| commit | 8d0710acaba90364e20af1cb9d23a8ad62f3bcd3 (patch) | |
| tree | 8e652d80aeee5ee12c6e2564e6b51571bc6b601c /Bugzilla/DB/Oracle.pm | |
| parent | cab671b774f077dbb47bf8904fb11cca60204ab0 (diff) | |
| download | bugzilla-8d0710acaba90364e20af1cb9d23a8ad62f3bcd3.tar.gz bugzilla-8d0710acaba90364e20af1cb9d23a8ad62f3bcd3.tar.xz | |
Bug 541553: [Oracle] Drop triggers when dropping columns, and drop the
left-behind PRODUCTS_MILESTONEURL trigger that currently exists in 3.6/trunk.
r=mkanat, a=mkanat
Diffstat (limited to 'Bugzilla/DB/Oracle.pm')
| -rw-r--r-- | Bugzilla/DB/Oracle.pm | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/Bugzilla/DB/Oracle.pm b/Bugzilla/DB/Oracle.pm index 801823372..5dd127882 100644 --- a/Bugzilla/DB/Oracle.pm +++ b/Bugzilla/DB/Oracle.pm @@ -676,6 +676,14 @@ sub bz_setup_database { } } + # Drop the trigger which causes bug 541553 + my $trigger_name = "PRODUCTS_MILESTONEURL"; + my $exist_trigger = $self->selectcol_arrayref( + "SELECT OBJECT_NAME FROM USER_OBJECTS + WHERE OBJECT_NAME = ?", undef, $trigger_name); + if(@$exist_trigger) { + $self->do("DROP TRIGGER $trigger_name"); + } } package Bugzilla::DB::Oracle::st; |