doctrine / dbal

    /**

     * @group 2916

     */

    public function testAlterTableAutoIncrementIntToBigInt() : void

    {

        $tableFrom = new Table('autoinc_table_int_to_bigint');

        $column = $tableFrom->addColumn('id', 'integer');

        $column->setAutoincrement(true);

        $this->_sm->createTable($tableFrom);

        $tableFrom = $this->_sm->listTableDetails('autoinc_table_int_to_bigint');

        self::assertTrue($tableFrom->getColumn('id')->getAutoincrement());

        $tableTo = new Table('autoinc_table_int_to_bigint');

        $column = $tableTo->addColumn('id', 'bigint');

        $column->setAutoincrement(true);

        $c = new Comparator();

        $diff = $c->diffTable($tableFrom, $tableTo);

        self::assertInstanceOf(TableDiff::class, $diff, "There should be a difference and not false being returned from the table comparison");

        self::assertSame(["ALTER TABLE autoinc_table_int_to_bigint ALTER id TYPE BIGINT"], $this->_conn->getDatabasePlatform()->getAlterTableSQL($diff));

        $this->_sm->alterTable($diff);

        $tableFinal = $this->_sm->listTableDetails('autoinc_table_int_to_bigint');

        self::assertTrue($tableFinal->getColumn('id')->getAutoincrement());

    }

    /**

     * @group 2916

    /**

     * @group 2916

     */

    public function testAlterTableAutoIncrementBigIntToInt() : void

    {

        $tableFrom = new Table('autoinc_table_bigint_to_int');

        $column = $tableFrom->addColumn('id', 'bigint');

        $column->setAutoincrement(true);

        $this->_sm->createTable($tableFrom);

        $tableFrom = $this->_sm->listTableDetails('autoinc_table_bigint_to_int');

        self::assertTrue($tableFrom->getColumn('id')->getAutoincrement());

        $tableTo = new Table('autoinc_table_bigint_to_int');

        $column = $tableTo->addColumn('id', 'integer');

        $column->setAutoincrement(true);

        $c = new Comparator();

        $diff = $c->diffTable($tableFrom, $tableTo);

        self::assertInstanceOf(TableDiff::class, $diff, "There should be a difference and not false being returned from the table comparison");

        self::assertSame(["ALTER TABLE autoinc_table_bigint_to_int ALTER id TYPE INT"], $this->_conn->getDatabasePlatform()->getAlterTableSQL($diff));

        $this->_sm->alterTable($diff);

        $tableFinal = $this->_sm->listTableDetails('autoinc_table_bigint_to_int');

        self::assertTrue($tableFinal->getColumn('id')->getAutoincrement());

    }

}

class MoneyType extends Type