DDC-3478: [GH-1239] Fix index duplication for unique association join columns #4285

Closed
opened 2026-01-22 14:38:45 +01:00 by admin · 4 comments
Owner

Originally created by @doctrinebot on GitHub (Jan 8, 2015).

Originally assigned to: @Ocramius on GitHub.

Jira issue originally created by user @doctrinebot:

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

Url: https://github.com/doctrine/doctrine2/pull/1239

Message:

Complementary fix for recent DBAL change: fc8beca086 (commitcomment-9201441)
Avoids index duplication for association mappings using unique join columns. Unique constraints to be created for the join columns are now added before adding the foreign key constraint, so that adding the fk doesn't trigger an implicit index creation.
I did not add any further tests as the current failure already reveals the issue.

Originally created by @doctrinebot on GitHub (Jan 8, 2015). Originally assigned to: @Ocramius on GitHub. Jira issue originally created by user @doctrinebot: This issue is created automatically through a Github pull request on behalf of deeky666: Url: https://github.com/doctrine/doctrine2/pull/1239 Message: Complementary fix for recent DBAL change: https://github.com/doctrine/dbal/commit/fc8beca08600b44e46f7b82998adbcc6d52c31f1#commitcomment-9201441 Avoids index duplication for association mappings using unique join columns. Unique constraints to be created for the join columns are now added before adding the foreign key constraint, so that adding the fk doesn't trigger an implicit index creation. I did not add any further tests as the current failure already reveals the issue.
admin added the Bug label 2026-01-22 14:38:45 +01:00
admin closed this issue 2026-01-22 14:38:45 +01:00
Author
Owner
@doctrinebot commented on GitHub (Jan 8, 2015): - relates to [DBAL-50: PgSQL driver does not create indexes on foreign key columns](http://www.doctrine-project.org/jira/browse/DBAL-50) - relates to [DBAL-1063: Exceptions from SchemaTool when running with DBAL 2.5.0](http://www.doctrine-project.org/jira/browse/DBAL-1063)
Author
Owner

@doctrinebot commented on GitHub (Jan 8, 2015):

Comment created by @doctrinebot:

A related Github Pull-Request [GH-1239] was assigned:
https://github.com/doctrine/doctrine2/pull/1239

@doctrinebot commented on GitHub (Jan 8, 2015): Comment created by @doctrinebot: A related Github Pull-Request [GH-1239] was assigned: https://github.com/doctrine/doctrine2/pull/1239
Author
Owner

@doctrinebot commented on GitHub (Jan 9, 2015):

Comment created by @doctrinebot:

A related Github Pull-Request [GH-1239] was merged:
https://github.com/doctrine/doctrine2/pull/1239

@doctrinebot commented on GitHub (Jan 9, 2015): Comment created by @doctrinebot: A related Github Pull-Request [GH-1239] was merged: https://github.com/doctrine/doctrine2/pull/1239
Author
Owner

@doctrinebot commented on GitHub (Jan 9, 2015):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Jan 9, 2015): Issue was closed with resolution "Fixed"
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#4285