diff options
| author | mkanat%bugzilla.org <> | 2008-01-18 22:56:53 +0100 |
|---|---|---|
| committer | mkanat%bugzilla.org <> | 2008-01-18 22:56:53 +0100 |
| commit | 793c103590ff0742b6163dca25cfc6250c68f803 (patch) | |
| tree | 854667752ad8e4377c7bc18c2b40177e7f3083da /Bugzilla/Search.pm | |
| parent | 2c8316b9f30ca3ab96b7e8acd1275253ae3e272f (diff) | |
| download | bugzilla-793c103590ff0742b6163dca25cfc6250c68f803.tar.gz bugzilla-793c103590ff0742b6163dca25cfc6250c68f803.tar.xz | |
Bug 408172: [Oracle] Bug lists longer than 1000 bugs fail
Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
Diffstat (limited to 'Bugzilla/Search.pm')
| -rw-r--r-- | Bugzilla/Search.pm | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index b30f74911..8fa27143b 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -352,8 +352,8 @@ sub init { $extra .= " AND actcheck.added = $sql_chvalue"; } push(@supptables, "LEFT JOIN bugs_activity AS actcheck " . - "ON $extra AND actcheck.fieldid IN (" . - join(",", @actlist) . ")"); + "ON $extra AND " + . $dbh->sql_in('actcheck.fieldid', \@actlist)); } # Now that we're done using @list to determine if there are any @@ -1082,7 +1082,7 @@ sub init { push(@list, $q); } if (@list) { - $term = "$ff IN (" . join (',', @list) . ")"; + $term = $dbh->sql_in($ff, \@list); } }, ",anywordssubstr" => sub { @@ -1519,7 +1519,7 @@ sub build_subselect { my $dbh = Bugzilla->dbh; my $list = $dbh->selectcol_arrayref($q); return "1=2" unless @$list; # Could use boolean type on dbs which support it - return "$outer IN (" . join(',', @$list) . ")"; + return $dbh->sql_in($outer, $list); } sub GetByWordList { |