From 25de3add9dedd00d20ff9e35a5d20f3163ee9437 Mon Sep 17 00:00:00 2001 From: "mkanat%bugzilla.org" <> Date: Wed, 12 Dec 2007 07:51:14 +0000 Subject: Bug 375007: [Oracle] Some CGIs use SQL names in their "AS" clauses that don't work in Oracle Patch By Xiaoou Wu r=mkanat, a=mkanat --- Bugzilla/BugMail.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'Bugzilla/BugMail.pm') diff --git a/Bugzilla/BugMail.pm b/Bugzilla/BugMail.pm index 1f10714e8..967ad8ca3 100644 --- a/Bugzilla/BugMail.pm +++ b/Bugzilla/BugMail.pm @@ -113,7 +113,7 @@ sub Send { my %values = %{$dbh->selectrow_hashref( 'SELECT ' . join(',', editable_bug_fields()) . ', reporter, - lastdiffed AS start, LOCALTIMESTAMP(0) AS end + lastdiffed AS start_time, LOCALTIMESTAMP(0) AS end_time FROM bugs WHERE bug_id = ?', undef, $id)}; @@ -123,7 +123,7 @@ sub Send { my $component = new Bugzilla::Component($values{component_id}); $values{component} = $component->name; - my ($start, $end) = ($values{start}, $values{end}); + my ($start, $end) = ($values{start_time}, $values{end_time}); # User IDs of people in various roles. More than one person can 'have' a # role, if the person in that role has changed, or people are watching. -- cgit v1.2.3-24-g4f1b