#1640: Foreign Keys for Self-referencing (Nest relations) not created for both
columns
-----------------------------------+----------------------------------------
Reporter: hal | Owner: romanb
Type: defect | Status: new
Priority: major | Milestone: 1.0.5
Component: Relations | Version: 1.0.3
Keywords: | Has_test: 0
Mystatus: Pending Core Response | Has_patch: 0
-----------------------------------+----------------------------------------
Platform: Win XP Pro SP2, PHP: 5.2.5, DBMS: Postgresql 8.3.1, Symfony:
1.1.5-DEV, Doctrine: 1.0.3,
Note: This example is tested using symfony, by building the schema.yml
file and then executing the following command: symfony doctrine:build-all-
reload appname
This ticket has been moved from http://trac.symfony-
project.org/ticket/4824, after jwage confirmed that it is a doctrine
rather than a sfDoctrinePlugin bug.
The example code at http://www.doctrine-
project.org/documentation/manual/1_0/?one-page#relations:join-table-
associations:self-referencing-nest-relations:non-equal-nest-relations does
not seem to work correctly. When the database has been created and sql
inserted, the UserReference? table only has one foreign key to the User
table, rather than a FK on both of its columns. This does not correctly
enforce data integrity
As I presume this is an oversight in the code rather than simply in the
documentation, I have raised it as a defect rather than an enhancement
request due its severity, bearing in mind that it could have impacts on
the robustness of the relationship and hence accuracy of user data.
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1640>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
