diff options
Diffstat (limited to 'rt/etc/upgrade/4.2.8/content')
-rw-r--r-- | rt/etc/upgrade/4.2.8/content | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/rt/etc/upgrade/4.2.8/content b/rt/etc/upgrade/4.2.8/content new file mode 100644 index 000000000..64b61def7 --- /dev/null +++ b/rt/etc/upgrade/4.2.8/content @@ -0,0 +1,16 @@ +use strict; +use warnings; + +our @Initial = ( + sub { + # This upgrade step is identical to the 4.2.7 upgrade, but only + # runs on Oracle because 4.2.7 was originally released with + # flawed SQL which did not run on Oracle. + return unless RT->Config->Get('DatabaseType') eq 'Oracle'; + RT->DatabaseHandle->dbh->do(<<EOSQL); + DELETE FROM Attributes + WHERE (Name = 'LinkValueTo' OR Name = 'IncludeContentForValue') + AND (LENGTH(Content) = 0 OR Content IS NULL) +EOSQL + }, +); |