[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