[otrs-cvs] otrs/Kernel/System DB.pm,1.149,1.150
"CVS commits notifications of OTRS.org" <[email protected]>
| Newsgroups | gmane.comp.otrs.cvs |
|---|---|
| Message-ID | <[email protected]> |
Comments:
Update of /home/cvs/otrs/Kernel/System
In directory lancelot:/tmp/cvs-serv532/Kernel/System
Modified Files:
DB.pm
Log Message:
Implemented rownum (limit) for oracle database. Removed unused 'fetch' condition. Untested yet.
Author: des
Index: DB.pm
===================================================================
RCS file: /home/cvs/otrs/Kernel/System/DB.pm,v
retrieving revision 1.149
retrieving revision 1.150
diff -2 -u -d -r1.149 -r1.150
--- DB.pm 20 Nov 2012 15:33:53 -0000 1.149
+++ DB.pm 4 Dec 2012 13:15:43 -0000 1.150
@@ -560,6 +560,6 @@
$SQL .= " LIMIT $Limit";
}
- elsif ( $Self->{Backend}->{'DB::Limit'} eq 'fetch' ) {
- $SQL .= " fetch $Limit first row";
+ elsif ( $Self->{Backend}->{'DB::Limit'} eq 'rownum' ) {
+ $SQL = 'SELECT * FROM (' . $SQL . ') WHERE ROWNUM <= ' . $Limit;
}
else {
---------------------------------------------------------------------
OTRS mailing list: cvs-log - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/cvs-log
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/cvs-log