public function testQueryLimit()
{
$query = $this->dm->createPhpcrQuery('SELECT * FROM [nt:unstructured] WHERE ISCHILDNODE("/functional") ORDER BY username', \PHPCR\Query\QueryInterface::JCR_SQL2);
$this->assertInstanceOf('PHPCR\\Query\\QueryInterface', $query);
$query->setLimit(2);
$result = $this->dm->getDocumentsByPhpcrQuery($query, $this->type);
$this->assertCount(2, $result);
$ids = array();
$vals = array();
$nums = array();
foreach ($result as $obj) {
$this->assertInstanceOf('Doctrine\\Tests\\ODM\\PHPCR\\Functional\\QuerySql2TestObj', $obj);
$ids[] = $obj->id;
$vals[] = $obj->username;
$nums[] = $obj->numbers;
}
$this->assertEquals(array('/functional/node5', '/functional/node1'), $ids);
$this->assertEquals(array(null, 'dbu'), $vals);
$this->assertEquals(array(array(3, 1, 2), array(3, 1, 2)), $nums);
}
