doctrine / dbal

        self::assertEquals(sprintf(self::$selectFromCtePattern, $alteredSql, 1, 10), $sql);

    }

    public function testModifyLimitQueryWithOffset()

    {

        if ( ! $this->_platform->supportsLimitOffset()) {

            $this->markTestSkipped(sprintf('Platform "%s" does not support offsets in result limiting.', $this->_platform->getName()));

        }

        $querySql = 'SELECT * FROM user ORDER BY username DESC';

        $alteredSql = 'SELECT TOP 15 * FROM user ORDER BY username DESC';

        $sql = $this->_platform->modifyLimitQuery($querySql, 10, 5);

        self::assertEquals(sprintf(self::$selectFromCtePattern, $alteredSql, 6, 15), $sql);

    }

    public function testModifyLimitQueryWithAscOrderBy()

    {

    /**

     * @group DDC-2470

     */

    public function testModifyLimitQueryWithOrderByClause()

    {

        if ( ! $this->_platform->supportsLimitOffset()) {

            $this->markTestSkipped(sprintf('Platform "%s" does not support offsets in result limiting.', $this->_platform->getName()));

        }

        $sql        = 'SELECT m0_.NOMBRE AS NOMBRE0, m0_.FECHAINICIO AS FECHAINICIO1, m0_.FECHAFIN AS FECHAFIN2 FROM MEDICION m0_ WITH (NOLOCK) INNER JOIN ESTUDIO e1_ ON m0_.ESTUDIO_ID = e1_.ID INNER JOIN CLIENTE c2_ ON e1_.CLIENTE_ID = c2_.ID INNER JOIN USUARIO u3_ ON c2_.ID = u3_.CLIENTE_ID WHERE u3_.ID = ? ORDER BY m0_.FECHAINICIO DESC';

        $alteredSql = 'SELECT TOP 15 m0_.NOMBRE AS NOMBRE0, m0_.FECHAINICIO AS FECHAINICIO1, m0_.FECHAFIN AS FECHAFIN2 FROM MEDICION m0_ WITH (NOLOCK) INNER JOIN ESTUDIO e1_ ON m0_.ESTUDIO_ID = e1_.ID INNER JOIN CLIENTE c2_ ON e1_.CLIENTE_ID = c2_.ID INNER JOIN USUARIO u3_ ON c2_.ID = u3_.CLIENTE_ID WHERE u3_.ID = ? ORDER BY m0_.FECHAINICIO DESC';

        $actual     = $this->_platform->modifyLimitQuery($sql, 10, 5);

        self::assertEquals(sprintf(self::$selectFromCtePattern, $alteredSql, 6, 15), $actual);

    }

    /**

     * @group DBAL-713