doctrine/archived-orm
1
0
Fork 0
mirror of https://github.com/doctrine/orm.git synced 2026-03-24 06:52:09 +01:00
Code Issues 5.3k Packages Projects Releases 100 Wiki Activity

[PR #1138] Join column index names #9196

New Issue
Open
opened 2026-01-22 16:03:33 +01:00 by admin · 0 comments
admin commented 2026-01-22 16:03:33 +01:00
Owner
Copy Link

Original Pull Request: https://github.com/doctrine/orm/pull/1138

State: closed
Merged: No

@Ocramius recommended I open this up to discuss the issue I am seeing.

I am trying to explicitly name the index on a column which is used in a join. I've attempted to add two functional tests in this PR to demonstrate what I am seeing. Please forgive me if these tests are not correctly, this is the first time I've attempted to submit a PR like this.

There are two situations I am encountering...

First, I explicitly name the index in the @Table annotation on the column used in the join - but the SQL generated from SchemaTool appears to be a random hash.

Second, when I have an existing database table with an existing index and it's named properly (in this example, idx_maker_id) and then I run SchemaTool->updateSchema() it drops the index with the proper name and creates a new randomly hashed name.

Is there a different way of accomplishing what I am trying to do here, or is this a bug?

Thanks for your help and assistance!

**Original Pull Request:** https://github.com/doctrine/orm/pull/1138 **State:** closed **Merged:** No --- @Ocramius recommended I open this up to discuss the issue I am seeing. I am trying to explicitly name the index on a column which is used in a join. I've attempted to add two functional tests in this PR to demonstrate what I am seeing. Please forgive me if these tests are not correctly, this is the first time I've attempted to submit a PR like this. There are two situations I am encountering... First, I explicitly name the index in the `@Table` annotation on the column used in the join - but the SQL generated from `SchemaTool` appears to be a random hash. Second, when I have an existing database table with an existing index and it's named properly (in this example, idx_maker_id) and then I run `SchemaTool->updateSchema()` it drops the index with the proper name and creates a new randomly hashed name. Is there a different way of accomplishing what I am trying to do here, or is this a bug? Thanks for your help and assistance!
admin added the pull-request label 2026-01-22 16:03:33 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
BC Break
Bug
Can't Fix
Deprecation
Documentation
DQL
Duplicate
Failing Test
Hacktoberfest
Improvement
Improvement
Incomplete
Invalid
Missing Tests
New Feature
PR Created
pull-request
Mirrored from GitHub Pull Request
 Question
Regression
Status: Waiting feedback
Waiting feedback
WIP
Won't Fix
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
admin
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#9196
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?