DDC-1587: Foreign key as Primary does not work as intended #1991

New Issue

admin · 2026-01-22T13:36:34+01:00

admin commented

2026-01-22 13:36:34 +01:00

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

Originally assigned to: @guilhermeblanco on GitHub.

Jira issue originally created by user presteus:

Hi,

In first time, sorry for my bad english.

The feature Foreign key as Primary does not work as intended.

The CLI tool report an error on validating mapping:
The referenced column name 'pk_agent' does not have a corresponding field with this column name on the class 'BddP\Model\Entity\Sd\Contact'.

If I run the application, many features works: querying, entity population.
But for persist a new Agent without associated entities for OneToOne; the ORM report :
PDOException: SQLSTATE[23502]: Not null violation on "pk" column

And If I comment all OneToOne, the persist work.

Thank you in advance for your response.

/****
 * @Entity(repositoryClass="BddP\Model\Entity\Repository\Sd\Agent")
 * @Table(name="agent")
 */
class Agent extends AEntity
{
    /****
     * Agent ID
     * @var int
     *
     * @Id
     * @GeneratedValue
     * @Column(name="pk", type="integer", nullable=false)
     */
    private $pk;
    /****
     * @var BddP\Model\Entity\Sd\Contact
     *
     * @OneToOne(targetEntity="BddP\Model\Entity\Sd\Contact", cascade={"remove,merge,detach"}, mappedBy="agent")
     * @JoinColumn(name="pk", referencedColumnName="pk_agent")
     */
    private $contact;

    [...]

}

/****
 * @Table(name="contact")
 */
class Contact extends AEntity
{
    /****
     * The agent
     * @var BddP\Model\Entity\Sd\Agent
     *
     * @Id
     * @OneToOne(targetEntity="BddP\Model\Entity\Sd\Agent", inversedBy="contact")
     * @JoinColumn(name="pk_agent", referencedColumnName="pk")
     */
    private $agent;

    [...]

}

Originally created by @doctrinebot on GitHub (Jan 8, 2012). Originally assigned to: @guilhermeblanco on GitHub. Jira issue originally created by user presteus: Hi, In first time, sorry for my bad english. The feature Foreign key as Primary does not work as intended. The CLI tool report an error on validating mapping: **The referenced column name 'pk_agent' does not have a corresponding field with this column name on the class 'BddP\Model\Entity\Sd\Contact'.** If I run the application, many features works: querying, entity population. But for persist a new Agent without associated entities for OneToOne; the ORM report : **PDOException: SQLSTATE[23502]: Not null violation on "pk" column** And If I comment all OneToOne, the persist work. Thank you in advance for your response. ``` /**** * @Entity(repositoryClass="BddP\Model\Entity\Repository\Sd\Agent") * @Table(name="agent") */ class Agent extends AEntity { /**** * Agent ID * @var int * * @Id * @GeneratedValue * @Column(name="pk", type="integer", nullable=false) */ private $pk; /**** * @var BddP\Model\Entity\Sd\Contact * * @OneToOne(targetEntity="BddP\Model\Entity\Sd\Contact", cascade={"remove,merge,detach"}, mappedBy="agent") * @JoinColumn(name="pk", referencedColumnName="pk_agent") */ private $contact; [...] } ``` ``` /**** * @Table(name="contact") */ class Contact extends AEntity { /**** * The agent * @var BddP\Model\Entity\Sd\Agent * * @Id * @OneToOne(targetEntity="BddP\Model\Entity\Sd\Agent", inversedBy="contact") * @JoinColumn(name="pk_agent", referencedColumnName="pk") */ private $agent; [...] } ```

admin added the Bug label 2026-01-22 13:36:34 +01:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#1991