doctrine / dbal

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

    }

    public function testModifyLimitQueryWithSubSelectAndOrder()

    {

        $querySql = 'SELECT * FROM (SELECT u.id as uid, u.name as uname ORDER BY u.name DESC) dctrn_result';

        $alteredSql = 'SELECT TOP 10 * FROM (SELECT u.id as uid, u.name as uname) dctrn_result';

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

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

        $querySql = 'SELECT * FROM (SELECT u.id, u.name ORDER BY u.name DESC) dctrn_result';

        $alteredSql = 'SELECT TOP 10 * FROM (SELECT u.id, u.name) dctrn_result';

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

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

    }

    public function testModifyLimitQueryWithSubSelectAndMultipleOrder()

    {

        );

    }

    public function testModifyLimitQueryWithTopNSubQueryWithOrderBy()

    {

        $querySql = 'SELECT * FROM test t WHERE t.id = (SELECT TOP 1 t2.id FROM test t2 ORDER BY t2.data DESC)';

        $alteredSql = 'SELECT TOP 10 * FROM test t WHERE t.id = (SELECT TOP 1 t2.id FROM test t2 ORDER BY t2.data DESC)';

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

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

        $querySql = 'SELECT * FROM test t WHERE t.id = (SELECT TOP 1 t2.id FROM test t2 ORDER BY t2.data DESC) ORDER BY t.data2 DESC';

        $alteredSql = 'SELECT TOP 10 * FROM test t WHERE t.id = (SELECT TOP 1 t2.id FROM test t2 ORDER BY t2.data DESC) ORDER BY t.data2 DESC';

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

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

    }

    /**

     * @group DBAL-2436