diff options
author | bugreport%peshkin.net <> | 2005-02-19 11:04:04 +0100 |
---|---|---|
committer | bugreport%peshkin.net <> | 2005-02-19 11:04:04 +0100 |
commit | 25d5d986a6534cf7d5df7c505b2e99f7b4c02111 (patch) | |
tree | 8e919f7df6b78833adfcafcd3604d82b9465eed4 | |
parent | cc73e8e4f6726abd0421c78445b18bd21b28169e (diff) | |
download | bugzilla-25d5d986a6534cf7d5df7c505b2e99f7b4c02111.tar.gz bugzilla-25d5d986a6534cf7d5df7c505b2e99f7b4c02111.tar.xz |
Bug 282705: Remove newlines from LEFT JOIN parts of SQL in Search.pm
r=lpsolit, a=justdave
-rw-r--r-- | Bugzilla/Search.pm | 18 |
1 files 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 { |