DBAL-1082: SchemaTool does not generate DDL for MySQL unsigned float

[doctrinebot]

Jira issue originally created by user dchesterton:

The schema update tool does not consider the possibility that MySQL double/float fields can be unsigned.

When running the CLI tool, it recognises that the schemas differ but it doesn't add the appropriate 'UNSIGNED' SQL statement. For example when the database is SIGNED but the entity is marked as UNSIGNED, running the tool with --dump-sql will generate SQL similar to below:

ALTER TABLE tablename CHANGE field field DOUBLE PRECISION NOT NULL;

Running this has no effect on the database and subsequent calls will try to run the same SQL.

I have created a pull request in GitHub which fixes the issue.

[doctrinebot]

• is referenced by DBAL-1083: [GH-749] [DBAL-1082] Fix SchemaTool does not generate SQL for MySQL unsigned float

[doctrinebot]

Issue was closed with resolution "Fixed"

[doctrinebot]

Comment created by patkar:

Can I backport the fix to the 2.5 branch?

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.