From 793c103590ff0742b6163dca25cfc6250c68f803 Mon Sep 17 00:00:00 2001 From: "mkanat%bugzilla.org" <> Date: Fri, 18 Jan 2008 21:56:53 +0000 Subject: Bug 408172: [Oracle] Bug lists longer than 1000 bugs fail Patch By Xiaoou Wu r=mkanat, a=mkanat --- process_bug.cgi | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) (limited to 'process_bug.cgi') diff --git a/process_bug.cgi b/process_bug.cgi index 71be09168..35d41ee00 100755 --- a/process_bug.cgi +++ b/process_bug.cgi @@ -327,11 +327,9 @@ if ($cgi->param('product') ne $cgi->param('dontchange')) { $product = Bugzilla::Product::check_product(scalar $cgi->param('product')); @newprod_ids = ($product->id); } else { - @newprod_ids = @{$dbh->selectcol_arrayref("SELECT DISTINCT product_id - FROM bugs - WHERE bug_id IN (" . - join(',', @idlist) . - ")")}; + @newprod_ids = @{$dbh->selectcol_arrayref( + "SELECT DISTINCT product_id FROM bugs WHERE " + . $dbh->sql_in('bug_id', \@idlist))}; if (scalar(@newprod_ids) == 1) { $product = new Bugzilla::Product($newprod_ids[0]); } -- cgit v1.2.1