doctrine / dbal

        $this->assertLimitResult(array(2), $sql, 1, 1);

    }

    public function testModifyLimitQuerySubSelect()

    {

        $this->_conn->insert('modify_limit_table', array('test_int' => 1));

        $this->_conn->insert('modify_limit_table', array('test_int' => 2));

        $this->_conn->insert('modify_limit_table', array('test_int' => 3));

        $this->_conn->insert('modify_limit_table', array('test_int' => 4));

        $sql = "SELECT modify_limit_table.*, (SELECT COUNT(*) FROM modify_limit_table) AS cnt FROM modify_limit_table ORDER BY test_int DESC";

        $this->assertLimitResult(array(4, 3, 2, 1), $sql, 10, 0);

        $this->assertLimitResult(array(4, 3), $sql, 2, 0);

        $this->assertLimitResult(array(2, 1), $sql, 2, 2);

    }

    public function testModifyLimitQueryFromSubSelect()

    {

        $this->assertLimitResult(array(2, 1), $sql, 2, 2);

    }

    public function testModifyLimitQueryFromSubSelect()

    {

        $this->_conn->insert('modify_limit_table', array('test_int' => 1));

        $this->_conn->insert('modify_limit_table', array('test_int' => 2));

        $this->_conn->insert('modify_limit_table', array('test_int' => 3));

        $this->_conn->insert('modify_limit_table', array('test_int' => 4));

        $sql = "SELECT * FROM (SELECT * FROM modify_limit_table) sub ORDER BY test_int DESC";

        $this->assertLimitResult(array(4, 3, 2, 1), $sql, 10, 0);

        $this->assertLimitResult(array(4, 3), $sql, 2, 0);

        $this->assertLimitResult(array(2, 1), $sql, 2, 2);

    }

    public function testModifyLimitQueryLineBreaks()

    {