diff options
| author | mkanat%bugzilla.org <> | 2008-07-01 15:23:17 +0200 |
|---|---|---|
| committer | mkanat%bugzilla.org <> | 2008-07-01 15:23:17 +0200 |
| commit | 6ebbe174496b4f39a0737ec5febbaf78422e0856 (patch) | |
| tree | 42dd93883fdafc8cc2f27aad136c77ac25027bee /Bugzilla/DB | |
| parent | 42019e83f7bd6c93e889eeb04c059fbee7f562d4 (diff) | |
| download | bugzilla-6ebbe174496b4f39a0737ec5febbaf78422e0856.tar.gz bugzilla-6ebbe174496b4f39a0737ec5febbaf78422e0856.tar.xz | |
Bug 442848: [Oracle] Remove hardcoded "ORDER BY quipid" in Bugzilla::DB::Oracle
Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
Diffstat (limited to 'Bugzilla/DB')
| -rw-r--r-- | Bugzilla/DB/Oracle.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/Bugzilla/DB/Oracle.pm b/Bugzilla/DB/Oracle.pm index 13c4c1792..1814dccdb 100644 --- a/Bugzilla/DB/Oracle.pm +++ b/Bugzilla/DB/Oracle.pm @@ -319,8 +319,8 @@ sub adjust_statement { if ($new_sql =~ /(.*\s+)FROM(\s+.*)/i) { my ($before_from,$after_from) = ($1,$2); $before_where = "$before_from FROM ($before_from," - . " ROW_NUMBER() OVER (ORDER BY quipid) R " - . " FROM $after_from ) "; + . " ROW_NUMBER() OVER (ORDER BY 1) R " + . " FROM $after_from ) "; $after_where = " R BETWEEN $offset+1 AND $limit+$offset"; } } else { |