[otrs-cvs] otrs/Kernel/System DB.pm,1.155,1.156
"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-serv12475/Kernel/System
Modified Files:
DB.pm
Log Message:
Fix for SELECT DISTINCT with Limit on Microsoft SQL Server.
Author: mb
Index: DB.pm
===================================================================
RCS file: /home/cvs/otrs/Kernel/System/DB.pm,v
retrieving revision 1.155
retrieving revision 1.156
diff -2 -u -d -r1.155 -r1.156
--- DB.pm 11 Dec 2012 14:38:03 -0000 1.155
+++ DB.pm 17 Jan 2013 07:14:45 -0000 1.156
@@ -1,5 +1,5 @@
# --
# Kernel/System/DB.pm - the global database wrapper to support different databases
-# Copyright (C) 2001-2012 OTRS AG, http://otrs.org/
+# Copyright (C) 2001-2013 OTRS AG, http://otrs.org/
# --
# $Id$
@@ -561,5 +561,5 @@
}
elsif ( $Self->{Backend}->{'DB::Limit'} eq 'top' ) {
- $SQL =~ s{ \A SELECT }{SELECT TOP $Limit}xmsi;
+ $SQL =~ s{ \A (SELECT ([ ]DISTINCT|)) }{$1 TOP $Limit}xmsi;
}
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