doctrine / dbal

        self::assertEquals('SELECT n FROM Foo LIMIT 18446744073709551615 OFFSET 10', $sql);

    }

    public function testGenerateMixedCaseTableCreate() : void

    {

        $table = new Table('Foo');

        $table->addColumn('Bar', 'integer');

        $sql = $this->platform->getCreateTableSQL($table);

        self::assertEquals('CREATE TABLE Foo (Bar INT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB', array_shift($sql));

    }

    public function getGenerateTableSql() : string

    {

        self::assertEquals('DROP TABLE foobar', $this->platform->getDropTableSQL('foobar'));

    }

    public function testGenerateTableWithAutoincrement() : void

    {

        $table  = new Table('autoinc_table');

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

        $column->setAutoincrement(true);

        self::assertEquals(['CREATE TABLE autoinc_table (id SERIAL NOT NULL)'], $this->platform->getCreateTableSQL($table));

    }

    /**

     * @return mixed[][]