DBAL-1108: [GH-769] Allow overriding implicit indexes

[doctrinebot]

Jira issue originally created by user @doctrinebot:

This issue is created automatically through a Github pull request on behalf of deeky666:

Url: #769

Message:

This is a follow-up patch for the change introduced in #764.
It makes the Table class act more intelligent when it comes to preferring explicit over implicit indexes.
Currently it is necessary to construct a Table instance in a specific order to not have unnecessary duplicate indexes because of foreign keys. If you first add a foreign key and afterwards and explicit index that is fulfilling the implicit one, both indexes are stored. Instead it is more intelligent to replace the implicit by the explicit one if and only if the explicit one fulfills the implicit one.
This should also fix possible issues with how ORM's schema tool constructs a schema. See here where for a OneToOne relation on a primary key an additional regular index for the foreign key is created.

[doctrinebot]

• is required for DDC-2989: ORM should allow custom index names for foreign associations.
• is duplicated by DDC-3310: [GH-1138] Join column index names
• relates to DBAL-1063: Exceptions from SchemaTool when running with DBAL 2.5.0
• relates to DBAL-1102: [GH-764] [DBAL-1063] Allow defining duplicate indexes on a table

[doctrinebot]

Comment created by @doctrinebot:

A related Github Pull-Request [GH-769] was assigned:
#769

[doctrinebot]

Comment created by @doctrinebot:

A related Github Pull-Request [GH-769] was merged:
#769

[doctrinebot]

Issue was closed with resolution "Fixed"

[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.