doctrine / orm

        $this->assertEquals(600000, $result[1][1]);

    }

    public function testOrderByResultVariableCollectionSize()

    {

        $dql = 'SELECT p.name, size(p.friends) AS friends ' .

               'FROM Doctrine\Tests\Models\Company\CompanyPerson p ' .

               'WHERE p.friends IS NOT EMPTY ' .

               'ORDER BY friends DESC, p.name DESC';

        $result = $this->_em->createQuery($dql)->getScalarResult();

        $this->assertEquals(4, count($result));

        $this->assertEquals("Jonathan W.", $result[0]['name']);

        $this->assertEquals(3, $result[0]['friends']);

        $this->assertEquals('Guilherme B.', $result[1]['name']);

        $this->assertEquals(2, $result[1]['friends']);

        $this->assertEquals('Benjamin E.', $result[2]['name']);

        $this->assertEquals(2, $result[2]['friends']);

        $this->assertEquals('Roman B.', $result[3]['name']);

        $this->assertEquals(1, $result[3]['friends']);

    }

    public function testIsNullAssociation()

    {

        $this->assertEquals(25, $result[3]['namedeplength']);

    }

    public function testFunctionLocate()

    {

        $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 ".

               "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC";

        $result = $this->_em->createQuery($dql)

                         ->getArrayResult();

        $this->assertEquals(4, count($result));

        $this->assertEquals(0, $result[0]['loc']);

        $this->assertEquals(2, $result[1]['loc']);

        $this->assertEquals(6, $result[2]['loc']);

        $this->assertEquals(0, $result[3]['loc']);

        $this->assertEquals(0, $result[0]['loc2']);

        $this->assertEquals(10, $result[1]['loc2']);

        $this->assertEquals(9, $result[2]['loc2']);

        $this->assertEquals(0, $result[3]['loc2']);

    }

    public function testFunctionLower()

    {

        $this->assertEquals('JONATHAN W.', $result[3]['uppername']);

    }

    public function testFunctionSubstring()

    {

        $dql = "SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 ".

                "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name";

        $result = $this->_em->createQuery($dql)

                         ->getArrayResult();

        $this->assertEquals(4, count($result));

        $this->assertEquals('Ben', $result[0]['str1']);

        $this->assertEquals('Gui', $result[1]['str1']);

        $this->assertEquals('Jon', $result[2]['str1']);

        $this->assertEquals('Rom', $result[3]['str1']);

        $this->assertEquals('amin E.', $result[0]['str2']);

        $this->assertEquals('herme B.', $result[1]['str2']);

        $this->assertEquals('than W.', $result[2]['str2']);

        $this->assertEquals('n B.', $result[3]['str2']);

    }

    public function testFunctionTrim()

    {