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); }