[otrs-cvs] otrs/scripts/test DB.t,1.99,1.100

"CVS commits notifications of OTRS.org" <[email protected]>
Newsgroups gmane.comp.otrs.cvs
Message-ID <[email protected]>
Comments:
Update of /home/cvs/otrs/scripts/test
In directory lancelot:/tmp/cvs-serv12335/scripts/test

Modified Files:
	DB.t 
Log Message:
Added unit test for SELECT DISTINCT with Limit.

Author: mb

Index: DB.t
===================================================================
RCS file: /home/cvs/otrs/scripts/test/DB.t,v
retrieving revision 1.99
retrieving revision 1.100
diff -2 -u -d -r1.99 -r1.100
--- DB.t	20 Nov 2012 16:05:58 -0000	1.99
+++ DB.t	17 Jan 2013 07:13:51 -0000	1.100
@@ -1,5 +1,5 @@
 # --
 # DB.t - database tests
-# Copyright (C) 2001-2012 OTRS AG, http://otrs.org/
+# Copyright (C) 2001-2013 OTRS AG, http://otrs.org/
 # --
 # $Id$
@@ -317,4 +317,18 @@
 
 $Self->True(
+    $DBObject->Prepare(
+        SQL   => 'SELECT DISTINCT * FROM test_aa WHERE name_a = \'Some\'',
+        Limit => 1,
+    ),
+    '#1 Prepare() SELECT DISTINCT - Limit - Prepare',
+);
+
+$Self->True(
+    ref( $DBObject->FetchrowArray() ) eq '' &&
+        ref( $DBObject->FetchrowArray() ) eq '',
+    '#1 FetchrowArray () SELECT DISTINCT - Limit',
+);
+
+$Self->True(
     $DBObject->Do(
         SQL => 'DELETE FROM valid WHERE name = \'Some\'',
---------------------------------------------------------------------
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.