doctrine / dbal

        return 'ALTER TABLE test ADD FOREIGN KEY (fk_name_id) REFERENCES other_table (id)';

    }

    public function testModifyLimitQuery()

    {

        $querySql = 'SELECT * FROM user';

        $alteredSql = 'SELECT TOP 10 * FROM user';

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

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

    }

    public function testModifyLimitQueryWithEmptyOffset()

    {

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

    }

    public function testModifyLimitQueryWithEmptyOffset()

    {

        $querySql = 'SELECT * FROM user';

        $alteredSql = 'SELECT TOP 10 * FROM user';

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

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

    }

    public function testModifyLimitQueryWithOffset()

    {

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

    }

    public function testModifyLimitQueryWithAscOrderBy()

    {

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

        $alteredSql = 'SELECT TOP 10 * FROM user ORDER BY username ASC';

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

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

    }

    public function testModifyLimitQueryWithLowercaseOrderBy()

    {

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

    }

    public function testModifyLimitQueryWithLowercaseOrderBy()

    {

        $querySql = 'SELECT * FROM user order by username';

        $alteredSql = 'SELECT TOP 10 * FROM user order by username';

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

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

    }

    public function testModifyLimitQueryWithDescOrderBy()

    {

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

    }

    public function testModifyLimitQueryWithDescOrderBy()

    {

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

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

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

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

    }

    public function testModifyLimitQueryWithMultipleOrderBy()

    {

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

    }

    public function testModifyLimitQueryWithMultipleOrderBy()

    {

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

        $alteredSql = 'SELECT TOP 10 * FROM user ORDER BY username DESC, usereamil ASC';

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

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

    }

    public function testModifyLimitQueryWithSubSelect()

    {

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

    }

    public function testModifyLimitQueryWithSubSelect()

    {

        $querySql = 'SELECT * FROM (SELECT u.id as uid, u.name as uname) 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);

    }

    public function testModifyLimitQueryWithSubSelectAndOrder()

    {

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

    }

    public function testModifyLimitQueryWithFromColumnNames()

    {

        $querySql = 'SELECT a.fromFoo, fromBar FROM foo';

        $alteredSql = 'SELECT TOP 10 a.fromFoo, fromBar FROM foo';

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

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

    }

    /**

     * @group DBAL-927