From 25d5d986a6534cf7d5df7c505b2e99f7b4c02111 Mon Sep 17 00:00:00 2001 From: "bugreport%peshkin.net" <> Date: Sat, 19 Feb 2005 10:04:04 +0000 Subject: Bug 282705: Remove newlines from LEFT JOIN parts of SQL in Search.pm r=lpsolit, a=justdave --- Bugzilla/Search.pm | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index e58278f48..6584f1080 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -453,9 +453,9 @@ sub init { $chartseq = "CC$sequence"; $sequence++; } - push(@supptables, "LEFT JOIN cc cc_$chartseq - ON bugs.bug_id = cc_$chartseq.bug_id - AND cc_$chartseq.who = $match"); + push(@supptables, "LEFT JOIN cc cc_$chartseq " + . "ON bugs.bug_id = cc_$chartseq.bug_id " + . "AND cc_$chartseq.who = $match"); $term = "cc_$chartseq.who IS NOT NULL"; }, "^cc,(?:notequals),(%\\w+%)" => sub { @@ -465,9 +465,9 @@ sub init { $chartseq = "CC$sequence"; $sequence++; } - push(@supptables, "LEFT JOIN cc cc_$chartseq - ON bugs.bug_id = cc_$chartseq.bug_id - AND cc_$chartseq.who = $match"); + push(@supptables, "LEFT JOIN cc cc_$chartseq " + . "ON bugs.bug_id = cc_$chartseq.bug_id " + . "AND cc_$chartseq.who = $match"); $term = "cc_$chartseq.who IS NULL"; }, "^cc,(anyexact|substring)" => sub { @@ -603,9 +603,9 @@ sub init { if (Param("insidergroup") && !&::UserInGroup(Param("insidergroup"))) { $extra = "AND $table.isprivate < 1"; } - push(@supptables, "LEFT JOIN longdescs $table - ON $table.bug_id = bugs.bug_id $extra - AND $table.who IN ($match)"); + push(@supptables, "LEFT JOIN longdescs $table " + . "ON $table.bug_id = bugs.bug_id $extra " + . "AND $table.who IN ($match)"); $term = "$table.who IS NOT NULL"; }, "^commenter," => sub { -- cgit v1.2.3-24-g4f1b