#1097: identity column in MS SQL is improperly flagged as primary key.
----------------------------+-----------------------------------------------
Reporter: sgriffin | Owner: jwage
Type: defect | Status: closed
Priority: minor | Milestone: 1.0.4
Component: Import/Export | Version: 1.0.2
Resolution: invalid | Keywords:
Has_test: 0 | Mystatus: Pending User Response
Has_patch: 0 |
----------------------------+-----------------------------------------------
Changes (by guilhermeblanco):
* status: new => closed
* mystatus: Pending Core Response => Pending User Response
* resolution: => invalid
Old description:
> Doctrine0.10.4-Sandbox
>
> After horsing around with lib/Doctrine/DataDict/Mssql.php to get Doctrine
> to import my existing MS SQL database I noticed that the generated
> Doctrine_Record classes had flagged identity columns (auto incrementing
> integers) as the primary key. The truth of the matter is that in many of
> my tables there is a uniqueidentifier column that is flagged as the
> primary key.
>
> I don't know how this is designated in the meta-data in SQL Server.
>
> If both a column with ROWGUIDCOL is present and a column with identity is
> present the one actually flagged as the primary key should be considered
> the primary key.
New description:
Doctrine0.10.4-Sandbox
After horsing around with lib/Doctrine/DataDict/Mssql.php to get Doctrine
to import my existing MS SQL database I noticed that the generated
Doctrine_Record classes had flagged identity columns (auto incrementing
integers) as the primary key. The truth of the matter is that in many of
my tables there is a uniqueidentifier column that is flagged as the
primary key.
I don't know how this is designated in the meta-data in SQL Server.
If both a column with ROWGUIDCOL is present and a column with identity is
present the one actually flagged as the primary key should be considered
the primary key.
Comment:
Does this issue still persist? If yes, reopen the ticket and attach the
patch file.
You can attach the patch by click on Attach file button right under the
ticket information box, but you must be logged in to do that.
Regards,
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1097#comment:8>
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
-~----------~----~----~----~------~----~------~--~---
