sqlite id bigint about dbal HOT 4 OPEN

Please try to reproduce your issue using only DBAL APIs.

from dbal.

When using doctrine schema manager i get an array of data describing the column definition of a sqlite db file. ($schema_manager->listTableColumns($sanitized_table))

When using a combination of bigint with auto increment it is of integer type. When i remove the auto increment, it becomes a bigint.

[
    {
        "name": "id",
        "type": "IntegerType",
        "default": null,
        "notnull": true,
        "length": null,
        "precision": null,
        "scale": 0,
        "fixed": false,
        "unsigned": false,
        "autoincrement": true,
        "columnDefinition": null,
        "comment": ""
    },
...

also i needed to do this:

$record = $column->toArray();
$record['type'] = File::basename(get_class($column->getType()));

the type doesnt have a to string defined which should and be the same as in the schema/ entitiy defined so we can validate the creation of the table

the unsigned is false where it should be true, because of the autoincrement.

{
        "name": "id",
        "type": "BigIntType",
        "default": null,
        "notnull": true,
        "length": null,
        "precision": null,
        "scale": 0,
        "fixed": false,
        "unsigned": true,
        "autoincrement": false,
        "columnDefinition": null,
        "comment": ""
    },

from dbal.

@derrabus its $schema_manager->listTableColumns($stable); should the type not be casted to string ?

from dbal.

Here #6411 is a PR with fix and test.

from dbal.