1 files changed, 38 insertions, 0 deletions
diff --git a/tests/unit/Data/SqlMap/queryForListLimitTest.php b/tests/unit/Data/SqlMap/queryForListLimitTest.php
new file mode 100644
index 00000000..7038dc68
--- /dev/null
+++ b/tests/unit/Data/SqlMap/queryForListLimitTest.php
@@ -0,0 +1,38 @@
+<?php
+
+require_once(dirname(__FILE__).'/BaseCase.php');
+
+/**
+ * @package System.Data.SqlMap
+ */
+class queryForListLimitTest extends BaseCase
+{
+	function __construct()
+	{
+		parent::__construct();
+
+		$this->initSqlMap();
+
+		//force autoload
+		new Account;
+	}
+
+	function resetDatabase()
+	{
+		$this->initScript('account-init.sql');
+	}
+
+	function test_accounts_limit_2()
+	{
+		$list1 = $this->sqlmap->queryForList('GetAllAccountsAsArrayListViaResultClass',null,null,1,2);
+		$this->assertEqual(count($list1),2);
+
+		$this->assertEqual($list1[0][0],'2');
+		$this->assertEqual($list1[0][1],'Averel');
+		$this->assertEqual($list1[0][2],'Dalton');
+
+		$this->assertEqual($list1[1][0],'3');
+		$this->assertEqual($list1[1][1],'William');
+		$this->assertEqual($list1[1][2],'Dalton');
+	}
+}