The command doctrine:schema:update doesn't see what field already MEDIUMTEXT

[dmytroboiko]

I have a field which I want to be mysql mediumtext
Example.orm.yaml

AppBundle\Entity\Example:
    type: entity
    table: example
    id:
        id:
            type: bigint
            id: true
            generator:
                strategy: AUTO
            options:
                unsigned: true
    fields:
        description:
            column: description
            type: string
            length: 1.5E6

Everything is fine, field created as 'mediumtext'
but whenever I run
php bin/console doctrine:schema:update --dump-sql

I get
ALTER TABLE table CHANGE description description MEDIUMTEXT NOT NULL;
though description is MEDIUMTEXT already.

[coudenysj]

Could you paste the "CREATE TABLE" sql (from without your database)?

[dmytroboiko]

@coudenysj

CREATE TABLE example (
    id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
    description MEDIUMTEXT NOT NULL,
    PRIMARY KEY (id)
)  DEFAULT CHARACTER SET UTF8 COLLATE UTF8_UNICODE_CI ENGINE=INNODB

[lcobucci]

@dmytroboiko have you tried to use the type that the documentation recommends (text)? http://docs.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/types.html#character-string-types

[dmytroboiko]

@lcobucci, Yes I tried. But if I setted type: text and length: 1.5E6. Command php bin/console doctrine:schema:update --dump-sql create field description with type TEXT independently of the length settings

[lcobucci]

@dmytroboiko this sounds like a DBAL issue then, can you please send us a PR over there with a failing test case?

[lcobucci]

I'll also close this issue since it doesn't seem to be related to the ORM, don't forget to add a link to it on the DBAL PR.