neos-development-collection icon indicating copy to clipboard operation
neos-development-collection copied to clipboard

BUG: Index name differs between NodeData model definition and migration

Open dlubitz opened this issue 2 years ago • 0 comments

Is there an existing issue for this?

  • [X] I have searched the existing issues

Current Behavior

The index is named pathindex in the NodeData model.

https://github.com/neos/neos-development-collection/commit/bc0da4c065fff49aa0990489b5e97113cc737b2a

But named path within the migration:

https://github.com/neos/neos-development-collection/blob/master/Neos.ContentRepository/Migrations/Mysql/Version20190905074145.php

This forces the migration generation to generate to generate statements to rename the index:

        $this->addSql('DROP INDEX path ON neos_contentrepository_domain_model_nodedata');
        $this->addSql('CREATE INDEX pathindex ON neos_contentrepository_domain_model_nodedata (path(255))');

Expected Behavior

The index name in model and database should be the same and not force the migration generation to generate a change.

Steps To Reproduce

Generate a migration with

./flow doctrine:migrationgenerate

Environment

- Flow: 7.3
- Neos: 7.3
- PHP: 8.1

Anything else?

No response

dlubitz avatar Sep 12 '22 19:09 dlubitz