RSS

trunk : 6119

mkanat%bugzilla.org
2008-07-01 08:23:17
Revision ID: cvs-1:mkanatbugzilla.org-20080701132317-c1snhak8y7uc99rn
Bug 442848: [Oracle] Remove hardcoded "ORDER BY quipid" in Bugzilla::DB::Oracle Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat

collapse all collapse all

added added

removed removed

/static/images/treeExpanded.png Bugzilla/DB/Oracle.pm
319
             if ($new_sql =~ /(.*\s+)FROM(\s+.*)/i) { 
319
             if ($new_sql =~ /(.*\s+)FROM(\s+.*)/i) { 
320
                 my ($before_from,$after_from) = ($1,$2);
320
                 my ($before_from,$after_from) = ($1,$2);
321
                 $before_where = "$before_from FROM ($before_from,"
321
                 $before_where = "$before_from FROM ($before_from,"
322
                              . " ROW_NUMBER() OVER (ORDER BY quipid) R "
322
                             . " ROW_NUMBER() OVER (ORDER BY 1) R "
323
                              . " FROM $after_from ) "; 
323
                             . " FROM $after_from ) "; 
324
                 $after_where = " R BETWEEN $offset+1 AND $limit+$offset";
324
                 $after_where = " R BETWEEN $offset+1 AND $limit+$offset";
325
             }
325
             }
326
         } else {
326
         } else {

Loggerhead runs on Bazaar branches