summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
authormkanat%bugzilla.org <>2008-07-01 15:23:17 +0200
committermkanat%bugzilla.org <>2008-07-01 15:23:17 +0200
commit6ebbe174496b4f39a0737ec5febbaf78422e0856 (patch)
tree42dd93883fdafc8cc2f27aad136c77ac25027bee /Bugzilla
parent42019e83f7bd6c93e889eeb04c059fbee7f562d4 (diff)
downloadbugzilla-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')
-rw-r--r--Bugzilla/DB/Oracle.pm4
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 {