DDC-3711: Error on manyToMany with composite primary key #4557

New Issue

Closed

opened 2026-01-22 14:44:42 +01:00 by admin · 8 comments

admin commented 2026-01-22 14:44:42 +01:00

Owner

Copy Link

Originally created by @doctrinebot on GitHub (Apr 23, 2015).

Originally assigned to: @Ocramius on GitHub.

Jira issue originally created by user pantelm:

Hi,
I hope that I report in the right place.
I have an issue when I try to create an manyToMany association with an entity with a composite primary key.
The problem is that only one of the two key are create on the association table.

I also have manyToOne association that works fine.

Here are the mapping

Commune.orm.yml

AppDemo\ZoneBundle\Entity\Commune:
    type: entity
    table: ref_commune
    id:
        codeInsee:
            type: string
            nullable: false
            length: 5
            fixed: true
            column: commune*code*insee
        codePostal:
            type: string
            nullable: false
            length: 5
            fixed: true
            column: commune*code*postal
    fields:
        nom:
            type: string
            nullable: false
            length: 100
            fixed: false
            column: commune_nom
    manyToMany:
        zones:
            targetEntity: Zone
            joinTable:
                name: lnk*zone*commune
                joinColumns:
                    commune*code*insee:
                        referencedColumnName: commune*code*insee
                    commune*code*postal:
                        referencedColumnName: commune*code*postal
                inverseJoinColumns:
                    zone_id:
                        referencedColumnName: zone_idx

Zone.orm.yml

AppDemo\ZoneBundle\Entity\Zone:
    type: entity
    repositoryClass: AppDemo\ZoneBundle\Repository\ZoneRepository
    table: ref_zone
    id:
        idx:
            type: integer
            nullable: false
            unsigned: false
            comment: ''
            id: true
            column: zone_idx
            generator:
                strategy: IDENTITY
    fields:
        libelle:
            type: string
            nullable: false
            length: 30
            options:
                default: ''
                comment: 'Libelle de la Zone'

Originally created by @doctrinebot on GitHub (Apr 23, 2015). Originally assigned to: @Ocramius on GitHub. Jira issue originally created by user pantelm: Hi, I hope that I report in the right place. I have an issue when I try to create an manyToMany association with an entity with a composite primary key. The problem is that only one of the two key are create on the association table. I also have manyToOne association that works fine. Here are the mapping `Commune.orm.yml` ``` AppDemo\ZoneBundle\Entity\Commune: type: entity table: ref_commune id: codeInsee: type: string nullable: false length: 5 fixed: true column: commune*code*insee codePostal: type: string nullable: false length: 5 fixed: true column: commune*code*postal fields: nom: type: string nullable: false length: 100 fixed: false column: commune_nom manyToMany: zones: targetEntity: Zone joinTable: name: lnk*zone*commune joinColumns: commune*code*insee: referencedColumnName: commune*code*insee commune*code*postal: referencedColumnName: commune*code*postal inverseJoinColumns: zone_id: referencedColumnName: zone_idx ``` `Zone.orm.yml` ``` AppDemo\ZoneBundle\Entity\Zone: type: entity repositoryClass: AppDemo\ZoneBundle\Repository\ZoneRepository table: ref_zone id: idx: type: integer nullable: false unsigned: false comment: '' id: true column: zone_idx generator: strategy: IDENTITY fields: libelle: type: string nullable: false length: 30 options: default: '' comment: 'Libelle de la Zone' ```

admin added the Bug label 2026-01-22 14:44:42 +01:00

admin closed this issue 2026-01-22 14:44:42 +01:00

admin commented 2026-01-22 14:44:42 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Apr 23, 2015):

• depends on DDC-3972: [GH-1539] [DDC-3711] Correct Error on manyToMany with composite primary key

@doctrinebot commented on GitHub (Apr 23, 2015): - depends on [DDC-3972: [GH-1539] [DDC-3711] Correct Error on manyToMany with composite primary key](http://www.doctrine-project.org/jira/browse/DDC-3972)

admin commented 2026-01-22 14:44:44 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Apr 23, 2015):

Comment created by @ocramius:

What if you simply leave out the joinColumns mappings? Check what comes out of the metadata there, then compare it to your metadata (dump it)

@doctrinebot commented on GitHub (Apr 23, 2015): Comment created by @ocramius: What if you simply leave out the `joinColumns` mappings? Check what comes out of the metadata there, then compare it to your metadata (dump it)

admin commented 2026-01-22 14:44:44 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Apr 23, 2015):

Comment created by pantelm:

When I remove the JoinsColumns mapping, I get an error:

Column name id referenced for relation from AppBundle\Entity\Commune towards AppBundle\Entity\Zone does not exist.

How do I dump the metadata?

@doctrinebot commented on GitHub (Apr 23, 2015): Comment created by pantelm: When I remove the JoinsColumns mapping, I get an error: `Column name `id` referenced for relation from AppBundle\Entity\Commune towards AppBundle\Entity\Zone does not exist.` How do I dump the metadata?

admin commented 2026-01-22 14:44:44 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Oct 27, 2015):

Comment created by pantelm:

I have found where the problem come from, it just two line in the Yaml driver that are not in the loops that create columns for the join table.
I want to do a pull request but I have trouble writing test.

@doctrinebot commented on GitHub (Oct 27, 2015): Comment created by pantelm: I have found where the problem come from, it just two line in the Yaml driver that are not in the loops that create columns for the join table. I want to do a pull request but I have trouble writing test.

admin commented 2026-01-22 14:44:44 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Oct 31, 2015):

Comment created by pantelm:

I made a PR for this error
[https://github.com/doctrine/doctrine2/pull/1540]

@doctrinebot commented on GitHub (Oct 31, 2015): Comment created by pantelm: I made a PR for this error [https://github.com/doctrine/doctrine2/pull/1540]

admin commented 2026-01-22 14:44:44 +01:00

Author

Owner

Copy Link

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

Comment created by @doctrinebot:

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

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

admin commented 2026-01-22 14:44:45 +01:00

Author

Owner

Copy Link

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

Comment created by @doctrinebot:

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

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

admin commented 2026-01-22 14:44:46 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Aug 23, 2018):

Already handled in 2.4.7

@Ocramius commented on GitHub (Aug 23, 2018): Already handled in 2.4.7

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

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 Bug

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#4557